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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4