-----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: 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 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 enlighten
me..
My form has a field called userId which is hidden and holds an MS formatted
UUID (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx). For now though, I am just
testing out the form and tried setting the form value equal to CreateUUID,
which uses the format (xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxxxxxx). I set the form
value equal to #CreateUUID# for testing purposes and it gets passed into my
stored proc via the cfprocparam tag.
<cfprocparam type="In" dbvarname="currentUserId"
null="no" value="#form.currentUser#" cfsqltype="CF_SQL_VARCHAR" />
When form.currentUser is equal to #CreateUUID()# the stored proc errors out.
When form.currentUser is equal to #CreateGUID()# the stored proc errors out.
When form.currentUser is equal to 4572039B-BDB5-255B-BBF5-1B752CEDD144 (MS
format)the stored proc WORKS!
Guess where I got that value? I viewed the source when I set the form field
equal to #CreateGUID()# and copied it, then pasted it into the value of the
currentUser form field!
Can anyone explain why the stored procedure would accept the value when I
manually set it to the value instead of calling the function to do it?
CreateGUID() was obtained form cflib.org by the way.
Thoughts???
Thanks,
Mike
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
