Testing a recordset 1

[johnaregan]

Hi all
If I execute a query using ADO and assign the resulting recordset to a variable rs then how can I test to see if ADO found any records.

thx in advance

 

[DougP]

using the "count" property
----------------------
<%
Set Conn = server.CreateObject(&quot;ADODB.Connection&quot
Conn.Open &quot;......&quot;
Set RS = Conn.Execute(&quot;SELECT Count(*) AS Recs FROM [yourtable]&quot%>

Records Found&nbsp; <%=RS(&quot;Recs&quot%>


DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[link9]

Or you can use the empty recordset test of:

if (rs.eof and rs.bof) then
'rs is empty
else
'rs is not empty
end if

That condition will be true only if the recordset is empty.


Paul Prewett