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]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
 
The error occurred in D:/web-data/hegibau.ch/http/index.cfm: line 337
Called from D:/web-data/hegibau.ch/http/index.cfm: line 296
Called from D:/web-data/hegibau.ch/http/index.cfm: line 265
Called from D:/web-data/hegibau.ch/http/index.cfm: line 204
Called from D:/web-data/hegibau.ch/http/index.cfm: line 1
Called from D:/web-data/hegibau.ch/http/pages/mod/400.cfm: line 70
Called from D:/web-data/hegibau.ch/http/index.cfm: line 337
Called from D:/web-data/hegibau.ch/http/index.cfm: line 296
Called from D:/web-data/hegibau.ch/http/index.cfm: line 265
Called from D:/web-data/hegibau.ch/http/index.cfm: line 204
Called from D:/web-data/hegibau.ch/http/index.cfm: line 1
Called from D:/web-data/hegibau.ch/http/pages/mod/400.cfm: line 70
335 : 											<cfif f neq "alle" and f neq "offen">
336 : 												AND medsummary = '#f#'
337 : 											<cfelseif f neq "alle" and f eq "offen">
338 : 												AND NOT medsummary IN ('verkauft','reserviert','vermietet')
339 : 											</cfif>

VENDORERRORCODE   306
SQLSTATE   HY000
SQL    SELECT * FROM tMedia WHERE medmdcid = 9 AND medstatus <> 99 AND medactiveyn <> 0 AND medsummary = 'reserviert' ORDER BY medsortnr ASC
DATASOURCE   hegibau_cms_cms_sql
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.196.5.6
Referrer  
Date/Time   16-Aug-18 08:41 PM
Stack Trace
at cfindex2ecfm2092738825._factor1(D:/web-data/hegibau.ch/http/index.cfm:337) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:296) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:265) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:204) at cfindex2ecfm2092738825.runPage(D:/web-data/hegibau.ch/http/index.cfm:1) at cf4002ecfm1867555654.runPage(D:/web-data/hegibau.ch/http/pages/mod/400.cfm:70) at cfindex2ecfm2092738825._factor1(D:/web-data/hegibau.ch/http/index.cfm:337) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:296) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:265) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:204) at cfindex2ecfm2092738825.runPage(D:/web-data/hegibau.ch/http/index.cfm:1) at cf4002ecfm1867555654.runPage(D:/web-data/hegibau.ch/http/pages/mod/400.cfm:70)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
	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:1451)
	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:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfindex2ecfm2092738825._factor1(D:\web-data\hegibau.ch\http\index.cfm:337)
	at cfindex2ecfm2092738825._factor2(D:\web-data\hegibau.ch\http\index.cfm:296)
	at cfindex2ecfm2092738825._factor4(D:\web-data\hegibau.ch\http\index.cfm:265)
	at cfindex2ecfm2092738825._factor5(D:\web-data\hegibau.ch\http\index.cfm:204)
	at cfindex2ecfm2092738825.runPage(D:\web-data\hegibau.ch\http\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cf4002ecfm1867555654.runPage(D:\web-data\hegibau.ch\http\pages\mod\400.cfm:70)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	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: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:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	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:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:722)