Stacy, do you have any reference to where MS recommends against
identities? I'd be interested to read about it.
Am I correct to assume that CreateUUID calls a Windows API call to get
the string and is not something cooked up by Allaire?
A slightly OT caution that might be appropriate here:
If you do use integers for PKs and have URLs like
http://mydomain.com/getdata.cfm?id=123
which then creates a query SELECT Fields FROM TABLE WHERE id = #url.id#
type of thing then be careful of the security issue with SQL Server and
maybe others where you can put a semicolon and then another SQL
statement. Make sure url.id is a number (VAL is useful here).
Ross
--- Stacy Young <[EMAIL PROTECTED]> wrote:
>
> I can tell you they do in SQL2K. They advise against it. Suggest
> UUID.
>
>
> -----Original Message-----
> From: Paul Smith [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 8:52 PM
> To: Fusebox
> Subject: Re: max_id or autonumber?
>
>
> Are you saying:
>
> Microsoft recommends you not use the identity feature?
>
> best, paul
>
> At 10:23 AM 5/31/01 -0700, you wrote:
> >Microsoft
> >doesn't even recommend that you use the identity feature for a
> Unique
> >ID field because of this.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
