Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| |
The error occurred in d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1549
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1547
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 596
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1549
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1547
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 596
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1
|
1547 : <cfif RecordType EQ "pr" or RecordType EQ "all">
1548 :
1549 : <cfquery name="Citations" datasource="#Request.dbdsn#">
1550 : SELECT C.RecordId, C.ProjectTypeComments, C.ActivityComments,
1551 : C.ClientName, C.Comments, C.AltsAdds, C.BuildingName, RS.ShortTitle,
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
pab-sql |
| VENDORERRORCODE |
102 |
| SQL |
SELECT C.RecordId, C.ProjectTypeComments, C.ActivityComments,
C.ClientName, C.Comments, C.AltsAdds, C.BuildingName, RS.ShortTitle,
C.BiographicalInfo, C.MembershipOrgId, C.MembershipTypeId, C.PositionId,
C.RefYear, C.RefMonth, C.RefDay, R.ApprovalStatusCode,
C.RefVolume, C.RefNumber, C.RefPage,
C.RefYear2, C.RefMonth2, C.RefDay2, R.ShortId
FROM Citations C
, RefSources RS, Records R
WHERE R.RecordId = C.RecordId
AND R.RecordType = (param 1)
AND RS.RefSourceId = C.RefSourceId
AND NOT EXISTS (SELECT CitationId
FROM CitationLinks WHERE CitationId = C.RecordId)
AND R.RecordId IN (SELECT RecordId FROM Locations
WHERE
)
AND NOT (R.ApprovalStatusCode = 'P' or R.ApprovalStatusCode = 'O')
ORDER BY C.BuildingName ASC, C.ClientName ASC
|
|
|
Resources:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
18.97.9.170 |
| Referrer |
|
| Date/Time |
08-Feb-25 08:54 AM |
|
|
Stack Trace
|
at cfsearch_by_name2ecfm1207739668._factor34(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1549) at cfsearch_by_name2ecfm1207739668._factor48(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1547) at cfsearch_by_name2ecfm1207739668._factor62(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:596) at cfsearch_by_name2ecfm1207739668.runPage(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1)
at cfsearch_by_name2ecfm1207739668._factor34(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1549) at cfsearch_by_name2ecfm1207739668._factor48(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1547) at cfsearch_by_name2ecfm1207739668._factor62(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:596) at cfsearch_by_name2ecfm1207739668.runPage(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfsearch_by_name2ecfm1207739668._factor34(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1549)
at cfsearch_by_name2ecfm1207739668._factor48(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1547)
at cfsearch_by_name2ecfm1207739668._factor62(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:596)
at cfsearch_by_name2ecfm1207739668.runPage(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
|
|
