<div>
what r the results of the qry <br />
SELECT * FROM core<br />
r they correct?<br />

</div>


what r the results of the qry
SELECT * FROM core
r they correct?


<div>
Thanks ! makes sense now and works ;)<br />

</div>


<div>
<div class="content wysiwyg-content">
Im creating a recordset from ASP with the following query (the recorset type is forward only, no lock, textual command);<br />
<br />
SELECT * &nbsp;FROM core WHERE empvis != null AND eNews=1<br />
<br />
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?<br />
<br />
Matthew Allum
</div>
</div>


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?

Matthew Allum

ASP/ADO bug with SQLserver

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.