•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 373,479 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,936 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:
Views: 4734 | 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)
•
•
•
•
•
•
•
•
DaniWeb ColdFusion Marketplace
Linear Mode
Similar Threads
- XP - "Switch User" nonexistent password problem (Windows NT / 2000 / XP / 2003)
- need help with user and password (Visual Basic 4 / 5 / 6)
- Encrypt File using User Supplied Password (VB.NET)
- User Accounts in XP Pro x64 (Windows x64 Edition)
- Microsoft Entourage Problem (Mac Software)
- Setting user levels in MS ex-change server 2003 (Windows Software)
- User name and password for DirectoryEntry (C#)
- Lost XP Pro Admin Password (Windows NT / 2000 / XP / 2003)
Other Threads in the ColdFusion Forum
- Previous Thread: CF Job market
- Next Thread: Registration form help
