[SOLVED] ASP Session Variable

Monie · #1 Oct 4th, 2007, 04:34

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: Select all

    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: Select all

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 · #2 Oct 4th, 2007, 04:54

Well.

I manage to solved it here:

Code: Select all

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 · #3 Oct 4th, 2007, 07:43

Can you mark the thread as solved please. Cheers.

Monie · #4 Oct 4th, 2007, 08:09

How to do that?

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

welshstew · #5 Oct 4th, 2007, 08:39

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 · #6 Oct 4th, 2007, 08:52

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 · #7 Oct 5th, 2007, 06:20

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 · #8 Oct 10th, 2007, 02:44

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing a session variable when clicking a link?	Crow555	Classic ASP	0	May 15th, 2008 12:22
Session variable errors	fogofogo	PHP Forum	2	Dec 16th, 2005 12:23
Assign string values to integer values of a session variable	Andy K	Classic ASP	1	Jul 13th, 2005 08:29
problem with Session variable	andrew_perez5	Classic ASP	0	Jan 24th, 2005 03:42
session variable	Monie	Classic ASP	7	Aug 30th, 2004 03:52

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
[SOLVED] ASP Session Variable