EOF AND BOF ??? Error page with no result query
-
When I send a Query that returns no results there is simply an error page and NOT the "NO RESULTS FOUND" that I want displayed... CAN YOU PLEASE HELP.. This is my code for the body section... all seems fine as per my tutorial?? Would you need the rest of the code page or not? It is simply suppose to display SOMETHING except an error page when you have no results in the query search???
<% i=0 While (i<=37) %> ><%=response.Write(CatArray(i))%> <% i=i+1 Wend %> OR
<% If Not Recordset1.EOF Or Not Recordset1.BOF Then %> <% IF Recordset1.EOF OR Recordset1.BOF Then %> <% Else %> <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
Records <%=(Recordset1_first)%> to <%=(Recordset1_last)%> of <%=(Recordset1_total)%>
Category
Price
<%=(Recordset1.Fields.Item("DESCRIPTION").Value)%>
<%=(Recordset1.Fields.Item("CAT").Value)%>
R<%=(Recordset1.Fields.Item("INCL TAX").Value)%>
<% End If ' end Not Recordset1.EOF Or NOT Recordset1.BOF %> <% End if %> <% If Recordset1.EOF And Recordset1.BOF Then %>
NO MATCH FOUND
<% End If ' end Recordset1.EOF And Recordset1.BOF %>
<% Recordset1.Close() Set Recordset1 = Nothing %> this is me