From: | "Byron Nikolaidis" <byron(dot)nikolaidis(at)home(dot)com> |
---|---|
To: | "Kari Lempiainen" <kari(at)funky(dot)pp(dot)fi>, <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: How to use question mark in query thru ODBC from Windows |
Date: | 2000-06-25 19:46:43 |
Message-ID: | 000a01bfdede$174706e0$6401a8c0@byron |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Use single quotes around the question mark. All literal strings require
single quotes.
Byron
----- Original Message -----
From: Kari Lempiainen <kari(at)funky(dot)pp(dot)fi>
To: <pgsql-interfaces(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-06-26 07:46:21 | RE: getMoreResults() returns false incorrectly |
Previous Message | Kari Lempiainen | 2000-06-25 09:53:06 | Bug and possible fix in odbc driver |