Search problem.

 Whenever you do a search with at " ' " (single quote) the search throws an error.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 's'.



The error occurred in
esources_newmmorpgcomponentsforums.cfc: line 1589

Called from D:mmorpg_newqryqryForumSearch.cfm: line 13

Called from D:mmorpg_newinc_forum.cfm: line 700

Called from D:mmorpg_newinc_forum.cfm: line 680

Called from D:mmorpg_newinc_forum.cfm: line 1

Called from D:mmorpg_newdiscussion2.cfm: line 71

Called from
esources_newmmorpgcomponentsforums.cfc: line 1589

Called from D:mmorpg_newqryqryForumSearch.cfm: line 13

Called from D:mmorpg_newinc_forum.cfm: line 700

Called from D:mmorpg_newinc_forum.cfm: line 680

Called from D:mmorpg_newinc_forum.cfm: line 1

Called from D:mmorpg_newdiscussion2.cfm: line 71

1587 : <cfprocparam type="in" cfsqltype="CF_SQL_BIT" value="#isStaff#" null="false">

1588 : <cfprocparam type="in" cfsqltype="CF_SQL_INTEGER" value="#userId#" null="#Iif(Val(userId),0,1)#">

1589 : <cfprocresult name="result" resultset="1">

1590 : </cfstoredproc>

1591 : <cfelse>

SQLSTATE 42000

SQL {call usp_ForumSearch( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) )}

VENDORERRORCODE 170

DATASOURCE forums

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) AppleWebKit/525.19 (KHTML, like Gecko) Chrome/0.4.154.29 Safari/525.19

Remote Address 71.62.200.57

Referrer http://www.mmorpg.com/discussion2.cfm

Date/Time 01-Dec-08 10:16 PM

Stack Trace

at cfforums2ecfc191932469$funcGETFORUMSEARCH.runFunction(D:
esources_newmmorpgcomponentsforums.cfc:1589) at cfqryForumSearch2ecfm74308002.runPage(D:mmorpg_newqryqryForumSearch.cfm:13) at cfinc_forum2ecfm1663281199._factor25(D:mmorpg_newinc_forum.cfm:700) at cfinc_forum2ecfm1663281199._factor28(D:mmorpg_newinc_forum.cfm:680) at cfinc_forum2ecfm1663281199.runPage(D:mmorpg_newinc_forum.cfm:1) at cfdiscussion22ecfm1810119141.runPage(D:mmorpg_newdiscussion2.cfm:71) at cfforums2ecfc191932469$funcGETFORUMSEARCH.runFunction(D:
esources_newmmorpgcomponentsforums.cfc:1589) at cfqryForumSearch2ecfm74308002.runPage(D:mmorpg_newqryqryForumSearch.cfm:13) at cfinc_forum2ecfm1663281199._factor25(D:mmorpg_newinc_forum.cfm:700) at cfinc_forum2ecfm1663281199._factor28(D:mmorpg_newinc_forum.cfm:680) at cfinc_forum2ecfm1663281199.runPage(D:mmorpg_newinc_forum.cfm:1) at cfdiscussion22ecfm1810119141.runPage(D:mmorpg_newdiscussion2.cfm:71)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 7: Incorrect syntax near 's'.

at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)

at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)

at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at macromedia.jdbc.base.BaseStatement.getNextResultType(Unknown Source)

at macromedia.jdbc.base.BaseStatement.getMoreResults(Unknown Source)

at macromedia.jdbc.base.BaseStatement.getMoreResults(Unknown Source)

at macromedia.jdbc.base.BasePreparedStatementPoolable.getMoreResults(Unknown Source)

at coldfusion.server.j2ee.sql.JRunStatement.getMoreResults(JRunStatement.java:282)

at coldfusion.sql.Executive.getRowSets(Executive.java:614)

at coldfusion.sql.Executive.executeCall(Executive.java:860)

at coldfusion.sql.Executive.executeCall(Executive.java:775)

at coldfusion.sql.Executive.executeCall(Executive.java:726)

at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:445)

at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:276)

at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:225)

at cfforums2ecfc191932469$funcGETFORUMSEARCH.runFunction(D:
esources_newmmorpgcomponentsforums.cfc:1589)

at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)

at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)

at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)

at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)

at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)

at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)

at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)

at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)

at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)

at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)

at cfqryForumSearch2ecfm74308002.runPage(D:mmorpg_newqryqryForumSearch.cfm:13)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)

at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)

at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)

at cfinc_forum2ecfm1663281199._factor25(D:mmorpg_newinc_forum.cfm:700)

at cfinc_forum2ecfm1663281199._factor28(D:mmorpg_newinc_forum.cfm:680)

at cfinc_forum2ecfm1663281199.runPage(D:mmorpg_newinc_forum.cfm:1)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)

at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)

at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2661)

at cfdiscussion22ecfm1810119141.runPage(D:mmorpg_newdiscussion2.cfm:71)

at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)

at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)

at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)

at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)

at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)

at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)

at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)

at coldfusion.CfmServlet.service(CfmServlet.java:175)

at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)

at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)

at jrun.servlet.FilterChain.service(FilterChain.java:101)

at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)

at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)

at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)

at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)

at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)

at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)

at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)

at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)

at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)