using session in query

[indianswz]

hi....

can i use session id in an select query ?

when a user has logged in then his id is stored in the session and i want to fetch the information related to that user whose id is stored in the session by comparing in the database and retrieving the records with same user id.

hope u get what i want to know......

write me if u can't get ?

bye

 

[wessamzeidan]

I hope I understood what you mean...

dim qry as string="select * from user where id=" & Session.item("id")

 

[Arch4ngel]

SessionID isn't dynamicly generated ?
If yes... why put it in a DB ?

I'll go for authenticating the user to remember which section and what he modified.

But I don't know your problem and it would maybe not be appropriated.

 

[indianswz]

i just want to check the database for the record of the user who has logged in and so....i want to get his account information in an editable area so that he can change his account information. so, i think there is one way to do this get the session of the user and use it in the select * from login where (use session here)......so is there any way.......

 

[wessamzeidan]

You can use
Page.user.name to get the id of the logged in user and use it in your query, as I showed you before

 

[Arch4ngel]

I agree with wessamzeidan.
SessionID is dynamic and the Username is much more static.

Go with the second.