Did you try what I said? Here it is again in case it didn't send.
Try using this query (add square brackets around the database object names
and use CFQUERYPARAM!):
SELECT *
FROM [Users]
WHERE [UserLogin] = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Form.UserLogin#">
AND [Password] = <cfqueryparam cfsqltype="cf_sql_varchar"
value="#Form.Password#">
If that works then the reason is that one of the database object names
(column names, table names, etc) was the same as an Access function
name/reserved word or some-such.
Let me know how it goes.
Dominic
p.s. please don't use caps all the time, you may be in a foul mood (we've
all been there) - but don't take it out on us!
On 23/01/2008, Nick Ross <[EMAIL PROTECTED]> wrote:
>
> 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:297215
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
