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]Sintaxis incorrecta cerca de ')'.
 
The error occurred in C:/autoenred/bu_details.cfm: line 241
Called from C:/autoenred/bu_details.cfm: line 25
Called from C:/autoenred/bu_details.cfm: line 1
Called from C:/autoenred/bu_details.cfm: line 241
Called from C:/autoenred/bu_details.cfm: line 25
Called from C:/autoenred/bu_details.cfm: line 1
239 : 	--AND i.PrecioDeVenta >= #AP.ap#
240 : 	<cfif hidden_empresas NEQ ""> 
241 : 		AND (i.IDconcesionario NOT IN(#hidden_empresas#))
242 : 	</cfif> 
243 : 	AND (i.Aff_gestion is null or i.Aff_gestion = 0)

VENDORERRORCODE   102
SQLSTATE   HY000
SQL    --1 SELECT i.*, REPLACE(REPLACE(EquipamientoComentarios, char(13), '<br/> '), CHAR(10),'<br/> ') as EquipamientoComentariosM,d.denominacion as 'denDenomin', d.puertas, p.provincia, c.localidad as 'c_localidad', c.codigo_postal as 'c_codigo_postal', m.mes as 'mes', ma.marca, mo.modelo, ca.Carroceria, cm.combustible, cp.ColorPintura, po.PinturaOpciones, es.Estgeneral, ne.Neumaticos, de.Desperfectos, re.Revisiones, ga.Garantia, c.nombre_comercial, c.sitio_internet, c.vendedor, c.tel1_ventas, c.tel2_ventas, c.email_clientes,vi.av_v,vi.ac_c,vi.av,vi.ac,vi.av_vadj, vi.ac_cadj,vi.avadj,vi.acadj,afv,vii.pv,vii.preciobase,vii.pvadj,vii.pc,vii.pv , (year(i.fecha) - i.year) as diffyear FROM Inventario i -- INNER JOIN vi_historic vii ON i.idanuncio = vii.idanuncio -- INNER JOIN vi_historic_cal vi ON i.idanuncio = vi.idanuncio LEFT OUTER JOIN vi_historic vii ON i.idanuncio = vii.idanuncio LEFT OUTER JOIN vi_historic_cal vi ON i.idanuncio = vi.idanuncio INNER JOIN Provincias p ON i.IDProvincia = p.IDprovincia INNER JOIN marcas ma ON i.IDmarca = ma.idMarca INNER JOIN Carrocerias ca ON i.IDcarroceria = ca.IDcarroceria INNER JOIN Combustibles cm ON i.IDcombustible = cm.IDcombustible LEFT OUTER JOIN modelos mo ON i.IDmodelo = mo.idModelo LEFT OUTER JOIN ColorPintura cp ON i.IDColorPintura = cp.IDColorPintura LEFT OUTER JOIN PinturaOpciones po ON i.IDPinturaOpciones = po.IDPinturaOpciones LEFT OUTER JOIN Estgeneral es ON i.IDEstgeneral = es.IDEstgeneral LEFT OUTER JOIN Neumaticos ne ON i.IDNeumaticos = ne.IDNeumaticos LEFT OUTER JOIN Desperfectos de ON i.IDDesperfectos = de.IDDesperfectos LEFT OUTER JOIN Revisiones re ON i.IDRevisiones = re.IDRevisiones LEFT OUTER JOIN Garantia ga ON i.IDGarantia = ga.IDGarantia LEFT OUTER JOIN Denominaciones d ON i.IDdenominacion = d.IDdenominacion LEFT OUTER JOIN Concesionarios c ON i.IDconcesionario = c.IDconcesionario LEFT OUTER JOIN Meses m ON m.IDmes = i.idMes WHERE (i.IDanuncio = ) AND (Oculto = 0) --AND i.PrecioDeVenta >= 100 AND (i.Aff_gestion is null or i.Aff_gestion = 0)
DATASOURCE   autoenred
Resources:

Browser   claudebot
Remote Address   44.192.53.34
Referrer   http://autoenred.aubensa.cloudfabric.net/forward2bu06.cfm?anuncioNum=371987
Date/Time   28-Mar-24 12:52 PM
Stack Trace
at cfbu_details2ecfm1198391691._factor9(C:/autoenred/bu_details.cfm:241) at cfbu_details2ecfm1198391691._factor233(C:/autoenred/bu_details.cfm:25) at cfbu_details2ecfm1198391691.runPage(C:/autoenred/bu_details.cfm:1) at cfbu_details2ecfm1198391691._factor9(C:/autoenred/bu_details.cfm:241) at cfbu_details2ecfm1198391691._factor233(C:/autoenred/bu_details.cfm:25) at cfbu_details2ecfm1198391691.runPage(C:/autoenred/bu_details.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Sintaxis incorrecta cerca de ')'.
	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)
	at cfbu_details2ecfm1198391691._factor9(C:\autoenred\bu_details.cfm:241)
	at cfbu_details2ecfm1198391691._factor233(C:\autoenred\bu_details.cfm:25)
	at cfbu_details2ecfm1198391691.runPage(C:\autoenred\bu_details.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:204)
	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 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:203)
	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)