Please support our ColdFusion advertiser: Programming Forums
Views: 5099 | Replies: 2 | Solved
 |
•
•
Join Date: Jul 2004
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I have a page where the user can enter his username and password. Does anyone have any examples on how to check the database for to make sure the user matches the username and password.
Thanks!!!
Thanks!!!
•
•
Join Date: Jun 2004
Location: Louisiana, US
Posts: 24
Reputation:
Rep Power: 5
Solved Threads: 3
Newbie Poster
Something like this should do it:
<CFQUERY name="login" datasource="#dsn#">
SELECT *
FROM Users
WHERE UserName='#username#'
AND Pwd = '#pwd#'
</CFQUERY>
Of course your datasource, table name, fieldnames, and variables have to match your situation.
<CFQUERY name="login" datasource="#dsn#">
SELECT *
FROM Users
WHERE UserName='#username#'
AND Pwd = '#pwd#'
</CFQUERY>
Of course your datasource, table name, fieldnames, and variables have to match your situation.
•
•
•
•
Originally Posted by cfnut
I have a page where the user can enter his username and password. Does anyone have any examples on how to check the database for to make sure the user matches the username and password.
Thanks!!!
I need to check my ColdFusion Calendar because I think Christmas is coming soon! ;)
***********
Get all the SEO news and tips at SEO Scoop
***********
Get all the SEO news and tips at SEO Scoop
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
