Re: VB & SAL Date/Time Problem?
From: Uri Dimant (urid_at_iscar.co.il)
Date: 12/20/04
- Next message: Dan Guzman: "Re: VB & SAL Date/Time Problem?"
- Previous message: Dan Guzman: "Re: Difference between insensitive and fast-forward cursors."
- In reply to: Richard Gutery: "VB & SAL Date/Time Problem?"
- Next in thread: Dan Guzman: "Re: VB & SAL Date/Time Problem?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Dec 2004 15:40:59 +0200
Richard
Write a stored procedure that accepts a datetime parameter. On the client
site you can format it as YYYYMMDD.
"Richard Gutery" <rgutery@mentorits.com> wrote in message
news:OE2l1gp5EHA.1392@tk2msftngp13.phx.gbl...
> 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
>
>
>
- Next message: Dan Guzman: "Re: VB & SAL Date/Time Problem?"
- Previous message: Dan Guzman: "Re: Difference between insensitive and fast-forward cursors."
- In reply to: Richard Gutery: "VB & SAL Date/Time Problem?"
- Next in thread: Dan Guzman: "Re: VB & SAL Date/Time Problem?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
