-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, 11 September 2003 2:36 PM
To: CFAussie Mailing List
Subject: [cfaussie] a long shot...The field is of datatype varchar (16), so if I was to use createUUID() to arrive at the value, would i be assured that the final 16 characters of the UUID generated by CF is going to be unique?
You should _not_ assume that one end of a UUID value
generated by CF will be unique.
I came across this little oddity at my last job, so
this info is all pre CFMX (CF 5).
If you make a series of UUID value on a windows box,
and another set on a Solaris box (with the exact same cf code), the first
dozen or so characters will be changing while the last characters will
remain relatively static in only one of the 2 series, and in the other series
the first half of the characters will be static and the last half of the
characters will be changing. I can't recall which OS was which way, but I do
know they were the opposite of each other.
This may have all changed in the change to MX, but I'm
not in a position to try it out anymore.
The lesson from this, don't assume a truncated portion
of a UUID will be unique.
Regards
Darren Tracey
---You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MX Downunder AsiaPac DevCon - http://mxdu.com/
