|
|
|
For sale
|
|
For rent
|
|
Find
|
|
My searches
|
|
Property for sale
|
|
Property for rent
|
|
Holiday rental
|
|
 |
An error occured
22/05/2013 01:49:14
172.16.0.125
SELECT count(idbien) as countidbien
FROM bien_iw
WHERE codeclient in () and codestatus = '1' and ventelocation = '2' and (typelocation ='V' and typelocation is not null)
and (bien_iw.vendu <> 'Y' or bien_iw.vendu is null)
and codecategorie < 10
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
The error occurred on line 281. in /reroute.cfm
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:736)
at cfResGrp2ecfm746524206._factor20(\\dcr.intra\internet\Sites\Immoweb\Scripts\En\ResGrp.cfm:281)
at cfResGrp2ecfm746524206.runPage(\\dcr.intra\internet\Sites\Immoweb\Scripts\En\ResGrp.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 cfGlobal2eResGrp2ecfm820341020.runPage(\\dcr.intra\internet\Sites\Immoweb\Scripts\En\Global.ResGrp.cfm:11)
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 cfreroute2ecfm1359338703._factor40(\\dcr.intra\internet\Sites\Immoweb\Scripts\reroute.cfm:731)
at cfreroute2ecfm1359338703.runPage(\\dcr.intra\internet\Sites\Immoweb\Scripts\reroute.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
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.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.aurigma.imageuploaderflash.UploadFilter.doFilter(UploadFilter.java:36)
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.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(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddb9.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.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddel.execute(Unknown Source)
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)
... 50 more
|
|
