VB & SAL Date/Time Problem?

From: Richard Gutery (rgutery_at_mentorits.com)
Date: 12/20/04 

Date: Mon, 20 Dec 2004 06:31:25 -0700

I've written an ASP app that requires users to login - normal stuff.

As is typical with users, sometimes they just close the browser which
teminates the app. What I've done is created a new table in SQL that inserts
the date & time when a user logs in. All is well as other stuff.

If the user then comes along and tries to log in again, I place this
information into another table (for troubleshooting and reporting). However
the logic in my program prevents them from logging in again for some period
of time.
I do a query against Active_Users table, and if the user id is in the table,
they cannot
login again.

We do this so that users don't run multiple copies of the browser
(we know that users minimize stuff). Our app cannot allow users to
log in more that once during an active session.

What I'd like to be able to do is to delete an OLD record (say from
yesterday in an ADMIN capacity) from the table based on the current
date/time.

My problem is that all records get deleted from the table based on the
following SQL statement:

StrSql = "DELETE FROM active_users WHERE Last_Seen <=' " &
DateValue(StrOnlineTimedOut) & "'"

Date/Time format in SQL: 2004-12-20 05:58:00.
Format of StrOnlineTImedOut: 12/20/2004 6:18:20 AM

Script looks like this (essentially StrOnlineTimedOut is 5 minutes from
NOW):
onlinedate = now()
strTimeout = 1 (I actually pull this from another table, it's here for
clarity)
StrOnlineTimedout = dateadd("n",-strtimeout*5,onlinedate)

So I believe that what I need to do is to convert the date time format from
VB to an SQL format?

Does anyone know of a VB Date/Time statement that will do this?

Thanks in advance.

RG

Relevant Pages

  • SQL & VB Dates/Times!!!
    ... I've written an asp app that requires users to login - normal stuff. ... browser. ... Script looks like this (essentially StrOnlineTimedOut is 5 minutes from ...
    (microsoft.public.vstudio.general)
  • Re: 2003 Server ASP.NET Problem (IE Only!)
    ... Is scripting disabled in the browser? ... It doesn't seem to be a problem with IIS, since IIS does not care about ... > first screen and clicks "Login", but the app doesn't do anything. ...
    (microsoft.public.inetserver.iis)
  • Re: Coonect to mail account using Tcl/Tk
    ... Opens an Browser the specified url... ... $app Navigate http://gmail.com ... set user [lindex $argv 0] ... User types his login info on the command line in which case he might ...
    (comp.lang.tcl)
  • Re: How to logoff?
    ... when they close the browser ... ... > I have windows integrated authentication for a asp.net app. ... > browser that login will be authenticated as long as it's open, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Tkinter or wxpython?
    ... If you can get them to install a desktop app ... The permission mechanism is admittedly browser dependent. ... not so much for an application platform. ... HTML has non-trivial cross browser differences. ...
    (comp.lang.python)