Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50

    Unanswered: How can I "log" when a user loads an ASP?

    Hello

    I have a sql server 2000 database, accessed via some data access pages developed using Access 2000. I would like to be able to "log" which user and when loaded the said pages, that is to be able to perform a triger-like action such as:

    Insert into logtable (Page_accessed, User, time)
    select 'Mypagename', current_user, getdate()

    What changes should I make to my data access page?

    THX

    Marp

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Insert into logtable (Page_accessed, User, time)
    Yes, write the code to insert the information into the database (perhaps the username is stored in a session variable, etc.). And perhaps put this code in a function in an included file. And of course call the function at the top of each page:

    ' Pg entry log.
    Call PgEntryLog()
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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