brady.k — Wed, 01 Aug 2007 19:51:17 +0000

Also, if I were you, I would pull the username and password and stuff out FIRST and then filter it, store it in a variable... and then use that variable in the SQL rather than "Request.form(....", just for coding's sake.

JeevesBond — Wed, 01 Aug 2007 15:06:41 +0000

Drew wrote: LAST LOGIN = "UPDATE password WHERE user = '" & Request.form("login") & "' SET lastlogin = 'date'"'
Set rs = Apples.Execute(LASTLOGIN)'

LAST LOGIN Vs. LASTLOGIN notice the space in the variable name. Also, good for debugging, if you need to know what SQL is being passed to MySQL just do:

' DEBUG
Response.Write(LASTLOGIN)
' END DEBUG

By the way, all uppercase variable names are usually reserved for constants, you might wish to rename that LastLogin (or something similar). Just good programming practice.

Drew wrote: If it was in PHP I could prob do it!

It probably doesn't make much difference in this case as all you're doing is passing SQL to MySQL.

drew22299 — Wed, 01 Aug 2007 14:09:58 +0000

I can get this to work

SQLtemp = "SELECT * FROM password WHERE user = '" & Request.form("login") & "' AND UPDATE password WHERE user = '" & Request.form("login") & "' SET lastlogin = 'date'"

Set rs = Apples.Execute(SQLtemp)

I have tried the above but get a syntax error and I have also tried the following:

SQLtemp = "SELECT * FROM password WHERE user = '" & Request.form("login") & "'

LAST LOGIN = "UPDATE password WHERE user = '" & Request.form("login") & "' SET lastlogin = 'date'"

Set rs = Apples.Execute(SQLtemp)
Set rs = Apples.Execute(LASTLOGIN)

I'm really not sure how to do this and it should be simple! If it was in PHP I could prob do it!

brady.k — Tue, 31 Jul 2007 20:05:42 +0000

This is an easy answer!

When they login, process a small script that just sends an UPDATE query to the user's info and sets "lastlogin" to the current date. But only run this on every login, and then it will be a "last login" for sure.

It should look something like:

UPDATE password WHERE user = '[userid]' SET lastlogin = '[date_variable]'