count method

Results 1 to 2 of 2

Thread: count method

  1. #1
    chris jones Guest

    Default count method

    Hi folks, <BR>I am attempting to query a database and using the<BR> <BR>on error resume next&#039<BR><BR>to prevent an error from being returned when 0 records are found.<BR>I am aware that using visual interdev model you can use the .count property for a recordset, is there a similar method I can use as a n alternative to the on error resume next?<BR><BR>All help appreciated<BR><BR>chris<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: count method

    try the eof (End of Field) property: if EOF is true, no records have been returned:<BR>set rs="select * from...."<BR>if rs.eof then<BR> response.write "No records"<BR> else<BR>&#039 write out the records<BR>end if

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts