Last Login

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Simon (sruzgar_at_nospam.yahoo.com)
Date: 06/06/04 

Date: Sun, 6 Jun 2004 13:26:28 -0400

hi folks,

Im writing an ASP application where authors submit stories for use in a
book, everything is going pretty good so far however I have ran into a
stumbling block.

the publishers of the book can log into an admin panel and view/edit/delete
stories, I'm trying to add functionality that shows them how mang stories
have been submitted since they last logged into the site. I have the
following two tables:

tblSubmission = holds the story submissions
tblLastLogin = holds username and last login date

Both tables have a date field so how would I count the stories in
tblSubmission that are new since the last login date in tblLastLogin?

Thanks in anticipation
Simon Ruzgar

Relevant Pages

  • Re: Last Login
    ... The table "tblLastLogin" gets updated when ... intCount gets successfully populated with the number of stories since last ... login but intLastLogin does not get updated, ... If it gets updated as soon as the publisher logs in, ...
    (microsoft.public.access.queries)
  • Re: Last Login
    ... If it gets updated as soon as the publisher logs in, ... won't be any submissions that are newer than their login. ... WHERE S.SubmissionDateTime> (SELECT L.LastLoginDateTime FROM tblLastLogin L ... > stories, I'm trying to add functionality that shows them how mang stories ...
    (microsoft.public.access.queries)