I ran into this too, I wrote a 'random' number generator for our 4.01
server, but it isn't truly random and was pretty bruteforce-ish. I also
tried a UUID tag that someone wrote, but it failed when I stressed the
server (I did not pursue whether it was a problem with the tag, or a timeout
issue with the server.)
I am planning to use the UUID tag (in sever 4.5 or greater) after we
upgrade.
What does everyone think??
Is the 4.5 Server UUID function 'Random' enough for a unique database ID?
Thanks,
/LEMAN/
-----Original Message-----
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 4:49 PM
To: '[EMAIL PROTECTED]'
Subject: Making a unique ID
As we know, you can use Access to generate either an incremental or a random
ID number.
We've also had discussions about using CF expressions to do this.
What if you don't want to use either of these methods?
My assumption is that CFTokens and CFIDs are always unique. I was thinking
of splicing these numbers together as inserting them into the DB as the ID.
My question is, is my assumption correct? Will these numbers always be
unique, especially when taken together?
I can get away with this because I'm taking the draconian approach to
require all users of this particular application to enable cookies, so I
know ALL users will have these numbers set in their cookies when they get to
this point in the application.
I just want to make sure I won't bump into any duplicate issues, or that the
chance of a duplicate is so remote (in the 1 to billions range) that it
really won't be an issue.
H.
=========================
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=========================
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
