executing the
> query. I
> have also made sure that all entries are trimmed. I have also used
> LIKE
> instead of =.
>
> Chad
>
> -Original Message-
> From: Nat Papovich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 12:51 AM
> To: CF-Talk
>
also used LIKE
instead of =.
Chad
-Original Message-
From: Nat Papovich [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 12:51 AM
To: CF-Talk
Subject: RE: Running a Dynamically Created Query
The best, fastest thing to try would be to remove the cfquery tag and
replace
FYI, CF doesn't convert single quotes to double quotes. It escapes
single quotes with another single quote. Here's what the help says:
--
Developing Web Applications with ColdFusion | Selecting and Presenting
Data | Using Dynamic Query Parameters
ODBC allows you to denote a single quote in
inal Message-
From: Chad Elley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 12:19 AM
To: CF-Talk
Subject: Running a Dynamically Created Query
I have set up a series of Cold Fusion templates that build a dynamic SQL
statement. I have run into a "stump in the road" as a r
#preserveSingleQuotes(sqlStatement)#
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubs
h
ICQ 32676414
"If it was hard to write,"
says the Real Programmer,
"it should be hard to understand."
-Original Message-
From: Chad Elley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 9:19 PM
To: CF-Talk
Subject: Running a Dynamically Created Query
I hav
I have set up a series of Cold Fusion templates that build a dynamic SQL
statement. I have run into a "stump in the road" as a result. The SQL
statement consists almost entirely of variables equaling an integer, but
when I have a variable equal to a string, I get errors. For example, when I
attemp
7 matches
Mail list logo