ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX
PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN
APPLICATION.
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.
The error occurred in
C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line 19
Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line
206
Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm:
line 17
Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.cfm: line
19
Called from C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.cfm: line
206
Called from C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.cfm:
line 17
17 : SELECT *
18 : FROM Users
19 : WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#'
20 : </cfquery>
21 :
SQL SELECT * FROM Users WHERE UserLogin = 'paulw' AND Password = 'PPMILL'
DATASOURCE RickRossiter
VENDORERRORCODE -3010
SQLSTATE 07002
Resources:
* Check the ColdFusion documentation to verify that you are using the
correct syntax.
* Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.11)
Gecko/20071127 Firefox/2.0.0.11
CODE SOURCE:
PROCESS BEGINS IN (application.cfm) WHEN USER ENTERS SECTION OF SITE REQUIRING
A LOGIN:
(application.cfm)
<!---If user is not logged in force them to log in--->
<cfif NOT isDefined("SESSION.Auth.IsLoggedIn")>
<!---If the user is now submitting login action via login form--->
<!---Include "Login Check" code to validate the user attempting to log
in.--->
<cfinclude template="../Templates/loginForm.cfm">
<cfabort>
</cfif>
NEXT THE USER IS PROMPTED TO THE LOGIN PAGE:
<cfif isDefined("form.UserLogin")>
<cfinclude template="loginCheck.cfm">
</cfif>
<span class="Header">Enter Access Code</span>
<br>
<cfform action="../PrivateAccess/showAR.cfm" Name="LoginForm" method="post">
<input type="hidden" name="UserLogin_required">
<input type="hidden" name="Password_required">
<!---userLogin Field is required--->
User Name:
<cfinput
type="text"
name="UserLogin"
size="20"
value=""
maxlength="24"
required="yes"
message="Please enter your user name. Thank you."
style="height:14px; width:125px; font-size:12px; font-weight:bold;
color: maroon; letter-spacing:0.2em; text-align:left;">
<p> </p><p> </p>
Password:
<cfinput
type="password"
name="Password"
size="24" value=""
maxlength="24"
required="yes"
message="Please enter your assigned password to access this part of the
site. Thank you."
style="height:14px; width:125px; font-size:12px; font-weight:bold;
color: maroon; letter-spacing:0.2em; text-align:left">
<cfinput type="submit" name="Enter">
</cfform>
WHICH IS CHECKED BY THE FOLLOWING CODE:
<!---The following code queries the database to find the record of the user's
password.--->
<cfparam name="Form.UserLogin" type="string">
<cfparam name="Form.Password" type="string">
<cfquery name="getUser" datasource="#dsn#">
SELECT *
FROM Users
WHERE UserLogin = '#Form.UserLogin#' AND Password = '#Form.Password#'
</cfquery>
<!---
If the user's password is correct the following code verifies
it and obtains the information then creates a distinct session for each
user
that logs in.
--->
<cfif getUser.RecordCount EQ 1>
<cflocation url="../PrivateAccess/showAR.cfm">
<!---
The following code remembers the user's "logged-in" status
their user type and their first name in the session structure.
--->
<cfset SESSION.Auth = StructNew()>
<cfset SESSION.Auth.IsLoggedIn = "yes">
<cfset SESSION.Auth.userID = getUser.userID>
<cfset SESSION.Auth.FirstName = getUser.FirstName>
<!---
Now that user is logged in, the following code sends them to
PrivateAccess/showAR.cfm page and menu links.
--->
<cflocation url="#CGI.SCRIPT_NAME#">
</cfif>
AS YOU CAN SEE THE QUERY "IS" PULLING THE DATA FROM THE DATABASE, BUT THROWING
THIS ERROR MESSAGE. I TURNED ON DEBUGGING BUT THIS DID NOT REVEAL ANYTHING MORE
THAN THE ORIGINAL ERROR MESSAGE. USING DREAMWEAVER 8 AND CFMX SERVERS. IF
ANYONE CAN EXPLAIN THIS I SURE WOULD APPRECIATE IT.
NICK
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297154
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
