Search Results
P R O J E C T S   A N D   B U I L D I N G S
Projects / Buildings
AMERICAN ARCHITECTS AND BUILDINGS
SEARCH
OUR PARTNERS

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

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.208.126.232
Referrer  
Date/Time   15-Aug-22 09:12 PM
Stack Trace
at cfsearch_by_name2ecfm1207739668._factor19(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1344) at cfsearch_by_name2ecfm1207739668._factor46(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1039) at cfsearch_by_name2ecfm1207739668._factor60(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._factor46(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1039) at cfsearch_by_name2ecfm1207739668._factor60(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._factor46(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1039)
	at cfsearch_by_name2ecfm1207739668._factor60(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)