drawing a blank

Results 1 to 2 of 2

Thread: drawing a blank

  1. #1
    Join Date
    Dec 1969

    Default drawing a blank

    having a brain fart!<BR><BR>i want to put the date when a user logs in....the column is &#039;last_login&#039; in the db

  2. #2
    Join Date
    Dec 1969

    Default Yes? So what DB?

    And what are you doing now, if anything?<BR><BR>Assuming you have nothing at all:<BR><BR>Access: <BR><BR>SQL = "UPDATE someTable SET last_login = Date() WHERE userID = " & currentUserID<BR><BR>SQL Server:<BR><BR>SQL = "UPDATE someTable SET last_login = getDate() WHERE userID = " & currentUserID<BR><BR>But the SQL Server version will give you the date *and* time of the last login. If you want date-only, then you have to write more code.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts