Chris, I've used the method you describe for awhile and prefer it. Your post reminded me of another method that seems safe, but I never went there. CF_MaxID:
http://tinyclick.com/?T02MT2 You need a transaction block inside of a try/catch block inside of a loop to make it bombproof (:O) per the included docs, but it'll apparently work without adding a second indexed field to your table. ------------------------------------------- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com ------------------------------------------- ---------- Original Message ---------------------------------- From: Christian Cantrell <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Mon, 17 Mar 2003 15:22:12 -0500 >I posted some information on the createUUID function on my weblog today >based on an application I was working on over the weekend: > >http://www.markme.com/cantrell/weblog/index.cfm?m=3&d=17&y=2003 > >Christian > >On Monday, March 17, 2003, at 07:55 AM, FlashGuy wrote: > >> Hi, >> >> I need to generate a unique ID for every form I submit. The createUUID >> # generated is just too long for my needs. My ID only needs to be 10 >> characters in length. Something like: >> >> CT-0001001 >> >> I'm using MySQL. Can I have mysql generate the unique ID? How could I >> do this with CF? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
