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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=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
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=subscribeforumid=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
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=subscribeforumid=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
Re: easier in cf then asp, but i need it in asp
You'll have to use a global.asa (similar to application.cfm) to initialize and hold session variables for the authenticated user, and include something like this in the Session_OnStart method... ' NT challenge response. Make sure the user is logged in to the ' network. If Request.ServerVariables(LOGON_USER) = Then Response.AddHeader WWW-Authenticate, ntlm Response.AddHeader WWW-Authenticate, basic Response.Status = 401 Unauthorized Response.End ElseIf Request.ServerVariables(LOGON_USER) AND Session(Authenticated) = False Then ' Do Database Insert Here of Login and DateTime... ' Set authenticated session var to true... Session(Authenticated) = True End if Maybe this can get you started... HTH, Jeff - Original Message - From: Dave Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 11:59 AM 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easier in cf then asp, but i need it in asp
right on, thank you this might call 4 a thinking session on the thrown haha - Original Message - From: Jeff Garza [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 2:47 PM Subject: Re: easier in cf then asp, but i need it in asp You'll have to use a global.asa (similar to application.cfm) to initialize and hold session variables for the authenticated user, and include something like this in the Session_OnStart method... ' NT challenge response. Make sure the user is logged in to the ' network. If Request.ServerVariables(LOGON_USER) = Then Response.AddHeader WWW-Authenticate, ntlm Response.AddHeader WWW-Authenticate, basic Response.Status = 401 Unauthorized Response.End ElseIf Request.ServerVariables(LOGON_USER) AND Session(Authenticated) = False Then ' Do Database Insert Here of Login and DateTime... ' Set authenticated session var to true... Session(Authenticated) = True End if Maybe this can get you started... HTH, Jeff - Original Message - From: Dave Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 11:59 AM 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: easier in cf then asp, but i need it in asp
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=subscribeforumid=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
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=subscribeforumid=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
Re: easier in cf then asp, but i need it in asp
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=subscribeforumid=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
