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, and for the
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 -
ary 24, 2004 8:32 AM
> To: CF-Talk
> Subject: 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
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 s
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
> 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:
>
>
> select * from user
> where UserID =
> value="GUID">
I don't think that UUID/GUID is a
porting
role.
Cheers,
barneyb
> -Original 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 ch
F-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 of
>format. If you want to validate a GUID, you'll have to use something
more
>than just CFQUERYPARAM.
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, w
> 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:
>
>
> 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 sa
> 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
[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 v
13 matches
Mail list logo