Thanks a lot!
I will try it
I might send you the code, I'll owe u 1 though!
----- Original Message -----
From: "Fregas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 5:00 PM
Subject: Re: easier in cf then asp, but i need it in asp
> 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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
