hello


pls it's more then 1 week that i have a this error and i don't find any good answer :

Type d'erreur :
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/annuaires/reults66.asp, line 63

i have look for an answer in the site of macromedia but they anly say that i must do the server behavior show region , but even if i do it , i have already this probleme .

so when i want to look for some info from my data , i can see the first 10 list and when i click in the next i have this msg , or when i want to search some think that i don't have in my data

Notes: i have this error anly when i use the methode server.mapath to connecte to my database and if i use DNS no,
i m using UD4 and access97 and ADO2.7 and i m using live object/ master detait page set to dispaly my recordset to the page


any suggestion will be apprecie

well, you would only get this error if the query did not return any records... in theory the show region should work... but if you can't figure it out... try doing some custom coding.
just make sure to put this around anything that uses the recordset, because if you try to access one of the fields if it's eof (end of file), y ou'll get the error
example:<pre id=code><font face=courier size=2 id=code><b>&lt;%if not recordset1.eof then%&gt;</b>
do all your processing &lt;%=recordset1.fields("here".value%&gt;
<b>&lt;%else%&gt;</b>
No recordset where found
<b>&lt;%end if%&gt;</b></font id=code></pre id=code>Notice that the else clause will show if the recordset is eof, thus you have no chance of getting the error.

hope that helps,

Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser

think's for your help
you are right i don't have any error when i use then condition and for the error that i have when i click in the next of the page the results , it was because i use the methode POST and after i use GET , it will be work very good