asp results page

[Stu]

I'm using this code display results based on a number
entered into a form.

<%
ID = Request.QueryString( "ID")
if ID ="" then ID ="1"

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=C:mypath\mydatabase.mdb"

quote = "SELECT * FROM Results Where ID = "& ID &""
Set quote = Conn.Execute( quote)

if quote.eof then
Response.write("No records found.")
end if

%>

It works fine, but when you do a seach and there is no
record, you get this error message:

No records Found

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been
deleted. Requested operation requires a current record.

/quote/test2view/testview.asp, line 0

How do I get rid of the error message and have it only
say "No records found"?

 

[Tom Gahagan]

Stu......

In the mean time.... while you are waiting for an answer.......

you might post this on:

www.4guysfromrolla.com

Best asp forum around.

Best to you......
Tom Gahagan

 

[clintonG]

Better yet. Discover the ASP FAQ [1] where this exact problem as
well as many others is documented. You can also get support from
developers via:

* news://microsoft.public.inetserver.asp.general
* news://microsoft.public.inetserver.asp.db

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET csgallagher@ REMOVETHISTEXT metromilwaukee.com
URL http://www.metromilwaukee.com/clintongallagher/

[1] http://www.aspfaq.com/

 

[Jim Fidler]

It looks like you are missing an "end if" in your first
condition.