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 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 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 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.208.126.232
Referrer  
Date/Time   15-Aug-22 08:23 PM
Stack Trace
at cfsearch_by_name2ecfm1207739668._factor34(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1549) at cfsearch_by_name2ecfm1207739668._factor60(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1547) 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._factor60(d:/inetpub/wwwroot/pab/app/search_by_name.cfm:1547) 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._factor60(d:\inetpub\wwwroot\pab\app\search_by_name.cfm:1547)
	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)