
October 27th, 2003, 09:14 PM
|
|
Contributing User
|
|
Join Date: Oct 2003
Posts: 570
Time spent in forums: 2 Days 12 h 1 m 47 sec
Reputation Power: 0
|
|
|
Cookie and sql in ASP
I am trying to use a cookie to store email and password after executing my sql statement on my ASP page. When I put my cookie code after executing my SQL I get error. Can anyone tell me why i am geting this error? Here is my code. I must mention if I put the cookie code before executing SQL it works fine...
str = "Select * from customer_login1 where email ='" & email & "'"
Set rsEvents = conn.Execute(str)
if rsEvents.EOF Then
emailfound = "no"
response.cookies("savedlogin")("email")= request.form("email")
response.cookies("savedlogin")("pw")= request.form("password")
response.cookies("savedlogin").expires= Date + 30
else
emailfound= "yes"
end if
__________________
web developer
|