At 11:16 AM -0600 2/23/04, Justin Hansen wrote:
I use CF_SQL_VARCHAR for GUIDs. It works just fine.
What if a string of characters, formatted just the same as a GUID but
with one less character, was used?According to my coworker, this
would validate just the same as a real GUID.
--
Lola -
: RE: Question about CFQUERYPARAM and GUIDs
At 11:16 AM -0600 2/23/04, Justin Hansen wrote:
I use CF_SQL_VARCHAR for GUIDs. It works just fine.
What if a string of characters, formatted just the same as a GUID but
with one less character, was used?According to my coworker, this
would
Lola Lee wrote:
At 11:16 AM -0600 2/23/04, Justin Hansen wrote:
I use CF_SQL_VARCHAR for GUIDs. It works just fine.
What if a string of characters, formatted just the same as a GUID but
with one less character, was used?According to my coworker, this
would validate just the same as a
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with the
appropriate RE.I don't
We're being told to use CFQUERYPARAM in cfqueries. But if I
understand it correctly, there is no CF_SQL types that handle
GUIDs.
What we need to be able to do is something like this:
cfquery verifyUser
select * from user
where UserID = cfqueryparam type=CF_SQL_xxx
value=GUID
Message-
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:54 AM
To: CF-Talk
Subject: RE: Question about CFQUERYPARAM and GUIDs
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use
CF_SQL_VARCHAR, regardless
.
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc.http://mysecretbase.com
-Original Message-
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 24, 2004 8:54 AM
To: CF-Talk
Subject: RE: Question about
Lola Lee wrote:
At 8:38 AM -0800 2/24/04, Barney Boisvert wrote:
Any character string will validate if you use CF_SQL_VARCHAR, regardless of
format.If you want to validate a GUID, you'll have to use something more
than just CFQUERYPARAM.Easiest is probably a simple Refind call, with the
From: Lola Lee
Isn't this counterintuitive?
We're being told to use CFQUERYPARAM in cfqueries.But if I
understand it correctly, there is no CF_SQL types that handle GUIDs.
What we need to be able to do is something like this:
cfquery verifyUser
select * from user
where UserID =
Philip Arnold wrote:
What you have to remember is that a GUID is just a string of characters
- different systems produce them differently
Actually, a GUID is a 128 bit integer that is produced according
to the same algorithm everywhere.
CF, SQL Server and other apps won't produce the same
Even the string representation of a GUID is the same everywhere.
There is however a difference between the string representation
of a GUID and a UUID.
Sorry, I meant UUID/GUID g
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Lola Lee wrote
What if a string of characters, formatted just the same as a GUID but
with one less character, was used?According to my coworker, this
would validate just the same as a real GUID.
It sure would.Read the earlier posts on this.You are mistaking
cfqueryparam for a data input
At work we use SQL Server, and for the project we're using GUIDs for the id columns in several tables.Is there a CFSQLTYPE available for use with CFQUERYPARAM?Looking at the online documentation does not seem to indicate as cuh.What about CF_SQL_IDSTAMP?
--
Lola - mailto:[EMAIL PROTECTED]
I use CF_SQL_VARCHAR for GUIDs. It works just fine.
Justin Hansen
Project Manager
Uhlig Communications
_
From: Lola Lee [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 11:06 AM
To: CF-Talk
Subject: Question about CFQUERYPARAM and GUIDs
At work we use SQL Server
14 matches
Mail list logo