Solved

Changing ColdFusion script for SQL queries to queries for ACCESS

Posted on 2007-11-21
2
145 Views
Last Modified: 2013-12-16
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
Comment
Question by:Ryan Bayne
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 250 total points
ID: 20332369
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
 
LVL 2

Author Comment

by:Ryan Bayne
ID: 20333114
Excellent!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question