Hi Alan,
Wondering if you've considered this... From SQL7 BOL:
"A GUID is a binary number that is guaranteed to be unique" and
"A column or local variable of uniqueidentifier data type can be initialized to a
value in two ways:
1) Using the NEWID function.
2) Converting from a string constant in the following form
(xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the
range 0-9 or a-f). For example, 6F9619FF-8B86-D011-B42D-00C04FC964FF is a valid
uniqueidentifier value."
Also "Comparison operators can be used with uniqueidentifier values."
Anyhow, I had a look at your tag and it seems it just generates something that looks
like a UUID/GUID but is not actually in the correct format... unless I missed
something. Basically a UUID should in reality be a 16-byte binary number, unless GUID
and UUID are entirely different things (I don't think so).
BTW, does CF still generate a UUID that is too short? Or did they fix that in a
service pack?
I've been doing a DB call and using SQL7's NewID() function to generate UUIDs (doesn't
do much for Access users, I know). Your tag is cool anyhow, I just wonder if calling
it UUID might be misleading.
Kind regards,
-Max
At 12/15/2000 09:11 AM -0900, you wrote:
>Along the lines of Steve N's recommendation to insert your own ID fields
>into db tables, I present,
>(drumroll)
>CF_UUID ! Ta-da! Yeah, yer all saying 'so what..." Well, I'll tell ya what.
>This came out of my need to manually stick in a UUID into a table, it
>relates to that Crystal Reports thing I mentioned in a separate thread
>yesterday.
>
>I tried using the built-in createUUID() function, but if you want to see
>some pretty lame UUID, try CFLOOPING it a hundred times. Out of the entire
>UUID string, maybe 3 chars will change over the entire loop.
>
>SoOoOo, not willing to use other's UUID tags cuz' I wanted to roll my own, I
>cooked up CF_UUID (can you believe NOBODY named their tag CF_UUID yet?),
>which went up to the Allaire Tag Gallery.
>
>Ya can also snag a copy at www.anthc.org/skunkworks ...
>
>
>(and a shameless, seriously shameless plug... Go to www.mp3.com/kittycat and
>listen to my songs. I've got one tune hovering at #11 on the
>alternative-grunge chart)
>
>Alan McCollough
>Web Programmer
>Allaire Certified ColdFusion Developer
>Alaska Native Medical Center
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
