Ok. What you need to do is after the login check do an if statement. If the login was successful, use something like this:
dim cmd set cmd = Server.Create("ADODB.Command") cmd.ActiveConnection = MyADODBConnection cmd.CommandText = "insert into tblTrackLogins (username) values (" + MyUserRecordset("username") + ")" cmd.Execute MyADODBConnection is a connection object I assume you already have instantiated from the login check. Similarily, MyUserRecordset would be the ADO recordset from your login check and you just grab whatever the username field is. If you need more help, send me your page of code off list. Craig ----- Original Message ----- From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 2:36 PM Subject: Re: easier in cf then asp, but i need it in asp > right, just checks the db > > > ----- Original Message ----- > From: "Fregas" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 08, 2003 3:22 PM > Subject: Re: easier in cf then asp, but i need it in asp > > > > So does thethe DWMX form just do a look up in your database or does it > have > > some other method of authentication? I don't really use DW very much. > > > > Craig > > > > ----- Original Message ----- > > From: "Dave Lyons" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 08, 2003 1:46 PM > > Subject: Re: easier in cf then asp, but i need it in asp > > > > > > > asp3 > > > using the standard dwmx login form, non-secure > > > unfortunately, they won't let me spend the $ to get them cfmx > > > > > > ----- Original Message ----- > > > From: "Fregas" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Wednesday, January 08, 2003 2:38 PM > > > Subject: Re: easier in cf then asp, but i need it in asp > > > > > > > > > > 1) Are you using asp3 or asp.net? > > > > 2) as someone else asked, how are they logging in? Thru a form on an > > asp > > > > page or from a pop-up that the web server gives (NT > Challenge/response, > > > > Authentix, or something similar. In other words, where does the user > > > > database come from?) > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Dave Lyons" <[EMAIL PROTECTED]> > > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > > Sent: Wednesday, January 08, 2003 12: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