mysql and <cftransaction>

[imstillatwork]

What Do i need to do to get this to work properly?
table Type is MYisam.

If i hit refresh a few times the insert will go, AND I also get the identity....

<cftransaction action=&quot;begin&quot;>
 <cfquery....>
  INSERT INTO....
 </cfquery>

 <cfquery....>
  SELECT @@identity AS ID
 </cfquery>

 <cftransaction action=&quot;commit&quot;></cftransaction>
 </cftransaction>

THANKS

 

[cfgoodies]

AFIAK, I don't think MySQL supports transactions (rollbacks). Look up "transactions" in the MySQL docs.

HTH,

Brad

 

[imstillatwork]

I have done more research, and MySQL will do formal transactions, BUT, you have to configure the server to support InnoDB table Types....Which I have yet to figure out in WINDOWS...