Using Quotes in a Query

Question

I am running CF MX7 Enterprise, and using a Sybase driver as
the datasource. I can run this query just fine:

select my_field from my_table
where my_key = '1234'

but I get an error when I replace the single quotes with
double quotes (shift-quote on the keyboard), like this:

select my_field from my_table
where my_key = "1234"

If I switch to an ODBC socket either one will work. It's just
the Sybase driver that throws the error. Does anyone have any
expeience with this?

Newsgroup_User · Answer

gmtjr wrote:> I am running CF MX7 Enterprise, and using a Sybasedriver as the datasource. I > can run this query just fine:> > select my_field from my_table> where my_key = '1234'> > but I get an error when I replace the single quotes withdouble quotes > (shift-quote on the keyboard), like this:> > select my_field from my_table> where my_key = "1234"> > If I switch to an ODBC socket either one will work. It'sjust the Sybase > driver that throws the error.Every proper database server will throw an error because theSQL standard says that you are not supposed to do that.Convert your queries to use cfqueryparam to solve theproblem.Jochem-- Jochem van DietenAdobe Community Expert for ColdFusion

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded