On error

[polilop]

I have a page that opens a recordset (gets id from previus) but there may
not be values in the table
for the given id, so i get the BOF EOF errors. How can i handle the error so
it can
redirect to previus? All that i found is on error resume next is there
someway to
say on error go to a function?

[Bob Barrows [MVP]]

polilop wrote:

I have a page that opens a recordset (gets id from previus) but there
may not be values in the table
for the given id, so i get the BOF EOF errors. How can i handle the
error so it can
redirect to previus? All that i found is on error resume next is there
someway to
say on error go to a function?

No,

Best practice is to check if EOF is true immediately after opening the
recordset. There is never any reason to raise a BOF/EOF error.

'open the rs, then:

if not rs.EOF then
'process the rs
else
'handle the empty-recordset situation
end if

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[polilop]

thanks
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

polilop wrote:

I have a page that opens a recordset (gets id from previus) but there
may not be values in the table
for the given id, so i get the BOF EOF errors. How can i handle the
error so it can
redirect to previus? All that i found is on error resume next is there
someway to
say on error go to a function?

No,

Best practice is to check if EOF is true immediately after opening the
recordset. There is never any reason to raise a BOF/EOF error.

'open the rs, then:

if not rs.EOF then
'process the rs
else
'handle the empty-recordset situation
end if

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"