If you need an absolute unique id that isn't tied to a database, feel free to use the createUUID() function. Otherwise, what you're asking for can be done via SQL... so... not sure why this is overcomplicated. Do you have a unique situation? care to explain?
On Dec 20, 2007 9:23 AM, 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:295174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4