0

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!!!

2
Contributors
2
Replies
3
Views
13 Years
Discussion Span
Last Post by cfnut
0

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.

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!!!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.