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 359
Called from D:/web-data/hegibau.ch/http/index.cfm: line 318
Called from D:/web-data/hegibau.ch/http/index.cfm: line 287
Called from D:/web-data/hegibau.ch/http/index.cfm: line 224
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 359
Called from D:/web-data/hegibau.ch/http/index.cfm: line 318
Called from D:/web-data/hegibau.ch/http/index.cfm: line 287
Called from D:/web-data/hegibau.ch/http/index.cfm: line 224
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
357 : 											<cfif f neq "alle" and f neq "offen">
358 : 												AND medsummary = '#f#'
359 : 											<cfelseif f neq "alle" and f eq "offen">
360 : 												AND NOT medsummary IN ('verkauft','reserviert','vermietet')
361 : 											</cfif>

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

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.226.72.194
Referrer  
Date/Time   22-Jul-24 06:18 AM
Stack Trace
at cfindex2ecfm2092738825._factor1(D:/web-data/hegibau.ch/http/index.cfm:359) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:318) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:287) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:224) 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:359) at cfindex2ecfm2092738825._factor2(D:/web-data/hegibau.ch/http/index.cfm:318) at cfindex2ecfm2092738825._factor4(D:/web-data/hegibau.ch/http/index.cfm:287) at cfindex2ecfm2092738825._factor5(D:/web-data/hegibau.ch/http/index.cfm:224) 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:359)
	at cfindex2ecfm2092738825._factor2(D:\web-data\hegibau.ch\http\index.cfm:318)
	at cfindex2ecfm2092738825._factor4(D:\web-data\hegibau.ch\http\index.cfm:287)
	at cfindex2ecfm2092738825._factor5(D:\web-data\hegibau.ch\http\index.cfm:224)
	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)