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

Ken French ( frenchkc@gru.net )
Mon, 26 Jan 1998 10:13:35 -0500

the property recordset-object.eof will.

-----Original Message-----
From: Danny Sinang [SMTP:danny@uplink.com.ph]
Sent: Monday, January 26, 1998 5:25 PM
To: NTISP
Subject: ADO in ASP - how do I know if a SQL statement returned no rows ?

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/

----------------------------------------------------------
NTISP Mailing List listserver@emerald.iea.com