I am using the cftransaction tags. Honestly, I was not absolutely sure that I needed to do anything else and that is why I posted my original question.
-----Original Message----- From: nvc 1 [mailto:[email protected]] Sent: Wednesday, April 28, 2010 4:14 PM To: cf-talk Subject: Re: SQL Gurus... obtaining the correct Incremental ID why can't you do this where mytable has an auto incrementing primary key called id: <cftransaction> <cfquery datasource="#dsn#" name="insertQuery"> insert into mytable(acolumn) values(1) </cfquery> <cfquery datasource="#dsn#" name="getid"> select max(id) as maxid from mytable </cfquery> </cftransaction> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
