At 05:25 PM 12/15/00 -0500, you wrote:
>BTW, does CF still generate a UUID that is too short?
I'm not sure what the technical difference between a UUID and a GUID is
either. They're both unique values, but they have slightly different
formats. Maybe they're just generated by different algorithms.
xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxxxxxx = a UUID
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx = a GUID
The MS Access "uniqueidentifier" field type is masked for the GUID format.
So I've been starting with a UUID and using it to create a fake GUID like this:
<cfset UUID = cf_createUUID()>
<cfset PK = Left(UUID,23) & "-" & Right(UUID,12)>
The resulting '#PK#' (a string) is graciously accepted by the MSAccess
uniqueidentifier field.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
