when hooking up VBA to SQL, we used a combination of timestamp and initials. 
for the most part, this ensured that any temporary tables would be unique
throughout the database.  although the user base was small, it ensured that no
duplicate temp tables would be generated.

perhaps a timestamp, MD5 sum and a few select characters from the e-mail
address would suffice?  i'm sure a combination of all three, wrapped up with a
random number and some wierd algorithm would provide a globally unique
identifier (or fairly close too.)

your timestamp should include hundredths of seconds...

--- Larry Price <[EMAIL PROTECTED]> wrote:

<snip>

> My question to you all is, what's a good way to generate a GLOBALLY unique
> ID (the rfc's specify that it is world-unique, not just unique to message)
> 
> My first idea was to use an md5 hash of the filename and date, but I can
> see some problems with that. 
> 
> Is there a good way to guarantee that CID's are acceptably unique? 
> 
> thanx,


=====
Justin Bengtson  @euglug=(v+ e- eug++ bsd? gnu++ s++)
[EMAIL PROTECTED]

"i called some kid 'b' the other day.  it's the price
you pay for living hip-hop every day of your life."
Jerry (from the Point Blank Rangers)

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com

Reply via email to