It should be just as easy in asp. Open your connection to the db, then run the two queries. I don't understand why this would be any more difficult in asp than in CF. I am not an ASP person, so this took a bit of playing to get just right, but it should be totally doable.
If your checking against a db it should be something like this: <% Set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open "FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\test.dsn" SQL_query = "select * from users where cUserName = " & "'tim' " & "and cPassword = " & "'test'" Set RS = MyConn.Execute(SQL_query) dim rsc rsc = 0 WHILE NOT RS.EOF rsc = rsc + 1 if rsc > 0 then response.write(rs("cUserName")) sql2 = "insert into logs(numbers) values(2)" Set rs2 = MyConn.Execute(sql2) end if RS.MoveNext wend %> Tim -----Original Message----- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 2:44 PM To: CF-Talk Subject: Re: easier in cf then asp, but i need it in asp 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