Access Table without Results

Results 1 to 2 of 2

Thread: Access Table without Results

  1. #1
    Join Date
    Dec 1969

    Default Access Table without Results

    Hallo,<BR>I am connect a database (Access 97) with an HTML Formular and<BR>the results are getting with a ASP Site. My problem is -<BR>If the Access Query are empty an error came.<BR>How can I identify in ASP when the error is coming and write<BR>out "Sorry no data.) ?

  2. #2
    Join Date
    Dec 1969

    Default RE: Access Table without Results

    &#060;% strSQL="SELECT stuff FROM mytable"<BR><BR>set rs = con.Execute strSQL<BR><BR>if rs.eof then &#039here you&#039re checking to see if the recordset is empty<BR>Response.Write "oops. your query returned no data"<BR>else<BR>&#039do your other stuff<BR>end if<BR>%&#062;

Posting Permissions

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