<cfquery>
declare @newid int
select @newid = max(id) from Members
if @newid is null
begin
set @newid=1
end
else
begin
set @[EMAIL PROTECTED]
end
INSERT INTO Members ...
</CFQUERY>
On 12/20/07 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:295179
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
