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 350
Called from D:/web-data/hegibau.ch/http/index.cfm: line 309
Called from D:/web-data/hegibau.ch/http/index.cfm: line 278
Called from D:/web-data/hegibau.ch/http/index.cfm: line 217
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 350
Called from D:/web-data/hegibau.ch/http/index.cfm: line 309
Called from D:/web-data/hegibau.ch/http/index.cfm: line 278
Called from D:/web-data/hegibau.ch/http/index.cfm: line 217
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
 
348 : 											<cfif f neq "alle" and f neq "offen">
349 : 												AND medsummary = '#f#'
350 : 											<cfelseif f neq "alle" and f eq "offen">
351 : 												AND NOT medsummary IN ('verkauft','reserviert','vermietet')
352 : 											</cfif>
VENDORERRORCODE   306
SQLSTATE   HY000
SQL    SELECT * FROM tMedia WHERE medmdcid = 150 AND medstatus <> 99 AND medactiveyn <> 0 AND medsummary = 'vermietet' ORDER BY medsortnr ASC
DATASOURCE   hegibau_cms_cms_sql
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   34.237.124.210
Referrer  
Date/Time   24-Feb-21 06:36 PM
Stack Trace
at cfindex2ecfm2092738825._factor1(D:/web-data/hegibau.ch/http/index.cfm:350) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:309) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:278) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:217) 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:350) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:309) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:278) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:217) 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:350)
	at cfindex2ecfm2092738825._factor2(D:\web-data\hegibau.ch\http\index.cfm:309)
	at cfindex2ecfm2092738825._factor4(D:\web-data\hegibau.ch\http\index.cfm:278)
	at cfindex2ecfm2092738825._factor5(D:\web-data\hegibau.ch\http\index.cfm:217)
	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)