On 3/3/03, Marius Milosav penned:
use:
cfqueryparam cfsqltype=cf_sql_varchar value=#form.product_name#
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
cfqueryparam
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:
cfqueryparam cfsqltype=cf_sql_varchar value=#form.product_name#
and it should take
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 and
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 and
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
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
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 actually
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
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
www.scorpiosoft.com/vicodemo/login.cfm
- Original 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
On 3/3/03, Marius Milosav penned:
use:
cfqueryparam cfsqltype=cf_sql_varchar value=#form.product_name#
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
PM
Subject: Re: CFMX Insert query problem
On 3/3/03, Marius Milosav penned:
use:
cfqueryparam cfsqltype=cf_sql_varchar value=#form.product_name#
and it should take care of the problem
I'll try that, thanks.
Curious. What version was cfqueryparam introduced in?
It is a change
12 matches
Mail list logo