Maybe I'm misunderstanding, but wouldn't your login simply be a SELECT from
the db to get the validation credentials? Or is this using NT
Authentication? If it's a simple db lookup, you just put two queries in the
login page -- the login itself and the insert. You can make it even easier
by having the login check call a stored proc that does the validation and
the insert. (sorry -- just saw Access. No stored procs).
Something like
<CFQUERY name="validateLogin">
SELECT user.*
FROM user
WHERE user.username = '#form.username#' AND user.password='#form.password#'
</CFQUERY>
<CFIF validateLogin.recordcount EQ 1>
<CFQUERY>
INSERT INTO tblLogins(username,logTime) VALUES('#form.username#',NOW())
</CFQUERY>
rest of page
<CFELSE>
Bad login/etc
You can do this much slicker, but this gets the point across.
So just two queries on the login page -- that's it. Or is there something
more complicated going on?
Regards,
John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
----- Original Message -----
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 1:59 PM
Subject: easier in cf then asp, but i need it in asp
> Sorry for posting this here but no one seems to know on the asp boards.
> I pretty much have this figured out in cf but not as easy in asp.
> I have a clients site that is in asp and they need to track when a person
logs in
> for example, they need to be able to pull up employee "A" and see their
login history, As they are supposed to be logging in at certain intervals.
> They dont want any additional pages or buttons to push, so when an
employee logs in it also inserts a new entry into the db table called
"tblTrackLogins"
> I dont believe you can do a login and insert at the same time in ASP. The
only way I have really been able to do this is to post the login form to
another page and then have them hit a submit button to insert it but they
dont want that.
> The only entry I really need to pull is their "username" and then just
have the db insert the "Now()" when created.
> BTW, ASP & Access 2000
>
> thanks!
>
> Dave
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
