Well, I found a workaround by accident.
I went ahead and took the queries that were giving me problems, cut
them from the templates they were in, saved them to a file, then made
a copy of the file. On the copy I changed all the input parameters to
cfqueryparam tags. Then I was going to do a cfi
Bud wrote:
> On 3/4/03, Jochem van Dieten penned:
>
>>It is a bug in CF MX, not in the JDBC driver.
>
>
> Thanks Jochem. Are they aware of it? Is there a bug report form I can
> fill out?
I would expect MM is aware of this issue, but I don't know how many
people that discover this issue actua
On 3/4/03, Jochem van Dieten penned:
>It is a bug in CF MX, not in the JDBC driver.
Thanks Jochem. Are they aware of it? Is there a bug report form I can
fill out? Is this Access specific or across all DBs?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Cold
On 3/4/03, Marius Milosav penned:
>The only time I have seen that single quotes are doubled when using
>cfqueryparam is when the string is trimmed prior to be used in a database
>transaction. If I remember correctly there was a discussion last week on the
>list to this effect.
>
>Check the archives
Bud wrote:
> On 3/4/03, Marius Milosav penned:
>
>>The only time I have seen that single quotes are doubled when using
>>cfqueryparam is when the string is trimmed prior to be used in a database
>>transaction. If I remember correctly there was a discussion last week on the
>>list to this effect.
On 3/4/03, Marius Milosav penned:
>The only time I have seen that single quotes are doubled when using
>cfqueryparam is when the string is trimmed prior to be used in a database
>transaction. If I remember correctly there was a discussion last week on the
>list to this effect.
>
>Check the archives
Marius
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 2:00 PM
Subject: Re: CFMX Insert query problem
> On 3/3/03, Marius Milosav penned:
> >use:
> >
> >
> >and
On 3/3/03, Marius Milosav penned:
>use:
>
>
>and it should take care of the problem
>
>It is a change in behavior between CF5 and CFMX
Hi. Nope, that doesn't do it Marius. That breaks the UPDATE statement.
On INSERT
works.
#form.product_name# throws an error.
On UPDATE
#form.product_name#
ins
MAIL PROTECTED]>
Sent: Monday, March 03, 2003 10:11 PM
Subject: Re: CFMX Insert query problem
> On 3/3/03, Marius Milosav penned:
> >use:
> >
> >
> >and it should take care of the problem
>
> I'll try that, thanks.
>
> Curious. What version was cfquer
On 3/3/03, Marius Milosav penned:
>use:
>
>
>and it should take care of the problem
I'll try that, thanks.
Curious. What version was cfqueryparam introduced in?
>It is a change in behavior between CF5 and CFMX
I don't think that's the case, because if it was UPDATE would have
changed also. UPD
al Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 7:51 PM
Subject: CFMX Insert query problem
> Hi All. I'm receiving an error on a database INSERT...
>
> [MERANT][SequeLink JDBC Driver][ODBC Socket]
Hi All. I'm receiving an error on a database INSERT...
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Syntax error (missing operator) in query
expression ''Bud's Maid Service',etc...
from the single quote in Bud's. If I escape the quote with another
quote
12 matches
Mail list logo
