This seemed to get lost yesterday, so trying again.
Anyone know how the CFAdmin creates UUIDs for cftoken (see the Server
Settings/Settings page)?
Basically wanting to know if it uses createUUID() and is therefore affected by
the clock speed bug affecting createUUID() on Windows
http
Anyone know how the CFAdmin creates UUIDs for cftoken (on the Server
Settings/Settings page)?
Basically wanting to know if it uses createUUID() and is therefore affected by
the clock speed bug affecting createUUID() on Windows
http://www.macromedia.com/support/coldfusion/ts/documents
anotha fine idea...
thanks dave.
happy weekend everyone!
later.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 3:19 PM
To: CF-Talk
Subject: RE: createUUID() into sql server uniqueidentifier field
> so I guess, now ill use createGUID() f
> so I guess, now ill use createGUID() from cflib, and that'll
> reformat it for me
You could let the database generate the UUIDs for you, using the NEWID
function.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This Me
so I guess, now ill use createGUID() from cflib, and that'll reformat it for
me
thanks!
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 2:38 PM
To: CF-Talk
Subject: RE: createUUID() into sql server uniqueidentifier field
oh.
r
oh.
really.
so, If I generate one, using createUUID()
and try to insert into that type of column in sql server its not going to go
in ok?
that sucks...no wonder, oh, its micro$oft
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 2:41 PM
To
> From: Tony Weeg
>
> do our cfmx createUUID() uuid's jive with the mssql field/datatype?
The UUID and GUID formats are different
There are minor changes in the layout and length, enough to make them
look completely different
[Todays Threads]
[This Message]
[Subscri
never mind.
I figured it out.
wasn't the problem.
later.
its Friday.
almost time.
later.
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, May 07, 2004 2:18 PM
To: CF-Talk
Subject: createUUID() into sql server uniqueidentifier field
do our cfmx creat
do our cfmx createUUID() uuid's jive with the mssql field/datatype?
thanks!
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I did not try that... I will actually give that a shot and if it works, I
will have to ask someone to help explain why :-)
Thanks Ken.
Mike
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 7:43 PM
To: CF-Talk
Subject: RE: CreateUUID
F-Talk
Subject: RE: CreateUUID() / CreateGUID()
Any takers :-)
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:23 AM
To: CF-Talk
Subject: CreateUUID() / CreateGUID()
I am noticing something strange here and am hoping someone can
Any takers :-)
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:23 AM
To: CF-Talk
Subject: CreateUUID() / CreateGUID()
I am noticing something strange here and am hoping someone can enlighten
me..
My form has a field called
ah...let me have a look at it, I havent looked at that GUI
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 16:33
To: CF-Talk
Subject: RE: CreateUUID() / CreateGUID()
I know, which is why I was using CreateGUID()
-Original Message-
From
Oh, also, if you are testing say an insert, just use "(new())" inside SQL.
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 16:23
To: CF-Talk
Subject: CreateUUID() / CreateGUID()
I am noticing something strange here and am hoping s
I know, which is why I was using CreateGUID()
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 11:30 AM
To: CF-Talk
Subject: RE: CreateUUID() / CreateGUID()
AFAIK the ColdFusion UUID is not compatible with the SQL Server
AFAIK the ColdFusion UUID is not compatible with the SQL Server version.
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 16:23
To: CF-Talk
Subject: CreateUUID() / CreateGUID()
I am noticing something strange here and am hoping someone can
CreateUUID,
which uses the format (---). I set the form
value equal to #CreateUUID# for testing purposes and it gets passed into my
stored proc via the cfprocparam tag.
null="no" value="#form.currentUser#" cfsqltype="CF_SQL_VARCHAR" />
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 24, 2003 1:02 PM
To: CF-Talk
Subject: CreateUUID() hangs CFMX 6.1 Server
We have been experiencing the oft-noted but elusive problem where the CF
server hangs while executing threads and begins queuing them up. After about
a minute it can execute
and the cf admin, we stored debug information in a REQUEST variable during
the execution of many pages including application.cfm. We finally traced the hangs to
three different points in our code ? all of which are a CreateUUID() call. To verify,
we placed a CreateUUID() call at the top of
>
>
> Doug
>
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>> Sent: Monday, March 17, 2003 5:21 PM
>> To: CF-Talk
>> Subject: Re: Using createUUID()
>>
>>
>> Using the maxid trick has problems though. In
some databases, it will create a race
>condition. The only way to alleviate it is to set the transaction isolation level to
>"serializable".
>
>- Original Message -
>From: Matt Robertson <[EMAIL PROTECTED]>
>Date: Monday, March 17, 2003 2:53 pm
>Subject: Re:
17, 2003 2:53 pm
Subject: Re: Using createUUID()
> Chris,
>
> I've used the method you describe for awhile and prefer it. Your
> post reminded me of another method that seems safe, but I never
> went there. CF_MaxID:
>
> http://tinyclick.com/?T02MT2
>
> Yo
al Message --
From: Christian Cantrell <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 17 Mar 2003 15:22:12 -0500
>I posted some information on the createUUID function on my weblog today
>based on an application I was working on ove
I posted some information on the createUUID function on my weblog today
based on an application I was working on over the weekend:
http://www.markme.com/cantrell/weblog/index.cfm?m=3&d=17&y=2003
Christian
On Monday, March 17, 2003, at 07:55 AM, FlashGuy wrote:
> Hi,
>
> I n
I got this from another CF developer I used to work with (I don't know if he
is on the list).
This tag creates a SQL formated GUID in variable you specify.
> 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?
>
ou have received this communication in error, please notify us at the
> e-mail listed above.
>
> -Original Message-
> From: FlashGuy [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 17, 2003 8:05 AM
> To: CF-Talk
> Subject: RE: Using createUUID()
>
>
> If there
As I understand it, createUUID returns a character string. I thought that
record ID's should be numeric because of the improved performance on indexed
look-ups.
Do numeric indexes run significantly faster then character ones?
Andy
-Original Message-
From: Robertson-Ravo, Nei
: CF-Talk
Subject: RE: Using createUUID()
If there is no change of duplication I like this ID#.
In the code below. Would the UUID number be different for the hidden field
when I eventually insert the form fields into my database?
On Mon, 17 Mar 2003 07:55:49 -0600, Larry Juncker wrote
Quoting "Jason Lees (National Express)" <[EMAIL PROTECTED]>:
>
> http://www.dsps.net/uuid.html (the Colour coding leaves something to be
> desired but...)
>
> Just glancing at the document suggests that this will be a unique number,
> as it uses the Mac address of the PC to generate it.
And alth
29-30 May 2003
Keynote by Ben Forta and Tim Buntel
- Original Message -
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 17, 2003 1:34 PM
Subject: RE: Using createUUID()
> have done/bee
UUID
everytime then its a bug.
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 14:00
To: CF-Talk
Subject: RE: Using createUUID()
Heres a URL on how the UUID is defined
http://www.dsps.net/uuid.html (the Colour coding leaves something to
ple, why would this not work?
>
>
>
>
>
> CT-#Right(createUUID(),7)#
>
>
>
>
>
> I ran this code and found no dups in 1000 lines on one machine
>
> Larry Junck
3.4028236692093846346337460743177e+38 combinations (2^128).
Jason Lees
Development Team Leader
National Express Systems.
-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:51
To: CF-Talk
Subject: RE: Using createUUID()
Ignore my last post...ASCII has more than 36 characters
:[EMAIL PROTECTED]
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()
yep, as noted in another post, if it fits your development, then you can
still use it;
back on track : does and will mySQL support newid()
-Original Message-
From: Andre Mohamed [mailto:[EMAIL
Unless I am missing something very simple, why would this not work?
CT-#Right(createUUID(),7)#
I ran this code and found no dups in 1000 lines on one machine
Larry Juncker
Senior Cold fusion Developer
yep, as noted in another post, if it fits your development, then you can
still use it;
back on track : does and will mySQL support newid()
-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:51
To: CF-Talk
Subject: RE: Using createUUID()
Ignore my
Ignore my last post...ASCII has more than 36 characters...the point
still holds though.
-Original Message-
From: Andre Mohamed [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:48
To: CF-Talk
Subject: RE: Using createUUID()
If you only use 4 characters then there are only roughly (10+26
.
André
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:34
To: CF-Talk
Subject: RE: Using createUUID()
not sure what the odds could be : its not 1 in a thousand, I see your
point,
but in this instance, just include more chars or add your
I dont think that is the point per say, but I do see the point of potential
conflicts
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:41
To: CF-Talk
Subject: RE: Using createUUID()
The point of a UUID is not to use the first
yep, that would do it,
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:38
To: CF-Talk
Subject: RE: Using createUUID()
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
:
> In CF, you could use : myUUID = Mid(CreateUUID(),1,4); to get the first
> 4 chars of a CF generated ID.
Apart from using Left() instead of Mid() :-), just because the UUID is unique
does not mean the first 4 characters are unique. With 4 ASCII characters you can
have only 4 billion different
createUUID()
Ok , run Mid(CreateUUID(),1,4) a few times and see what you get.
-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
have done/been doing for weeks now with no probs :-)
-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()
Ok , run Mid(CreateUUID(),1,4) a few times and see what you get.
-Original Message
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: 17 March 2003 13:36
To: CF-Talk
Subject: RE: Using createUUID()
but not the first four...the whole uuid in and of itself, would be,
however, you could conceivably
get the same striking everything but the first four
...tony
Tony Weeg
Senior Web
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...
#createUUID
Ok , run Mid(CreateUUID(),1,4) a few times and see what you get.
-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
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
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 doi
0")#
Something like that anyway
>>> [EMAIL PROTECTED] 03/17/03 08:18AM >>>
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 :
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
Subjec
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
shGuy [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-0001
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 wi
never mind,
I think java.rmi.server.UID does the job
laszlo
Laszlo Nadai wrote:
> Is there a Java class that would create UUID's?
>
> Thanks,
> laszlo
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusiona
Is there a Java class that would create UUID's?
Thanks,
laszlo
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Un
vin Parker
Web Services Manager
WorkCover Corporation
[EMAIL PROTECTED]
www.workcover.com
p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287
-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 3 April 2001 3:07:AM
To: CF-Talk
Subject: RE: CreateUUI
[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 2:17 PM
> To: CF-Talk
> Subject: RE: CreateUUID()
>
>
> This is a misleading statement.
>
> It depends on several things hwoever I have seen often
> enough that they are quite sequential and only off by a few hex
> numbers per
nal Message-
> From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 1:37 PM
> To: CF-Talk
> Subject: RE: CreateUUID()
>
>
>
> >by pointing out that the UUID is "predictable" are you saying
> that using it
> >for security
Inc.
>-Original Message-
>From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 02, 2001 1:37 PM
>To: CF-Talk
>Subject: RE: CreateUUID()
>
>
>
>>by pointing out that the UUID is "predictable" are you saying
>that using it
>by pointing out that the UUID is "predictable" are you saying that using it
>for security purposes is not recommended?
UUIDs are not predictable.. take a look at this sequence I just tried. I
can't find the pattern.. can you?
038E0B1C-CF53-4F06-A646367FD3CBC92F
C7C38770-FAC0-4B00-B355DA9BFA
>
> by pointing out that the UUID is "predictable" are you saying
> that using it
> for security purposes is not recommended?
>
Its not actually strictly true that UUID are predictable.
Depending on your OS CreateUUID will either create UUIDs that increment from
some
by pointing out that the UUID is "predictable" are you saying that using it
for security purposes is not recommended?
Brad Tumy
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 9:59 AM
To: CF-Talk
Subject: RE: CreateUUID(
> Does anyone on this list rely on CreateUUID() for creating a completely
> unique identifier? Anyone know how it compares in effectiveness to using
> uniqueidentifier and making it a row GUID in SQL?
As long as you don't pass the UUID to the user and rely on that, then
they
:17 AM
>To: CF-Talk
>Subject: RE: CreateUUID()
>
>
>I have not used it, but I believe it is at least as unique as things like
>NT's station ID etc.
>
>I wouldn't worry about it.
>
>-Original Message-
>From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
>Sent:
I have not used it, but I believe it is at least as unique as things like
NT's station ID etc.
I wouldn't worry about it.
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 2:45 AM
To: CF-Talk
Subject: CreateUUID()
Does anyone on
Does anyone on this list rely on CreateUUID() for creating a completely
unique identifier? Anyone know how it compares in effectiveness to using
uniqueidentifier and making it a row GUID in SQL?
~~
Structure your ColdFusion code with Fusebox
The URL below shows the full algorithm:
http://www.opennc.org/onlinepubs/9629399/apdxa.htm
Good thing we have CreateUUID() ;-)
Dain Anderson
Caretaker, CF Comet
http://www.cfcomet.com/
- Original Message -
From: "Michael Thomas" <[EMAIL PROTECTED]>
To: "CF-Ta
Does anyone have any knowledge in how the CreateUUID is generated when using
the CreateUUID() function. I know its usage & the like. I would like to know
more about the algorythm that the CF Server uses to generate it. Any answers
would be a great help.
TIA,
Obviously this is an unexpected condition as CreateUUID() tends to work fine
for myself and seemingly everyone else. Looks like one for Allaire tech
support.
> -Original Message-
> From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 26, 2000 20:50
>
i get this error EVERYTIME i use CREATEUUID NOW, what the hell is wrong with
this variable does anyone else have this problem
Error Occurred While Processing Request
Error Diagnostic Information
An unexpected system error was detected. (Error code is 22)
This type of error will most likely occur
71 matches
Mail list logo
