It all depends on your OS. CF on some OSs will return consecutive numbers not random numbers using UUID. On some OSs your code would return the same four numbers everytime for quite a while before it changed.
Regards Stephen CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 1:34 PM Subject: RE: Using createUUID() > have done/been doing for weeks now with no probs :-) > > -----Original Message----- > From: Sicular, Alexander [mailto:[EMAIL PROTECTED] > Sent: 17 March 2003 13:36 > To: CF-Talk > Subject: RE: Using createUUID() > > > Ok , run Mid(CreateUUID(),1,4) a few times and see what you get. > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Monday, March 17, 2003 8:28 AM > To: CF-Talk > Subject: RE: Using createUUID() > > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
