The UUID for MS SQL is NEWID(), no need to create it externally. I still say, go with Integers, use them for relationships, and add the UUID to any table that is used in a global procedure.
Taco Fleur Blog http://www.tacofleur.com/index/blog/ Methodology http://www.tacofleur.com/index/methodology/ Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Peter Tilbrook > Sent: Thursday, 12 February 2004 6:25 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Whats your Primary Key? > > > 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 --- 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
