Nick, YOUR CAPS LOCK IS STUCK. Just a heads up. Jerry Guido Programmer MGT of America, Inc. [EMAIL PROTECTED]
The information contained in this electronic communication is intended only for the use of the addressee, and may be a confidential communication. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. -----Original Message----- From: Nick Ross [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 23, 2008 12:36 PM To: CF-Talk Subject: Re: CF MX8: This is driving me nuts!!! 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:297167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
