You may also want to consider the use of sequences instead of an identity column (a la Oracle and others). I don't know if that is an option for you though.
Allen Alan Rother wrote: > Here are the help docs for your database type. > > http://www.h2database.com/html/functions.html#identity > > <http://www.h2database.com/html/functions.html#identity>In the same CFQUERY > as your insert do a select and follow the syntax indicated on that help > page. You also need to specify a name for your query so it can return the > resulting ID. > > > Keep in mind, in a high transaction environment, this may not always return > the ID of the row you just inserted, it could return another query's ID. > > > If you are going to have a high volume of transactions you may want to use > a separate query that looks for the data you just inserted > > =] > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4