Lucee 6.0.0.13-SNAPSHOT Error (database)
Message An expression of non-boolean type specified in a context where a condition is expected, near ','.
SQL SELECT *
FROM ( SELECT TOP (100) PERCENT Beker.WedstrijdId,
Beker.Seizoen,
Beker.District,
Beker.Ronde,
Beker.Poule,
Beker.Datum,
Beker.Aanvangstijdstip AS Aanvang,
Beker.Thuis,
Beker.Uit,
Beker.AfkThuis,
Beker.AfkUit,
CASE WHEN UitslagThuis > UitslagUit THEN 3 WHEN UitslagThuis = UitslagUit THEN 1 ELSE 0 END AS PuntenT,
CASE WHEN UitslagThuis < UitslagUit THEN 3 WHEN UitslagThuis = UitslagUit THEN 1 ELSE 0 END AS PuntenU,
Beker.UitslagThuis,
Beker.UitslagUit,
Beker.UitslagThuisNV,
Beker.UitslagUitNV,
Beker.UitslagThuisNS,
Beker.UitslagUitNS,
Beker.ThuisWNS,
Beker.UitWNS,
Beker.Doelpunten,
Beker.Scheidsrechter,
Beker.Afgelast,
Beker.Uitgesteld,
Beker.Gestaakt,
Beker.SNO,
Beker.Vervallen,
Beker.Opmerking,
Beker.Karakteristieken,
Beker.Titel
FROM Beker
WHERE Beker.Seizoen = '2627') u
WHERE 1 = 1





AND (Thuis LIKE 'Unitas%' OR Uit LIKE 'Unitas%')


AND UitslagThuis IS NULL
AND UitslagUit IS NULL
AND Poule, Datum >= {d '2026-08-30'}
ORDER BY (CASE WHEN Uit <> 'vrijgeloot' THEN 0 WHEN Uit = 'vrijgeloot' THEN 1 END), Poule, Datum
DatabaseName Microsoft SQL Server
DatabaseVersion 10.50.1600
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource sport
Stacktrace The Error Occurred in
C:\inetpub\wwwroot\voz2025\cfc\vrouwen.cfc: line 1059
1057: </cfif>
1058: </cfif>
1059: </cfquery>
1060:
1061: <cfreturn q>

called from C:\inetpub\wwwroot\voz2025\vrouwen\clubs\club.cfm: line 35
Java Stacktrace lucee.runtime.exp.DatabaseException: An expression of non-boolean type specified in a context where a condition is expected, near ','.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:319)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:274)
  at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:228)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125)
  at lucee.runtime.tag.Query._doEndTag(Query.java:688)
  at lucee.runtime.tag.Query.doEndTag(Query.java:554)
  at cfc.vrouwen_cfc$cf$evr.udfCall3(/cfc/vrouwen.cfc:1059)
  at cfc.vrouwen_cfc$cf$evr.udfCall(/cfc/vrouwen.cfc)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:683)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:570)
  at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1919)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1751)
  at vrouwen.clubs.club_cfm$cf$lrp.call(/vrouwen/clubs/club.cfm:35)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1019)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2442)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2432)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2403)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1174)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1120)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 30-8-26 8:08:50 CEST