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:333192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
