Login Success Every Time is a Bad Thing!!

[Xylum]

Having a little trouble here. New to dreamweaver and coldfusion. Got my
registration page down. But my login accepts every username and password even
though I've got Log In User marked under server behaviors. It's good that I'm
getting a successful login, but not EVERY time any value is entered. It should
only allow a successful attempt if it matches my database of usernames and
passwords, correct? Any help is much appreciated. Thanks in advance.

[Xylum]

Having a little trouble here. New to dreamweaver and coldfusion. Got my
registration page down. But my login accepts every username and password even
though I've got Log In User marked under server behaviors. It's good that I'm
getting a successful login, but not EVERY time any value is entered. It should
only allow a successful attempt if it matches my database of usernames and
passwords, correct? Any help is much appreciated. Thanks in advance.

[Dan Bracuk]

If you want success to be based on matches on your database, you have to query that database. Your post implies that you are not doing that.

[mxstu]

Hi Xylum,

You might get a better response to Dreamweaver questions in the Dreamweaver forums:
[url]http://www.macromedia.com/cfusion/webforums/forum/index.cfm?forumid=12[/url]

Good Luck

[sattman]

<cfquery name="anyname" .....>
select username, password
where username="#form.username#"
</cfquery>
<cfoutput query="anyname">
<cfif form.username is "#username#">
Login good.....do something
<cfelse>
Login bad....do something else
</cfif>

[BKBK]

<cfquery name="loginQuery" datasource="my_DSN">
select username, password
where username=<cfqueryparam cfsqltype="CF_SQL_VARCHAR" maxlength="30"
value="#form.user_name#">
and password=<cfqueryparam cfsqltype="CF_SQL_VARCHAR" maxlength="10"
value="#form.psswrd#">
</cfquery>
<cfif loginQuery.Recordcount GT 0>
<cfloginuser ...etc etc>
<cfelse>
Login bad....do something else
</cfif>

[Xylum]

My session manager was NOT turned on in coldfusion. I'm still not quite sure
how to turn it on. But I did take this text out of one of the cold fusion help
topics and pasted it to the top of my login page and now my session manager for
that page is turned on. My Login now works. The text I took and pasted in the
code at the very top of my login page is as follows:

<CFAPPLICATION NAME="Name"
SESSIONMANAGEMENT="Yes">

[Xylum]

My session manager was NOT turned on in coldfusion. I'm still not quite sure
how to turn it on. But I did take this text out of one of the cold fusion help
topics and pasted it to the top of my login page and now my session manager for
that page is turned on. My Login now works. The text I took and pasted in the
code at the very top of my login page is as follows:

<CFAPPLICATION NAME="Name"
SESSIONMANAGEMENT="Yes">

Thanks for the help guys.

[Xylum]

Thanks for the help guys!!