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