This is a pretty lenghty question s 1

[jeevenze]

This is a pretty lenghty question so I want to thank anyone in advance who helps me.

I'm learning to use Ultradev 4 and am trying to follow the author to the tee but am still having trouble with some of his instructions. Essentially I have a table with user information and a few options corresponding to the user.

I'm using the ultradev user authentication system where I have a form set up with fields using username and password.

After a user has a successful login (s)he is directed to a page where the user is shown his own options.

Now the way I (author) have it set up is I've created a recordset where the results are filtered by the username using a session variable "username"

Now the author states "The MM_Username session variable is set automatically when the user successfully completes the Log in server behaviour. You can use it as you would use a session variable that you set yourself."

When I go through the process of loggin in I get an error message:
"ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record."

Essentially I think that the recordset is not receiving a username from the session "username".

So ultimately the question I have is, how can I filter my recordset using a session variable that is set by ultradev's user authentication system.

Thank you to anyone who helps me.

 

[Kingmarl]

You need to filter by the session variable 'MM_Username' not just 'username' as 'MM_Username' is the name given to the variable as default. I've just done a site using the exact same system and It work excelently, Well done for spotting it.
I

All Macromedia products use the 'MM_' before just about everything so keep and eye out for it in the future. ----------------------------------------Don't forget to visit

http://www.sovereign2k.com/rob

for some banging new music from DJ Cumback (ME!)