Home > ASP Development > Got it working but....

Got it working but....



when you click on a date which has no records it shows: ADODB.Field error '800a0bcd'



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



/bpubs/result2.asp, line 292



line 292:

Code:


 <td colspan="3"><span class="style5">Events on <strong><%= DoDateTime((rsResult.Fields.Item("eventDate").Value), 1, 1033) %> </strong></span></td>






In dreamweaver i have added the SHOW IF statement if recordset is empty



and SHOW IF there are no records?! but its not working??!

www.mutedesigns.co.uk/bpubs

J

    
Guest


can you post the code where you open the recordset

and check if its empty or not?

it should look something like this


Code:



if rs.EOF then
response.write "no records!"
response.end
else
response.write "Records found!"
end if



Was this answer helpful ? Yes No   
Guest


done it!

Was this answer helpful ? Yes No   
Guest


done it what?



if its not working, post the code here, or did that do it, and now

its working?



sorry, im tired tonight

Was this answer helpful ? Yes No   
Guest
 
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved