I find the main reason for using identity PKs is that the urls generated are much shorter and easier for the user, especially if they have to type them in from a printed url... eg:
http://www.mydomain.com/index.cfm?id=12345 or http://www.mydomain.com/index.cfm?id=E5460D40-2163-4C10-95EC-A4ADB319A126 Alex > -----Original Message----- > From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] > Sent: 29 July 2003 15:56 > To: CF-Talk > Subject: Re: DB Design > > > I welcome the discussion but back it up.. > > PITA? In what ways? > > > ----- Original Message ----- > From: "Boardwine, David L." <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 29, 2003 10:50 AM > Subject: RE: DB Design > > > > Ok, I'll give my .02 worth. BS. What am I supposed to use > as a PK? GUIDs? > > GUIDs are what M$ uses and they are a PITA. > > DavidB > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4