return from db

hi

i have set up a page which uses a session ID. (username under the db) How do i write asp code to get the session and then select all the details in that record for use in hidden email fields.

cheers

Hi

Could you please explain a bit more. Where is the Session ID coming from?

How does the session ID relate to the persons details in the database? Are you saying that you are generating your own session ID's and have your own state management tool?

Or are you saying that a person logs in, and you store their username or some other PK in the session object, and from that you need to get their details from the database?

hi

sorry i wasnt very clear was i

it twas the latter, i didnt know there was other session types in asp

sombody logs in - the session is the username in the db, but i have a link to another page. what i want is the session id to be checked with the records in the db so i can have them as values in hidden form fields.

hope that clarified it

thanks

I haven’t got it clearly make it clear may be I can help!

sorry - again!

ok - i have a login page. user logs in (details in db)and a session is created (username)

i have a link to another page

here i want to check the session name and then get the details for that username from the db such as full name, email address etc

i wana use these details in hidden fields (not important but i added it)

hope thts simple enogh
thanks

ive sorted it out now anyway