Norman,
I remember seeing a custom function (for CF 5) on http://www.cflib.org/
that has a CreateGUID function that creates it in "microsoft form" It is in
the StrLib library.
HTH,
Tim P.
----- Original Message -----
From: "Norman Elton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 8:16 PM
Subject: UUID Woes
I'm starting to use UUIDs as primary keys, and they work
great. Using Ingres, I just stored them as strings, and
indexed them to be primary keys. According to the Ingres
gurus, this wasn't a big deal.
I was happy to see that MS SQL 2000 has native support for
UUIDs. Unfortunately, their idea of a UUID is a bit
different from ColdFusion:
MS SQL:
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
ColdFusion:
xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxxxxx
Needless to say, SQL won't accept ColdFusion's UUIDs. Does
anyone know a way to get around this and allow ColdFusion
to specify UUIDs to SQL?
Thanks!
Norman Elton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
