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:295177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4