I am not sure how add a new thread. So I am posting this message here..
I am 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
