erm... I would say that they are unique. No UUID is the same by its very definition; thats the point...
<sic/> The mechanism used to guarantee that UUIDs are Unique is through combinations of hardware addresses, time stamps and random seeds. No two comps can generate the same UUID. "AFAIK" -----Original Message----- From: Sicular, Alexander [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:27 To: CF-Talk Subject: RE: Using createUUID() I wouldn't do that , first 4 chars of createuuid() are not unique. If you cat that with something else than _maybe_ you are doing a bit better. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:18 AM To: CF-Talk Subject: RE: Using createUUID() if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E- etc...) then you may be able to use newid() within mySQL, though I am not sure that it supports it. In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first 4 chars of a CF generated ID. HTH Neil -----Original Message----- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: 17 March 2003 13:04 To: CF-Talk Subject: RE: Using createUUID() Use the current date and add random numbers to the end: 03172003nn where 'nnn' are the random numbers. To be honest with you... UUID is the way to go though, but this should work. #DateFormat(now(),"mmddyyyy")##Rand()##Rand()# -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 7:56 AM To: CF-Talk Subject: Using createUUID() 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? --------------------------------------------------- Colonel Nathan R. Jessop Commanding Officer Marine Ground Forces Guatanamo Bay, Cuba --------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
