Hey guys, Yup, this is a unique situation, it's a new application on top of an old database built in Pervasive SQL. The Primary key holds ID numbers that aren't auto generated.
The legacy app that sat on top of it was Tango 2000, and the way the ID was done was by querying the database, sorting the ID's in the resultset in numeric order, grabbing the last ID number and adding 1 to it. This actually worked very well. Kind regards, Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -----Original Message----- From: Todd [mailto:[EMAIL PROTECTED] Sent: December-20-07 10:31 AM To: CF-Talk Subject: Re: Dynamic ID's 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:295180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
