If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > BOF or EOF ERROR

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-21-03, 21:56
luisantonio luisantonio is offline
Registered User
 
Join Date: Sep 2002
Location: San Juan, Puerto Rico
Posts: 29
Red face BOF or EOF ERROR

I am getting this error when I press my link for update:

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

I know it is because the table is empty, I am trying to put the code below so when the user tries to select the update link it takes him to an custom error page that display that there is no data to update.

My code:
<%
If Rs.BOF or EOF then
response.redirect "entrar_resume.asp?error=3"
End If
%>

Other thing it might work is that the link does not displays if the record on the table is empty, but I don't know how to do this one.
Reply With Quote
  #2 (permalink)  
Old 09-22-03, 22:22
melissa007 melissa007 is offline
Registered User
 
Join Date: Sep 2003
Posts: 4
hey

My code:
<%
If Rs.BOF or EOF then
response.redirect "entrar_resume.asp?error=3"
End If
%>


i guess the problem above is in EOF, try this line of code

If Rs.BOF or Rs.EOF then
Reply With Quote
  #3 (permalink)  
Old 09-23-03, 07:36
melissa007 melissa007 is offline
Registered User
 
Join Date: Sep 2003
Posts: 4
hey

also try

If Rs.BOF And rs.EOF then
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On