Fwd: VB6, ADO returns EOF via ODBC but has records in PSQL - Mailing list pgsql-odbc

From Johann
Subject Fwd: VB6, ADO returns EOF via ODBC but has records in PSQL
Date
Msg-id 6.1.0.6.0.20061019125905.01d79ce0@pop.dnvr.uswest.net
Whole thread Raw
List pgsql-odbc
I'm trying to find the set of records that are not in a comma delimited list using an SQL statement like:
 
SELECT name FROM construction WHERE name NOT IN ('a1        ', 'a2        ', '') ORDER BY name;

etc...

Try select RTRIM(name) ... where not in ('a1', 'a2') etc

VBS/ADO acts weird with trailing spaces.  Maybe there are other solutions too?

 - Johann

pgsql-odbc by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: Improve ODBC Throughput ?
Next
From: Hiroshi Inoue
Date:
Subject: Re: Problem with error messages in VC++ 2005