01.22.08 9:44 AM
THANKS EVERYONE. YES, I FOUND THE SINGLE QUOTE BUT IT MADE NOT DIFFERENCE. NOW
I AM GETTING THIS ERROR MESSAGE:
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 :
Previous message_____________________________________________________
> 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\Templates\loginCheck.
> cfm:19) at cfloginForm2ecfm2102964576.
> runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginForm.
> cfm:206) at cfApplication2ecfm232572268.
> runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\PrivateAccess\Application.
> cfm:21) at cfloginCheck2ecfm627279261.
> runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\loginCheck.
> cfm:19) at cfloginForm2ecfm2102964576.
> runPage(C:\Inetpub\wwwroot\RickRossiter\NLR\Templates\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\Templates\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\Templates\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(ClientScopePersistenceFilter.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.java: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.java:318)
> at jrunx.scheduler.ThreadPool$ThreadThrottle.
> invokeRunnable(ThreadPool.java:426)
> at jrunx.scheduler.ThreadPool$UpstreamMetrics.
> invokeRunnable(ThreadPool.java: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:297151
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
