ran this, and got those, not too unique using the first four...maybe he
could mid() some part of
it, towards the end of a uuid, that looks to be unique...
<cfloop from="1" to="10" index="i">
<cfoutput>
#createUUID()# <BR>
</cfoutput>
</cfloop>
FC3323FA-B0D0-3EE0-80B37FBF22E75C14
FC332409-B0D0-3EE0-80B85DDA31714729
FC332419-B0D0-3EE0-80FFB7B79097DECF
FC332429-B0D0-3EE0-80D1687860F7CD14
FC332438-B0D0-3EE0-8057B4F140B6DC85
FC332448-B0D0-3EE0-803695377137647C
FC332458-B0D0-3EE0-80CAD77B2CBF4BC6
FC332467-B0D0-3EE0-80051B3A5F91255B
FC332477-B0D0-3EE0-801B9143334C9271
FC332486-B0D0-3EE0-804ACCD036880B5A
...tony
Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 8:28 AM
To: CF-Talk
Subject: RE: Using createUUID()
erm... I would say that they are unique. No UUID is the same by its
very
definition; thats the point...
<sic/>
The mechanism used to guarantee that UUIDs are Unique is through
combinations of hardware addresses, time stamps and random seeds.
No two comps can generate the same UUID.
"AFAIK"
-----Original Message-----
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:27
To: CF-Talk
Subject: RE: Using createUUID()
I wouldn't do that , first 4 chars of createuuid() are not unique. If
you cat that with something else than _maybe_ you are doing a bit
better.
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 8:18 AM
To: CF-Talk
Subject: RE: Using createUUID()
if you mean a UUID within SQL (i.e. 46 chr string such as A4534-34565E-
etc...) then you may be able to use newid() within mySQL, though I am
not sure that it supports it.
In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
4 chars of a CF generated ID.
HTH
Neil
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:04
To: CF-Talk
Subject: RE: Using createUUID()
Use the current date and add random numbers to the end:
03172003nn where 'nnn' are the random numbers.
To be honest with you... UUID is the way to go though, but this should
work.
#DateFormat(now(),"mmddyyyy")##Rand()##Rand()#
-----Original Message-----
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2003 7:56 AM
To: CF-Talk
Subject: Using createUUID()
Hi,
I need to generate a unique ID for every form I submit. The createUUID #
generated is just too long for my needs. My ID only needs to be 10
characters in length. Something like:
CT-0001001
I'm using MySQL. Can I have mysql generate the unique ID? How could I do
this with CF?
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
