Hello Everybody. i have problem in the searching a particular record in the database. If records exists well and good other wise it given me the error "Either EOF Or BOF Accurd and the record has been deleted.". Secondly please assist me how can I assert paging in the code given below.Any help will be highly appreciated.
Bye
-------------------------------------------------------
set con=Server.CreateObject("ADODB.Connection")
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from book_issue where accession_no='"&ac&"'"
con.open str
rs.open sql,con,2,2
'if rs.eof<>"true" then
'''''''''How to know if the search is empty''''''''
accessionno=rs("accession_no").value
title1=rs("title").value
rs.close


Zaeem Sherazi

__________________
Zaeem Sherazi

don't know if i simplified ur problem, but u should use if-then-else statements.

<%open rs
if rs.eof=false then
*yourcode*
<% else %>
    *error message*
<%End if
close rs%>

there are many examples on the net.
a good example of paging: http://www.asp101.com/samples/db_paging.asp

<%
if rs.RecordCount=0 then
*error message*
else
*yourcode*
end if
%>

surendran