Solved

Changing ColdFusion script for SQL queries to queries for ACCESS

Posted on 2007-11-21
2
148 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

696 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