What he said... I also like to remove non alphanumeric chars :-) Another option would be to create your own uuid based on the current date and time (you could even get the time down to the millisecond with some java) and append or prepend the users ID to it. I dont foresee the same user adding 2 ads simultaneously ever
#Userid & dateformat(now(), 'mmddyyyy') & timeformat(now(), 'hhmmss')# It's unique and serves a purpose of letting you know exactly when it was created and by which user. Someone just posted the createobject() code to get the current time including the milliseconds but I cant remember it. Feel free to post it if you find it :-) ....just another option to kick around. Cheers. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 07, 2006 11:28 AM To: CF-Talk Subject: Re: SQL getting the next available ID yes thats what he's saying. Since you create the UUID yourself with createuuid() you can reference it early and often anytime, without any added cfqueries or whatever. I like to use a replace function to remove the underscores from the uuid, but thats as much personal preference as it is anything else. -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4