FR | EN

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]'trim' is not a recognized built-in function name.
 
The error occurred in D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 823
Called from D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 24
Called from D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 1
Called from D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 823
Called from D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 24
Called from D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm: line 1
821 :     <cfquery name="qGetVirtualTours">
822 :         Select * from v_Showcases<cfif session.prefix neq "">ByRegion</cfif>
823 :         where active = 1 and clientactive = 1 and categoryActive = 1 <cfif session.prefix neq ""> and siteprefix = <cfqueryparam cfsqltype="cf_sql_varchar" value="#session.prefix#"></cfif>
824 :         and trim(embed) <> ''
825 :     </cfquery>

SQLSTATE   HY000
DATASOURCE   gaspesievirtuelle
VENDORERRORCODE   195
SQL    Select * from v_Showcases where active = 1 and clientactive = 1 and categoryActive = 1 and trim(embed) <> ''
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.226.73.255
Referrer  
Date/Time   21-Apr-19 12:28 PM
Stack Trace
at cfindex2ecfm759973498._factor15(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:823) at cfindex2ecfm759973498._factor16(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:24) at cfindex2ecfm759973498.runPage(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:1) at cfindex2ecfm759973498._factor15(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:823) at cfindex2ecfm759973498._factor16(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:24) at cfindex2ecfm759973498.runPage(D:/ColdFusion11/cfusion/wwwroot/gaspesievirtuelle/index.cfm:1)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]'trim' is not a recognized built-in function name.
	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.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.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:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfindex2ecfm759973498._factor15(D:\ColdFusion11\cfusion\wwwroot\gaspesievirtuelle\index.cfm:823)
	at cfindex2ecfm759973498._factor16(D:\ColdFusion11\cfusion\wwwroot\gaspesievirtuelle\index.cfm:24)
	at cfindex2ecfm759973498.runPage(D:\ColdFusion11\cfusion\wwwroot\gaspesievirtuelle\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:474)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	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:58)
	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:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:459)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)