ColdFusion

Setting up user name and password

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2004

Posts: 8

Reputation: cfnut is an unknown quantity at this point

Solved Threads: 0

cfnut

Offline

Newbie Poster

Setting up user name and password

Jul 21st, 2004

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

•

Join Date: Jun 2004

Posts: 29

Reputation: dazzlindonna is an unknown quantity at this point

Solved Threads: 3

dazzlindonna dazzlindonna is offline

Offline

Light Poster

Re: Setting up user name and password

Jul 21st, 2004

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.

•

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