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 keyword 'THEN'.
 
The error occurred in C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1874
Called from C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1728
Called from C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1874
Called from C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1728
Called from C:/home/ilovecomm.com/wwwroot/_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
 
1872 : 			AND offers.keyword_pnt is not null
1873 : 			AND offers.detail <> ''
1874 : 			AND offers.idoffer <> #get_offer.idoffer#
1875 : 			ORDER BY categoryokp DESC, coluorsok DESC, brandprefok DESC  
1876 : 		</cfquery>
SQLSTATE   HY000
DATASOURCE   ilovecomm
VENDORERRORCODE   156
SQL    SELECT top 8 offers.idoffer, offers.offer, offers.prixoffer, offers.discountoffer, offers.dateend, urls.url1 AS urlsingleoffer,offers.brandpnt, CASE WHEN offers.brandpnt = THEN 1 ELSE 0 END AS brandprefok, CASE WHEN (SELECT top 1 colour FROM offers_colours WHERE offerpnt = offers.idoffer) = '0' THEN 1 ELSE 0 END AS coluorsok, CASE WHEN (SELECT TOP 1 visualshoppingpnt FROM visualshoppingtags WHERE offers.idoffer = visualshoppingtags.offerpnt ORDER BY dateadd DESC) is null THEN 0 ELSE 1 END AS visualKO, CASE WHEN offers.keyword_pnt =0 THEN 1 ELSE 0 END AS categoryokp FROM offers INNER JOIN urls ON offers.urlpnt = urls.idurl WHERE offers.enable <> 0 AND ( offers.shoppnt = 1231 or offers.shoppnt = 0) AND offers.keyword_pnt is not null AND offers.detail <> '' AND offers.idoffer <> 8697 ORDER BY categoryokp DESC, coluorsok DESC, brandprefok DESC
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.143
Referrer  
Date/Time   28-Aug-25 01:33 PM
Stack Trace
at cf_products2ecfm879309868._factor49(C:/home/ilovecomm.com/wwwroot/_products.cfm:1874) at cf_products2ecfm879309868._factor54(C:/home/ilovecomm.com/wwwroot/_products.cfm:1728) at cf_products2ecfm879309868.runPage(C:/home/ilovecomm.com/wwwroot/_products.cfm:1) at cfindex2ecfm846459967._factor13(C:/home/ilovecomm.com/wwwroot/index.cfm:600) at cfindex2ecfm846459967.runPage(C:/home/ilovecomm.com/wwwroot/index.cfm:1) at cf_products2ecfm879309868._factor49(C:/home/ilovecomm.com/wwwroot/_products.cfm:1874) at cf_products2ecfm879309868._factor54(C:/home/ilovecomm.com/wwwroot/_products.cfm:1728) at cf_products2ecfm879309868.runPage(C:/home/ilovecomm.com/wwwroot/_products.cfm:1) at cfindex2ecfm846459967._factor13(C:/home/ilovecomm.com/wwwroot/index.cfm:600) at cfindex2ecfm846459967.runPage(C:/home/ilovecomm.com/wwwroot/index.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'THEN'.
	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.ddm.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.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cf_products2ecfm879309868._factor49(C:\home\ilovecomm.com\wwwroot\_products.cfm:1874)
	at cf_products2ecfm879309868._factor54(C:\home\ilovecomm.com\wwwroot\_products.cfm:1728)
	at cf_products2ecfm879309868.runPage(C:\home\ilovecomm.com\wwwroot\_products.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286)
	at cfindex2ecfm846459967._factor13(C:\home\ilovecomm.com\wwwroot\index.cfm:600)
	at cfindex2ecfm846459967.runPage(C:\home\ilovecomm.com\wwwroot\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:597)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	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:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	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:53)
	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:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)