How about: <cfquery> LOCK TABLES tbl WRITE </cfquery>
<cfquery> Insert into Table </cfquery> <cfquery> SELECT MAX(id) FROM Table </cfquery> <cfquery> UNLOCK TABLES </cfquery> HTH Dave At 12:33 9/11/2002 +0200, you wrote: >At 12.32 11/09/2002, you wrote: > >something like > > > ><cftranaction> > > <cfquery> > > Insert into Table > > </cfquery> > > > > <cfquery> > > SELECT MAX(id) FROM Table > > </cfquery> > > > ></cftransation> > >Mysql without InnoDB doesn't support transaction. >Bye > >-------------------------------------------------- >FABIO SERRA - faser(at)faser.net >PGP available >-------------------------------------------------- > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
