Forums

ASP

This topic is locked

EOF/BOF error when recordset is not empty

Posted 17 Sep 2007 13:25:51
1
has voted
17 Sep 2007 13:25:51 Chris Gregory posted:
Good Morning

Forgive me if my explanation is not clear however this is my first post!

I am slowly trying to build a user specific area of a website that contains certain user specific dynamic elements and as such the recordsets that i use are filtered based on session variables sepecified on the login page.

Although i can see within dreamweaver that the recordset is working when i specify test data for the session variable when i test this on the server i get an "EOF/BOF is true, current record required" error.

I know that the record i am trying to retreive exists as i have checked the database and it certainley appears when i test within Dreamweaver.

The only logical explanation i can think of is that, for some reason, the session variable declared on the login page is not passing the data to the user specific page.

Has any one experienced this before?

Is there any way of seeing whether session variable data is being passed between pages?

Does anyone have an idea of where i should be looking to rectify this issue.

Any assistance or guidance would be most aprreciated as this is giving me a headache!

Cheers

Chris

Replies

Replied 05 Oct 2007 18:25:53
05 Oct 2007 18:25:53 Lee Diggins replied:
Hi Chris

Welcome to DMXone.

You can try Response.Write(Session("SessionName") and see if you get the coorect session displayed.

Post back if you have any further details.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Reply to this topic