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]Die Datentypen ntext und varchar sind im equal to-Operator inkompatibel.
 
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   402
SQLSTATE   HY000
SQL    SELECT * FROM tMedia WHERE medmdcid = 187 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   3.239.9.151
Referrer  
Date/Time   03-Mar-24 12:51 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]Die Datentypen ntext und varchar sind im equal to-Operator inkompatibel.
	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)