in cf it is a lot easier
unfortunately, I need it in asp, which doesn't work so well
but thanks for your effort:)
dave
----- Original Message -----
From: "John Paul Ashenfelter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 2:33 PM
Subject: Re: easier in cf then asp, but i need it in asp
> 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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
