This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C0B1CF.C1D77666

Content-Type: text/plain;

	charset="iso-8859-1"



> I can display first page that have hyperlink,

> example:-

> 		My home

> 

>  but when i click the word it goes to the next page i want it to be... but

> it did not display the thing that i want and also it give me an error:

> 

> ADODB.Field error '80020009' 

> Either BOF or EOF is True, or the current record has been deleted; the

> operation requested by the application requires a current record. 

> 

> I think it has something to do with the second page.

> I dont know how to retrieve the data.

> 

> Code for the first page is:

> 

> <a

> href="displayboxpolicybody-try.asp?PolicyTitle=<%=rspolicy("PolicyTitle")%

> >"><%=rspolicy("PolicyTitle")%> </a>

>  

> Code for the second page is :

> 

> <%=request.form("PolicyTitle")%>

> 

> <%session("PolicyTitle")=request.form("PolicyTitle")%>

> 

> Help me  with the code ...

> 

This e-mail and any files transmitted with it ("Message") are intended only

for the use of the 

addressee named herein and may contain legally privileged and confidential

information. if you 

are not the intended recipient of the addressee indicated in this Message

(or responsible for 

delivery of this Message to such person ), you are hereby notified that any

dissemination, 

distribution,printing or copying of this message or any part thereof is

strictly prohibited. 

If you have received this Message in error, please immediately delete this

Message and 

advise the sender by return e-mail. Opinion, conclusions and other

information in this 

Message that do not relate to the official business of EON shall be

understood as neither 

given nor endorsed by EON.

Need help- Hyperlinks to the record in the dbYOu are trying to request a

queryString using Request.Form try:

<%=Request.QueryString("PolicyTitle")%>  the <%Request("PolicyTitle")%> will

also work. just it grabs anything (querystring or form) instead of just the

one.



Daniel

  -----Original Message-----

  From: Lizawati Bakri [mailto:LIZA_B@e...]

  Sent: Wednesday, March 21, 2001 1:26 AM

  To: ASP Databases

  Subject: [asp_databases] Need help- Hyperlinks to the record in the db





    I can display first page that have hyperlink,

    example:-

                    My home



     but when i click the word it goes to the next page i want it to be...

but it did not display the thing that i want and also it give me an error:



    ADODB.Field error '80020009'

    Either BOF or EOF is True, or the current record has been deleted; the

operation requested by the application requires a current record.



    I think it has something to do with the second page.

    I dont know how to retrieve the data.



    Code for the first page is:



    <a

href="displayboxpolicybody-try.asp?PolicyTitle=<%=rspolicy("PolicyTitle")%>"

><%=rspolicy("PolicyTitle")%> </a>



    Code for the second page is :



    <%=request.form("PolicyTitle")%>



    <%session("PolicyTitle")=request.form("PolicyTitle")%>



    Help me  with the code ...

I have run into this before but on the same page. Therefore my guess 

is ... 



+ that you either did not test for EOF before using the recordset 

  on the second page 



or 



+ since it sounds like you did not close the connection / recordset on the 

  first page and hit the recordset EOF on the secondpage. 



I believe you can fix this by using "rspolicy.movefirst" to set the 

recordset back to the first record  so that you can cycle through it again.



MJM