Fwd: VB6, ADO returns EOF via ODBC but has records in PSQL

--=====================_14498277==.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed


>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

--=====================_14498277==.ALT
Content-Type: text/html; charset="us-ascii"

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;