te: Thu, 29 Jul 2004 10:41:57 -0700 (PDT)
Subject: RE: Question about cfqueryparam
To: CF-Talk <[EMAIL PROTECTED]>
I'm back to this now
Anybody seen this before?
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver]
Syntax error (missing operator)
d
>
> --- Pascal Peters <[EMAIL PROTECTED]> wrote:
>
> > I forgot to delete "#request.filter#" in the query
> > below
> >
> > > -Original Message-
> > > From: Pascal Peters [mailto:[EMAIL PROTECTED]
> > > Sent: 29 Ju
e_num
-Joshua O'Connor-Rose
-All is Good
--- Pascal Peters <[EMAIL PROTECTED]> wrote:
> I forgot to delete "#request.filter#" in the query
> below
>
> > -Original Message-
> > From: Pascal Peters [mailto:[EMAIL PROTECTED]
> > Sent: 29
I forgot to delete "#request.filter#" in the query below
> -Original Message-
> From: Pascal Peters [mailto:[EMAIL PROTECTED]
> Sent: 29 July 2004 17:23
> To: CF-Talk
> Subject: RE: Question about cfqueryparam
>
> You can't use cfqueryparam like thi
thanks.
gee I thought I had something good going on.
ah well.
-Joshua O'Connor-Rose
-All is Good
--- Pascal Peters <[EMAIL PROTECTED]> wrote:
> You can't use cfqueryparam like this, it won't get
> evaluated. It has to
> be in the cfquery.
>
>
> select office_id
> from office
> #request.fi
Hi Josh,
is meant for use inside of your tags becuase
it does more than string parsing.
Try this out:
select office_id
from office
where office_num in (
value='#attributes.office_num#'
cfsqltype='CF_SQL_VARCHAR'>)">
Cheers,
Joe
- Original Message -
From: Joshua OConnor-Rose
You can't use cfqueryparam like this, it won't get evaluated. It has to
be in the cfquery.
select office_id
from office
#request.filter#
where 0=0
and office_num in (
value='#attributes.office_num#'
cfsqltype='CF_SQL_VARCHAR'>)
> -Original Message-
> From: Joshua OConnor-Rose [m
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
> 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]
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
> 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 =
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
ting a standard SQL datatype.
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: C
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
> 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
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
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
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
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 -
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
20 matches
Mail list logo