Click to See Complete Forum and Search --> : Sql+cookies


hussein2000
October 9th, 2006, 04:43 AM
Hello friends

i have this problem in asp because of the sql statement

i want to retrive data from database acording to the cookies no
the cookie name is record bu i do not know how to put the cookie within sql sataement
can i do the sataement like this ?

select mees, e_name from imp_loc where loc_mess="record"

please help me

Shuja Ali
October 9th, 2006, 05:20 AM
You store your cookies in Session variables and you can then use them like this Session("USERNAME") = "thisUser"
sql = "Select * From USERTABLE Where USERNAME = '" & Session("USERNAME") & "'"