Looks to me like you have an extra quote/apostrophe here (after
getUser.Password):
<cfquery name="getUser" datasource="#dsn#">
SELECT *
FROM Users
WHERE (getUser.UserLogin = '#Form.UserLogin#')
AND (getUser.Password' = '#Form.Password#') </cfquery>
-----Original Message-----
From: Nick Ross [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 12:04 PM
To: CF-Talk
Subject: CF MX8: This is driving me nuts!!!
Syntax error (missing operator) in query expression '(getUser.UserLogin
= 'paulw') AND (getUser.Password' = '2324986')'.
Getting this error message on a simple login application. App starts in
the application.cfm as soon as the user enters the section of site that
requires login.
<!---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>
Here is 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>
Here is the final part...the loginCheck.cfm page.
<!---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 (getUser.UserLogin = '#Form.UserLogin#')
AND (getUser.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>
I have looked over this code so much and searched the net for an
explanation of why I am getting this error. Oh, and both the fields in
the query are "text" fields; no numerical fields. Someone, PLEASE tell
me what you think is going on. Thanks in advance for any help.
Nick
[EMAIL PROTECTED]
Below is the entire error message:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Syntax error (missing operator) in query
expression '(getUser.UserLogin = 'paulw') AND (getUser.Password' =
'2324986')'.
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
21
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
21
17 : SELECT *
18 : FROM Users
19 : WHERE (getUser.UserLogin = '#Form.UserLogin#') AND
(getUser.Password' = '#Form.Password#')
20 : </cfquery>
21 :
SQL SELECT * FROM Users WHERE (getUser.UserLogin = 'paulw') AND
(getUser.Password' = '2324986')
DATASOURCE RickRossiter
VENDORERRORCODE -3100
SQLSTATE 42000
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
Remote Address 76.216.61.225
Referrer https://usnexus.com/NLRSSL/NLR/PrivateAccess/showAR.cfm
Date/Time 23-Jan-08 08:53 AM
Stack Trace
at
cfloginCheck2ecfm627279261.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginCheck.cfm:19) at
cfloginForm2ecfm2102964576.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginForm.cfm:206) at
cfApplication2ecfm232572268.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\
PrivateAccess\Application.cfm:21) at
cfloginCheck2ecfm627279261.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginCheck.cfm:19) at
cfloginForm2ecfm2102964576.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginForm.cfm:206) at
cfApplication2ecfm232572268.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\
PrivateAccess\Application.cfm:21)
java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression '(getUser.UserLogin = 'paulw') AND
(getUser.Password' = '2324986')'.
at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown
Source)
at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown
Source)
at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
at macromedia.sequelink.ssp.Chain.send(Unknown Source)
at
macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown
Source)
at
macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source)
at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown
Source)
at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown
Source)
at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
at
coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at
cfloginCheck2ecfm627279261.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginCheck.cfm:19)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at
cfloginForm2ecfm2102964576.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\T
emplates\loginForm.cfm:206)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at
cfApplication2ecfm232572268.runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\
PrivateAccess\Application.cfm:21)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at
coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at
coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:33)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:172)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:
51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist
enceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.jav
a:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257
)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541
)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:
204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j
ava:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java
:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav
a:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:297147
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
