Help posting message when recordset = 0

Results 1 to 2 of 2

Thread: Help posting message when recordset = 0

  1. #1
    Join Date
    Dec 1969

    Default Help posting message when recordset = 0

    Hello, <BR><BR>Okay, I have two asp pages (myweb.asp & myresults.asp). I will be using the myweb.asp page to let people choose search criteria - within a form (name="messageForm"). When the user is finished selcting their search criteria they METHOD="POST" to a pop-up ACTION="myresults.asp" page. At this point the myresults.asp page will connect to the database and do a search. This is my dilemma (or stupidity)- I want myresults.asp - If there are no matches - to post a (No matches were found. Please try again.) message to the myweb.asp page. <BR><BR>Here is what I have started with:<BR><BR> &#060;% if rsFeedback.RecordCount = 0 Then<BR> response.Redirect ("myweb.asp") <BR> Response.write ("<BR>")<BR> Response.write ("<BR>")<BR> Response.write ("&#060;font size=&#039;3&#039; color=&#039;red&#039;&#062;")<BR> Response.write("No matches were found. Please Try Again") <BR> Response.write ("&#060;/red&#062;")<BR> <BR> <BR> End If<BR> <BR> %&#062;<BR>This (if I take out the redirect) will post the message to the I need it to post this message to the myweb.asp page.<BR><BR>I thank you for your help, time and superior knowledge.<BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default RE: Help posting message when recordset = 0

    don&#039;t use .recordcount<BR><BR>use .EOF<BR><BR>j<BR>

Posting Permissions

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