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.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pagetype= 'Neighborhood'' at line 1
 
The error occurred in C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 36
Called from C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 36
 
5 : </CFQUERY>
6 : <cfquery name="Getfiles" datasource="REOL_files">
7 :  select FileName,FileTitle from CommunityFiles where memberID = 1000#BrokersSiteID# AND pageid = #pageinfo.pageid# AND pagetype= 'Neighborhood'
8 : </cfquery>
9 : <cfquery name="Getphotos" datasource="REOL_files">
SQL    select FileName,FileTitle from CommunityFiles where memberID = 10001 AND pageid = AND pagetype= 'Neighborhood'
DATASOURCE   REOL_files
VENDORERRORCODE   1064
SQLSTATE   42000
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.21.162.87
Referrer  
Date/Time   27-Apr-24 11:42 AM
Stack Trace
at cfneighborhoods2ecfm103056964.runPage(C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm:7) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:36) at cfneighborhoods2ecfm103056964.runPage(C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm:7) at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:36) 

java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pagetype= 'Neighborhood'' at line 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
	at com.mysql.jdbc.Statement.execute(Statement.java:535)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:719)
	at coldfusion.sql.Executive.executeQuery(Executive.java:652)
	at coldfusion.sql.Executive.executeQuery(Executive.java:613)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
	at cfneighborhoods2ecfm103056964.runPage(C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm:7)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cfquery_redirect2ecfm887604138.runPage(C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm:36)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)