Transactions - CF - Windows

[imstillatwork]

Hi,
I am using mysql with Cold Fusion In windows.
Everything works except my tranasactions. the ODBC error says transactions are disabled. How Do I enable the use of transactions? thanks

kevin

 

[sleipnir214]

This might be helpful:

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html

______________________________________________________________________
TANSTAAFL!

 

[imstillatwork]

Hmmm...kinda, not realy...thanks anyway
kevin

 

[sleipnir214]

If you have not specified that your table is of type InnoDB or BDB, then formal transactions are not available.

Is your table one of those types? ______________________________________________________________________
TANSTAAFL!

 

[imstillatwork]

oh, ok...they are MYISAM...I read somethinga bout that a few minutes ago...
I just installed this all last night, so its all new to me.

Any tips on changing them to innodb?

 

[imstillatwork]

the strange part is, that if i resend the same data again, (refresh the web page) it will commit fine ? ? ?