Keep in mind the the CreateUUID() function in CF does not make a MS SQL Server (for example) valid UUID.
There is a custom UDF at www.cflib.org that does this easily and is worth checking out. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoff Bowers Sent: Thursday, 12 February 2004 6:49 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Whats your Primary Key? Yorke Hinds wrote: > What is the support in the AU community for the use of UUID over > numeric primary keys in a DB/table? Plenty of support. Everyone who uses FarCry for instance uses UUIDs for primary keys in most tables. To use or not use depends on the application. The argument that integers provide faster indices is not really relevant -- it depends on the application and its data as to whether or not such a benefit has any bearing. This post lays out some pretty good reasoning for UUIDs as PKs: http://affy.blogspot.com/2003_03_02_affy_archive.html#90405845 I'd add to that cross db platform support. > If not using UUID in as the primary key in the DB/table, what can be > used to encode or mask url variables that include the primary key. I > am aware of session variables and form variables to hide numeric > records. What are you trying to do here? -- geoff http://www.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
