From: Byron Nikolaidis <byron.nikolaidis@home.com>
To: Kari Lempiainen <kari@funky.pp.fi>
To: pgsql-interfaces@postgresql.org
Subject: Re: How to use question mark in query thru ODBC from Windows
Date: Sun, 25 Jun 2000 15:46:43 -0400
Message-ID: <000a01bfdede$174706e0$6401a8c0@byron> (raw)
References: <k40alsciflftgtptvbn8lk2pma1qrha8fk@4ax.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byron.nikolaidis@home.com, kari@funky.pp.fi
Subject: Re: How to use question mark in query thru ODBC from Windows
In-Reply-To: <000a01bfdede$174706e0$6401a8c0@byron>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox