Rick, Autonumber doesn't "re-number" existing ids (does it??) ... Although it does mean that the numbers are not tightly sequential (there will be gaps).
-mark -----Original Message----- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, December 20, 2007 8:47 AM To: CF-Talk Subject: RE: Dynamic ID's The database does support autonumber, but this is a legacy app and database. Also, there are many times where autonumber isn't useful because when you delete a record, the database re-numbers everything changing the ID which we didn't want. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -----Original Message----- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: December-20-07 10:31 AM To: CF-Talk Subject: Re: Dynamic ID's Your db platform doesn't support autonumber? Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _____________________________ http://blog.cutterscrossing.com Rick Sanders 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:295196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4