News

Sozialversicherungen 2023
Das neue Merkblatt
für Beiträge und Leistungen

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][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator) in Abfrageausdruck 'artKey = lacArtId AND lacCatId = 15 AND artTplId = 102 AND artKey <> AND artStatus = 30'.

The error occurred in D:/web-data/refina.ch/http/pages/template/getListeNews.cfm: line 28
Called from D:/web-data/refina.ch/http/pages/cms/GetCMSInit.cfm: line 16
Called from D:/web-data/refina.ch/http/GetInside.cfm: line 28
Called from D:/web-data/refina.ch/http/index.cfm: line 191
Called from D:/web-data/refina.ch/http/pages/mod/400.cfm: line 67
Called from D:/web-data/refina.ch/http/pages/template/getListeNews.cfm: line 28
Called from D:/web-data/refina.ch/http/pages/cms/GetCMSInit.cfm: line 16
Called from D:/web-data/refina.ch/http/GetInside.cfm: line 28
Called from D:/web-data/refina.ch/http/index.cfm: line 191
Called from D:/web-data/refina.ch/http/pages/mod/400.cfm: line 67

26 : 				 AND	lacCatId		=	#rub#
27 : 				 AND	artTplId		=	102
28 : 				 AND	artKey		<>	#q_list_1.artKey#
29 : 				 AND	artStatus	=	30
30 : 			ORDER BY lacSortNr

VENDORERRORCODE	-3100
SQLSTATE	42000
SQL	SELECT artKey FROM tArticle, tLnkArticleToCategory WHERE artKey = lacArtId AND lacCatId = 15 AND artTplId = 102 AND artKey <> AND artStatus = 30 ORDER BY lacSortNr
DATASOURCE	refina_cms_cms

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	3.227.251.94
Referrer
Date/Time	09-Jun-23 05:04 PM

Stack Trace

at cfgetListeNews2ecfm2088482453.runPage(D:/web-data/refina.ch/http/pages/template/getListeNews.cfm:28) at cfGetCMSInit2ecfm1793580328.runPage(D:/web-data/refina.ch/http/pages/cms/GetCMSInit.cfm:16) at cfGetInside2ecfm953215953.runPage(D:/web-data/refina.ch/http/GetInside.cfm:28) at cfindex2ecfm798551633.runPage(D:/web-data/refina.ch/http/index.cfm:191) at cf4002ecfm1913222593.runPage(D:/web-data/refina.ch/http/pages/mod/400.cfm:67) at cfgetListeNews2ecfm2088482453.runPage(D:/web-data/refina.ch/http/pages/template/getListeNews.cfm:28) at cfGetCMSInit2ecfm1793580328.runPage(D:/web-data/refina.ch/http/pages/cms/GetCMSInit.cfm:16) at cfGetInside2ecfm953215953.runPage(D:/web-data/refina.ch/http/GetInside.cfm:28) at cfindex2ecfm798551633.runPage(D:/web-data/refina.ch/http/index.cfm:191) at cf4002ecfm1913222593.runPage(D:/web-data/refina.ch/http/pages/mod/400.cfm:67)

java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator) in Abfrageausdruck 'artKey = lacArtId AND lacCatId = 15 AND artTplId = 102 AND artKey <> AND artStatus = 30'.
	at macromedia.sequelink.ssp.Diagnostic.toSQLException(Unknown Source)
	at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeDiagnostic(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decodeBody(Unknown Source)
	at macromedia.sequelink.ssp.Chain.decode(Unknown Source)
	at macromedia.sequelink.ssp.Chain.send(Unknown Source)
	at macromedia.sequelink.ctxt.stmt.StatementContext.execDirect(Unknown Source)
	at macromedia.jdbc.sequelink.SequeLinkImplStatement.execute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.slbase.BaseStatement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:265)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1461)
	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 cfgetListeNews2ecfm2088482453.runPage(D:\web-data\refina.ch\http\pages\template\getListeNews.cfm:28)
	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 cfGetCMSInit2ecfm1793580328.runPage(D:\web-data\refina.ch\http\pages\cms\GetCMSInit.cfm:16)
	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 cfGetInside2ecfm953215953.runPage(D:\web-data\refina.ch\http\GetInside.cfm:28)
	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 cfindex2ecfm798551633.runPage(D:\web-data\refina.ch\http\index.cfm:191)
	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 cf4002ecfm1913222593.runPage(D:\web-data\refina.ch\http\pages\mod\400.cfm:67)
	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)