---------- I'm also sending this to [EMAIL PROTECTED] ----------
Wasn't there also an issue with creating UUID on win nt4 vs. Win2k? I seem
to remember that somebody (Alan?) observed that the ids did not look very
random - only a digit apart.
---
Jeffrey B. Marsh
Professionals built the Titanic.
Amateurs built the Ark.
-----Original Message-----
From: Ross Keatinge [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:18 PM
To: Fusebox
Subject: RE: max_id or autonumber?
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
****************************************************************************
This message is intended for the sole use of the individual and entity to
which it is addressed, and may contain information that is privileged,
confidential and exempt from disclosure under applicable law. If you are
not the intended addressee, nor authorized to receive for the intended
addressee, you are hereby notified that you may not use, copy, disclose or
distribute to anyone the message or any information contained in the
message. If you have received this message in error, please immediately
advise the sender by reply email and delete the message. Thank you very
much.
****************************************************************************
****************************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
