Thread: How to use question mark in query thru ODBC from Windows

How to use question mark in query thru ODBC from Windows

From
Kari Lempiainen
Date:
I'm using ODBC-interface in Windows 200 to access data from PostgreSQL
database in Linux box. My query is like:
select id from records where name = 'How are you?'

I get errors from the ODBC:
SQLExecDirect: SQL Error: 1
SQL State: S1000
Error string: Error while executing the query;
ERROR:  Unterminated quoted string

I've analyzed the problem to be the question mark. ODBC thinks that
I'm using ? as a parameter marker, which obviously isn't the problem.
I've tried replacing ? with \? with no success (like I have to use \'
instead of '). What can I do to get the question mark go thru driver?

Cheers,

Kari


Re: How to use question mark in query thru ODBC from Windows

From
"Byron Nikolaidis"
Date:
Use single quotes around the question mark.   All literal strings require
single quotes.

Byron

----- Original Message -----
From: Kari Lempiainen <kari@funky.pp.fi>
To: <pgsql-interfaces@postgresql.org>
Sent: Saturday, June 24, 2000 2:47 PM
Subject: [INTERFACES] How to use question mark in query thru ODBC from
Windows


> I'm using ODBC-interface in Windows 200 to access data from PostgreSQL
> database in Linux box. My query is like:
> select id from records where name = 'How are you?'
>
> I get errors from the ODBC:
> SQLExecDirect: SQL Error: 1
> SQL State: S1000
> Error string: Error while executing the query;
> ERROR:  Unterminated quoted string
>
> I've analyzed the problem to be the question mark. ODBC thinks that
> I'm using ? as a parameter marker, which obviously isn't the problem.
> I've tried replacing ? with \? with no success (like I have to use \'
> instead of '). What can I do to get the question mark go thru driver?
>
> Cheers,
>
> Kari