Error '800a0bcd' on page 1

[annettesue]

I create a search page to search keyword. When I type in keyword and click OK, the result page display error as below:

ADODB.Field error '800a0bcd'

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

/MyPublishedSite/result.asp, line 34

What's the error mean?I think there may be something wrong to the asp code for line 34:

<p>Your search for keyword<%=(Result.Fields.Item(&quot;keyword&quot.Value)%></p>

What should I do to overcome that error?Please help.

Thank you.

annette

 

[vbkris]

change the display code to
<%if not(rs.eof and rs.bof) then%>
<p>Your search for keyword<%=(Result.Fields.Item(&quot;keyword&quot.Value)%></p>
<%end if%>

 

[annettesue]

When I change to the display code, another problem occured:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/MyPublishedSite/TMP4rb1calkn5.asp, line 10

I've checked all the connection, it's correct.

annette

 

[vbkris]

sorry
'rs' was meant to be the recordset
<%if not(Result.eof and Result.bof) then%>
<p>Your search for keyword<%=(Result.Fields.Item(&quot;keyword&quot.Value)%></p>
<%end if%>

maybe this will work

 

[Tarwn]

The error you were originally receiving meant tht your recordset was coming back empty. If your going to print out what they searched for you should use the form value that was passed raher than the value from the recordset so even when there are no results the user will see what the searched for.
Concerning the second error, I would need to see line 10 (and the preceding lines) to see what the problem was. I don't see how vbkris' code that you added to line 34 would affect line 10, so it is likely to be a different problem.

-Tarwn ________________________________________________
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048