> 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]
Hello Nick,
It's possible that you are having a problem with the column name being
Users. I recall a similar problem in our Support queue. The column name was
identical to a DBMS reserved word. The user rectified the problem by placing
the column name in square brackets, i.e., []. This remedy was specific to a
Progress DBMS. If the same problem obtains in your environment, you may need to
employ different escape characters other than the square brackets, but I would
start there.
Best regards,
Netrista Khatam
Technical Services Manager
OpenLink Product Support
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:297433
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
