I believe there is a UDF at www.cflib.org that does just that.
--- Ben
-----Original Message-----
From: Jones, Matt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 9:49 AM
To: CF-Talk
Subject: RE: UUID Woes
you could create a custom tag that does something like this
<cfset newUUID = createuuid()>
<cfset newUUID = mid('#newUUID#',1,23) & "-" & mid('#newUUID#',24,12)>
<cfset caller.newGuid = #newUUID#>
-----Original Message-----
From: Norman Elton [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 7:17 PM
To: CF-Talk
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
