[SOLVED] ASP Session Variable

Monie · October 4th, 2007, 12:34 AM

I know this sounds simple to you guys, but I can't find anywhere in the internet on how to solve this.

Basically, I have a login page..
and a verify.asp page which will set the session variable to the user username:

Code:

    if rs("password") = Password then
        Session("name") = Request.Form("txtUsername")
        ......
        ......
        Response.Redirect("protectedpage.asp")

Here is the question:
In the protectedpage.asp page, I want to perform an update statement reffering to the username, something like this:

Code:

If Session("name") = "" Then
    Response.Redirect("login.asp")
Else
    Dim cn,sql,rightnow,user,mySessionID
    rightnow = date()
    mySessionID = "this part i want to pull the session value but I dont know the format?"
        Set cn = Server.CreateObject("ADODB.Connection")
        cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("db/users.mdb")
        Set sql = cn.Execute("UPDATE userlist SET LastActive = " & rightnow & " WHERE username =  "this part??" ")

End If

Monie · October 4th, 2007, 12:54 AM

Well.

I manage to solved it here:

Code:

Set sql = cn.Execute("UPDATE userlist SET LastActive = " & rightnow & " WHERE username =  '" + Session("name") + "'")

what is the different between this two?
'" + Session("name") + "'
'" & Session("name") & "'

either one will work...

welshstew · October 4th, 2007, 03:43 AM

Can you mark the thread as solved please. Cheers.

Monie · October 4th, 2007, 04:09 AM

How to do that?

I have been trying to do that since yesterday....

welshstew · October 4th, 2007, 04:39 AM

On my view you open up the thread you started, go to thread tools, and then there should be a option to mark thread as solved.

Stew

Monie · October 4th, 2007, 04:52 AM

Quote:

Originally Posted by welshstew

On my view you open up the thread you started, go to thread tools, and then there should be a option to mark thread as solved.

Stew

Maybe it's on the new theme. I can't find the option to mark thread as solved?

Monie · October 5th, 2007, 02:20 AM

Strange thing happen!

When I logged on to my page successfully, it will capture the date and time and save it to the database.

In the success.asp page (after successfully logged in) I will display the date and time too but when I click the refresh button, the date keeps on updating real time according to the current time.

Can that be fixed a date and time value?
I am using now() function to capture the date and time and save it to the database.

Thanks

Monie · October 9th, 2007, 10:44 PM

Yeah. I solved it.
Don't create a recordset in the page where you display that time from the database.
Don't perform the sql statement in the page where you will display the time..

Quote:

Originally Posted by monie

Dim user
user = Session("name")
Set sql = cn.Execute("UPDATE userlist SET LastActive = " & rightnow & " WHERE username = '" & user & "')

Create them inside the verify.asp page!
login.asp > verify.asp > success.asp