Ryan Bayne
asked on
Changing ColdFusion script for SQL queries to queries for ACCESS
Here is an example...
<cfquery name="GetUser" datasource="truckpoetry">
SELECT *
FROM Users
WHERE UserName = '#Form.UserName#'
AND Password = '#Form.Password#'
</cfquery>
I badly need a simple ColdFusion page that allows user to login using information (Username and password) provided during registration with a basic correct or wrong reply. All tutorials seem to be for SQL.
Can someone help me understand how to make them suit an ACCESS database.
Thanks
<cfquery name="GetUser" datasource="truckpoetry">
SELECT *
FROM Users
WHERE UserName = '#Form.UserName#'
AND Password = '#Form.Password#'
</cfquery>
I badly need a simple ColdFusion page that allows user to login using information (Username and password) provided during registration with a basic correct or wrong reply. All tutorials seem to be for SQL.
Can someone help me understand how to make them suit an ACCESS database.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER