Re: ADO in ASP - how do I know if a SQL statement returned no

Jeff ( nblade@firstinter.net )
Mon, 26 Jan 1998 07:43:05 +0000

do at check to see if the recordset is Begining of File and End of File and
thereby empty.

for example you could do the following

Do While Not oRS.BOF And Not oRS.EOF
....
'other code here
...
Loop

At 10:25 PM 1/26/98 +0000, you wrote:
>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
>