ASP RecordSet and Access result different??

[RoppieEpcor]

Hi,

i'm trying to get some results from my Access database through SQL. I've generated the following SQL statement from my ASP script:

SELECT * FROM tblReports WHERE ((reportName LIKE '*parts*') AND (reportCategory Is not null) AND (reportOwner Is not null) AND (reportStatus = 1)) ORDER BY reportName ASC

If I run this query in the Access database I get 7 result records with all fields. But if I create a recordset in ASP then nothing is returned. How is this possible?

(ALL reportStatus are 1, NONE of the reportCategory or reportOwner are Null)

ASP CODE:
<%
Set rsReports = Server.CreateObject("ADODB.RecordSet")
'strSql = sqlString mentioned above
rsReports.Open strSql, dbConn, 3, 3
Response.Write Cstr(rsReports.recordcount)
%>

OUTPUT: 0

 

[Remou]

You need to use % rather than * in ASP.