Wouldn't you want to make that Login.RecordCount EQ 1. If you get more than one record back you've clearly allowed duplicate user records and need to take some action to correct that problem.
-----Original Message----- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 8:27 AM To: CF-Talk Subject: RE: Another Challenging question You might want to switch your cfif statement. I think it is backwards. If the recordcount is greater or equal to one that's a valid login, else if it is zero, it was an invalid login. Like: <cfif Login.RecordCount IS 0> <cflocation url="invalidlogin.cfm?"> <cfelseif Login.RecordCount IS GTE 1> <cflocation url="validlogin.cfm?"> </cfif> ----------------------------------------------- Kevin Kazmierczak, CCNA Certified Advanced ColdFusion MX Developer Alfred University Alumni Hall 607-871-2334 [EMAIL PROTECTED] -----Original Message----- From: Sangeeta Karmokar [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 2:12 AM To: CF-Talk Subject: Another Challenging question I am not sure how to add a new thread. So I am posting this message here.. I am a new user of CFMX and I am creating Login and Password page with Access as Database. CAn anyone check as this CF script is ok: <cfquery name="Login" datasource="Users"> SELECT * FROM Login WHERE Usr_Name = #form.Usr_Name# AND Usr_Password = #form.Usr_Password# </cfquery> <cfif Login.RecordCount IS 0> <cflocation url="validlogin.cfm?"> <cfelseif Login.RecordCount IS GTE 1> <cflocation url="invalidlogin.cfm?"> <cfelse> </cfif> <!--end login_action.cfm--> Where Users is my datasource and Urs_Name and Urs_Password is my field names. Please can anyone help me. Sangeeta ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
