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 ') ORDER BY (CASE idx_res.status WHEN 'S' THEN 'CloseP' at line 11
 
The error occurred in C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1128
Called from C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1104
Called from C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 48
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 46
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 1
Called from C:/Websites/BigGarageHomes/application.cfc: line 427
Called from C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1128
Called from C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1104
Called from C:/Websites/BigGarageHomes/inc/property-display.inc.cfm: line 1
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 48
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 46
Called from C:/Websites/BigGarageHomes/property-display.cfm: line 1
Called from C:/Websites/BigGarageHomes/application.cfc: line 427
1126 :     LEFT JOIN favorite ON idx_res.Matrix_Unique_ID = favorite.listing_num AND #SESSION.con_id# = favorite.contact_id
1127 :     </cfif>
1128 :     WHERE	#PreserveSingleQuotes(SelectListingSelection.where_clause)#
1129 :     ORDER BY      
1130 :     (CASE idx_res.status

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    SELECT idx_res.*,cast(ListPrice AS UNSIGNED) AS intPrice,c.city as city_name, county.name AS c_name, basement.*, basement.name AS b_name, style.name AS st_name, associate.display_name AS display_name, associate.first_name AS first_name, associate.last_name AS last_name, associate.team_phone AS team_phone, associate.office_phone_direct AS office_phone_direct, associate.office_phone_direct_dsp AS office_phone_direct_dsp, associate.toll_free_phone AS toll_free_phone, associate.toll_free_phone_dsp AS toll_free_phone_dsp, associate.home_office_phone AS home_office_phone, associate.home_office_phone_dsp AS home_office_phone_dsp, associate.mobile_phone AS mobile_phone, associate.mobile_phone_dsp AS mobile_phone_dsp, favorite.contact_id AS con_id FROM idx_res LEFT JOIN city c ON idx_res.city = c.id LEFT JOIN associate ON idx_res.ListAgentMLSID = associate.agent_id LEFT JOIN county ON idx_res.CountyOrParish = county.code LEFT JOIN basement ON idx_res.BasementSize = basement.code LEFT JOIN style ON idx_res.StructuralStyle = style.code LEFT JOIN favorite ON idx_res.Matrix_Unique_ID = favorite.listing_num AND 0 = favorite.contact_id WHERE idx_res.PropertyType = 'RES' AND CountyOrParish IN ('32') AND idx_res.PropertySubType LIKE '%DETSF%' AND (exists(select Listing_MUI from idx_parking where ParkingSpacesNumberOf >= '3' and ParkingType = 'GA' AND Listing_MUI = idx_res.Matrix_Unique_ID) OR exists(select Listing_MUI from idx_parking where ParkingSpacesNumberOf >= '3' and ParkingType = 'GD' AND idx_parking.Listing_MUI = idx_res.Matrix_Unique_ID)) AND yearbuilt <= 2010 AND ( idx_res.status = 'A' ) AND ( ) ORDER BY (CASE idx_res.status WHEN 'S' THEN 'ClosePrice' ELSE 'intPrice' END)
DATASOURCE   biggaragehomes
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   23.22.17.192
Referrer  
Date/Time   27-May-15 01:34 AM
Stack Trace
at cfproperty2ddisplay2einc2ecfm1867486389._factor39(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1128) at cfproperty2ddisplay2einc2ecfm1867486389._factor78(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1104) at cfproperty2ddisplay2einc2ecfm1867486389.runPage(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1) at cfproperty2ddisplay2ecfm105678695._factor1(C:/Websites/BigGarageHomes/property-display.cfm:48) at cfproperty2ddisplay2ecfm105678695._factor31(C:/Websites/BigGarageHomes/property-display.cfm:46) at cfproperty2ddisplay2ecfm105678695.runPage(C:/Websites/BigGarageHomes/property-display.cfm:1) at cfapplication2ecfc1543169404$funcONREQUEST.runFunction(C:/Websites/BigGarageHomes/application.cfc:427) at cfproperty2ddisplay2einc2ecfm1867486389._factor39(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1128) at cfproperty2ddisplay2einc2ecfm1867486389._factor78(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1104) at cfproperty2ddisplay2einc2ecfm1867486389.runPage(C:/Websites/BigGarageHomes/inc/property-display.inc.cfm:1) at cfproperty2ddisplay2ecfm105678695._factor1(C:/Websites/BigGarageHomes/property-display.cfm:48) at cfproperty2ddisplay2ecfm105678695._factor31(C:/Websites/BigGarageHomes/property-display.cfm:46) at cfproperty2ddisplay2ecfm105678695.runPage(C:/Websites/BigGarageHomes/property-display.cfm:1) at cfapplication2ecfc1543169404$funcONREQUEST.runFunction(C:/Websites/BigGarageHomes/application.cfc:427)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ') 
    ORDER BY      
    (CASE idx_res.status
        WHEN 'S' THEN  'CloseP' at line 11
	at sun.reflect.GeneratedConstructorAccessor311.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:922)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1442)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1056)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:685)
	at cfproperty2ddisplay2einc2ecfm1867486389._factor39(C:\Websites\BigGarageHomes\inc\property-display.inc.cfm:1128)
	at cfproperty2ddisplay2einc2ecfm1867486389._factor78(C:\Websites\BigGarageHomes\inc\property-display.inc.cfm:1104)
	at cfproperty2ddisplay2einc2ecfm1867486389.runPage(C:\Websites\BigGarageHomes\inc\property-display.inc.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfproperty2ddisplay2ecfm105678695._factor1(C:\Websites\BigGarageHomes\property-display.cfm:48)
	at cfproperty2ddisplay2ecfm105678695._factor31(C:\Websites\BigGarageHomes\property-display.cfm:46)
	at cfproperty2ddisplay2ecfm105678695.runPage(C:\Websites\BigGarageHomes\property-display.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfapplication2ecfc1543169404$funcONREQUEST.runFunction(C:\Websites\BigGarageHomes\application.cfc:427)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:300)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:424)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	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:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)