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

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   34.204.181.91
Referrer  
Date/Time   30-Sep-23 06:39 PM
Stack Trace
at cfindex2ecfm2092738825._factor1(D:/web-data/hegibau.ch/http/index.cfm:353) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:312) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:281) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:218) 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:353) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:312) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:281) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:218) 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:353)
	at cfindex2ecfm2092738825._factor2(D:\web-data\hegibau.ch\http\index.cfm:312)
	at cfindex2ecfm2092738825._factor4(D:\web-data\hegibau.ch\http\index.cfm:281)
	at cfindex2ecfm2092738825._factor5(D:\web-data\hegibau.ch\http\index.cfm:218)
	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)