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 1344
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1039
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 1344
Called from d:/inetpub/wwwroot/pab/app/search_by_name.cfm: line 1039
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
|
1342 : <cfelseif LCase(HO_GRID_SortBy) EQ "clientname">
1343 : ORDER BY H.ClientName ASC, H.ProjectName ASC
1344 : <cfelse>
1345 : ORDER BY H.ProjectName ASC, H.ClientName ASC
1346 : </cfif>
|
|
SQLSTATE |
HY000 |
DATASOURCE |
pab-sql |
VENDORERRORCODE |
102 |
SQL |
SELECT H.RecordId, H.ProjectName, H.ClientName, H.Quantity, H.LocalCall,
H.StartYear, H.EndYear, R.ApprovalStatusCode, I.InstitutionName, I.Department,
C.CollectionName, R.ShortId, H.PrivateComments, RR.ApprovalStatusCode AS CollectionASC
FROM Holdings H
INNER JOIN Records R ON H.RecordId = R.RecordId
INNER JOIN Collections C ON H.CollectionId = C.RecordId
INNER JOIN Institutions I ON C.InstitutionId = I.RecordId
INNER JOIN Records RR ON C.RecordId = RR.RecordId
WHERE 1 = 1
AND NOT EXISTS (SELECT HoldingId FROM HoldingProjectLinks WHERE HoldingId = H.RecordId)
AND R.RecordId IN (SELECT RecordId FROM Locations
WHERE
)
AND R.ApprovalStatusCode NOT IN ('P', 'O')
AND RR.ApprovalStatusCode NOT IN ('P', 'O')
ORDER BY H.ProjectName ASC, H.ClientName ASC
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
18.97.9.170 |
Referrer |
|
Date/Time |
08-Feb-25 08:58 AM |
|
Stack Trace
|
at cfsearch_by_name2ecfm1207739668._factor19(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1344) at cfsearch_by_name2ecfm1207739668._factor47(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1039) 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._factor19(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1344) at cfsearch_by_name2ecfm1207739668._factor47(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1039) 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.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.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1537)
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._factor19(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1344)
at cfsearch_by_name2ecfm1207739668._factor47(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1039)
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)
|
|