Some random guesses / thoughts. Obviously - it is a Hexadecimal number, as it only has letters from A-F
looking at the structure of the numbers - and the fact many of them seem to start from 010000 - I'd hazard a guess that they are date/time/random number values concatenated, and converted to hex (although why the convert I'm not sure). Do you need to keep values in the same format? or you just looking to get a unique value for the database? I would say you are ALMOST (small possibility?) of getting a unique ID if you use random alpha-numeric of 16 units. I say that because the other values are all hexadecimal, so if only ONE value of your PK is from G-Z, it is guarenteed to be unique. (unless you have other ones) But 16 random numbers - I'll take those odds. Just some thoughts. Mark > [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > This is a long shot but worth asking... > > Listed below are a few sample values from the "Global_ID" field of an > MSSQL table I am trying to write to. I have been able to work out > where > all the other values in the table come from (or how they are worked > out), but I was wondering if anyone has seen a similar 16-character > string in their travels that is used as a UUID? If so, how is it > arrived at? > > 0100000E3EFA41B1 > 010000103EFA41B1 > 0100001B3EFA7DAA > 010000283EFA7DAA > 0100003A3EFA7DAA > 010000573F12380B > 010000E83F12380B > 010000F23F12380B > > 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? > > If anyone has any other ideas they will be appreciated. > > Thanks, Steve C > > > > > > --- > 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/ ----------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [www.safefrombees.com] --- 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/
