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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
