Im creating a recordset from ASP with the following query (the recorset type is forward only, no lock, textual command);
SELECT * FROM core WHERE empvis != null AND eNews=1
eNews is a bit datatype and empvis is datetime (with nulls) . When I run it from ASP, it returns nothing, yet running from the SQL tool in Enterprise manager it returns lots (what I want). If I remove the eNews=1 bit then I do get data returned via ASP. Is this an ADO bug - any workarounds?