ADO in ASP - how do I know if a SQL statement returned no rows ?

Danny Sinang ( (no email) )
Mon, 26 Jan 1998 22:25:20 -0000

Hi.

I've read the online ASP docs about ADO.

I've already made a program that accesses rows in an ODBC table. Question
is, what function or property would tell me I got zero records if my SQL
query returns no rows ?

As it is, ASP closes the recordset if no rows are fetched and I can't use
the RecordCount property.

Danny Sinang
President - Uplink Technologies, Inc.
http://www.uplink.com.ph
danny@uplink.com.ph
http://www.uplink.com.ph/danny/