Or, if you really need to do it the way you describe, the SQL could look like this:
-- SELECT A NEW ID SELECT Max(idField) + 1 FROM myTable But yeh, if you can set an auto id in the db I'd go with that. Dominic On 20/12/2007, JediHomer <[EMAIL PROTECTED]> wrote: > > How about an Identity field (in MS SQL) > > Or alternatively CreateUUID() ? > > > On 20/12/2007, Rick Sanders <[EMAIL PROTECTED]> wrote: > > Hello list, > > > > > > > > I've done dynamic ID's before in .net and xml. I can't seem to figure > out > > how to do it in CF. Here's what I want to do: > > > > > > > > - Query the database with the ID's. > > > > - Sort the ID's in proper numerical order > > > > - Grab the last ID (largest number which will be the last row > of > > the query) > > > > - Then, add 1 to the number > > > > > > > > If someone has a better idea for a unique ID, I'm open to suggestions. > > > > > > > > Happy Holidays! > > > > > > > > Rick Sanders > > > > Webenergy > > > > Canada: 902-401-7689 > > > > USA: 919-799-9076 > > > > Canada: www.webenergy.ca > > > > USA: www.webenergyusa.com > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4