[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

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
0
Ryan Bayne
Asked:
Ryan Bayne
1 Solution
 
_agx_Commented:
That query works perfectly against an Access database.   Note, the attached is _not_  a good way to do a login.  It's an example meant to demonstrate the query does work 'as is' with Access.


<cfif IsDefined("form.submitButton")>
	<cfquery name="checkUser" datasource="truckpoetry">
		SELECT  *
		FROM	Users
		WHERE   UserName       = '#Form.UserName#'
		AND     Password       = '#Form.Password#'
	</cfquery>
	<cfif checkUser.recordCount GT 0>
		<div style="color: #008000;">
			Success.  Username and password validated!
		</div>
	<cfelse>	
		<div style="color: #ff0000;">
			Error. Invalid username or password entered
		</div>
	</cfif>
</cfif>
 
<!--- change thisPage.cfm to name of your test page ---> 
<form action="thisPage.cfm" method="post">
	UserName <input type="text" name="userName"><br>
	Password <input type="password" name="password"><br>
	<input type="submit" name="submitButton">
</form>

Open in new window

0
 
Ryan BayneWordPress DeveloperAuthor Commented:
Excellent!
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now