The error:
Lucee 4.5.2.018 Error (database)
Message column [COUNT] not found in query, columns are [count()]
SQL
SELECT count() FROM pub.op_mstr, pub.apx_det
WHERE apx_account = 26 AND apx_policy = op_policy AND op_is_pend_init_issue
= 0 with (nolock)
Stacktrace The Error Occurred in
/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm: line 31
29:
30:
31: <cfif qrypolcount.count LTE 10>
32:
33:
called from /home/WWW-data/pstif-udw/homepage/manage/index.cfm: line 39
Java Stacktrace column [COUNT] not found in query, columns are [count(*)]
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:801):801
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:1712):1712
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:255):255
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1436):1436
at
manage.act_wait_or_go_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm:31):31
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:855):855
at
manage.index_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/index.cfm:39):39
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at
lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:56):56
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:36):36
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2262):2262
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2225):2225
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217):217
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091):1091
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673):673
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500):1500
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456):1456
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745
When I run this in our JDBC sql test utility, it runs fine.
Is there a certain syntax Lucee needs to be able to run this query?
Thanks!
I think that should be <cfif qrypolcount.recordcount LTE 10>On 29 April 2016 at 16:17, Josh Beach <@Josh_Beach> wrote:
<cfif qrypolcount.count LTE 10>
Hi,
Looks more like the column needs aliasing, so the SQL would start more like:
SELECT count(*) as [Count] FROM
so that the column is available to lucee to use.
Kind regards
JediOn 29 April 2016 at 16:45, Julian Halliwell <@Julian_Halliwell> wrote:
I think that should be <cfif qrypolcount.recordcount LTE 10>
On 29 April 2016 at 16:17, Josh Beach <@Josh_Beach> wrote:
<cfif qrypolcount.count LTE 10>
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAC_5Voo4BF75ecno3WXatwBroXP8YPbQk%2B2faeyd87ZKEzt55A%40mail.gmail.com
.
For more options, visit https://groups.google.com/d/optout.
I’m guessing it doesn’t like you using “Count” as an alias.
Try:
SELECT count(*) as Total FROM …
- SebOn Tuesday, 3 May 2016 16:05:44 UTC+1, Josh Beach wrote:
I have attempted to apply your recommendation and am still getting a
syntax error:
Lucee 4.5.2.018 Error (database)
Message
Detail [OpenLink][OPLJDBC4][Progress Server]Syntax error in SQL statement
at or about “[Count] FROM op_mstr, apx_det WHERE apx” (10713)
SQL
SELECT count(*) as [Count] FROM op_mstr, apx_det
WHERE apx_account = 347 AND apx_policy = op_policy AND
op_is_pend_init_issue = 0 with (nolock)
DatabaseName PROGRESS
DatabaseVersion 11.01.0000 11
DriverName openlink.jdbc4.Driver
DriverVersion 04.43 (Release 6.3)
Datasource mopstif
Stacktrace The Error Occurred in
/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm: line 29
27: SELECT count(*) as [Count] FROM op_mstr, apx_det
28: WHERE apx_account = #Client.acc_account# AND apx_policy = op_policy
AND op_is_pend_init_issue = 0 with (nolock)
29:
30:
31:
called from /home/WWW-data/pstif-udw/homepage/manage/index.cfm: line 39
37:
38:
39:
40:
41:
Java Stacktrace
at openlink.jdbc4.OPLMessage.makeException(Unknown Source):-1
at openlink.jdbc4.OPLStatement.execute_qry(Unknown Source):-1
at openlink.jdbc4.OPLStatement.execute(Unknown Source):-1
at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:37):37
at
lucee.runtime.db.driver.state.StateStatement.execute(StateStatement.java:43):43
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:232):232
at lucee.runtime.type.QueryImpl.(QueryImpl.java:243):243
at lucee.runtime.tag.Query.executeDatasoure(Query.java:787):787
at lucee.runtime.tag.Query.doEndTag(Query.java:597):597
at
manage.act_wait_or_go_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm:29):29
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:855):855
at
manage.index_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/index.cfm:39):39
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at
lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:56):56
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:36):36
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2262):2262
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2225):2225
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217):217
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091):1091
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673):673
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500):1500
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456):1456
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745
Any suggestions:
Thanks!
On Friday, April 29, 2016 at 10:54:54 AM UTC-5, Jedihomer Townend wrote:
Hi,
Looks more like the column needs aliasing, so the SQL would start more
like:
SELECT count(*) as [Count] FROM
so that the column is available to lucee to use.
Kind regards
Jedi
On 29 April 2016 at 16:45, Julian Halliwell julianh...@gmail.com wrote:
I think that should be <cfif qrypolcount.recordcount LTE 10>
On 29 April 2016 at 16:17, Josh Beach josh.r...@gmail.com wrote:
<cfif qrypolcount.count LTE 10>
You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAC_5Voo4BF75ecno3WXatwBroXP8YPbQk%2B2faeyd87ZKEzt55A%40mail.gmail.com
.
For more options, visit https://groups.google.com/d/optout.
I have attempted to apply your recommendation and am still getting a syntax
error:
Lucee 4.5.2.018 Error (database)
Message
Detail [OpenLink][OPLJDBC4][Progress Server]Syntax error in SQL statement
at or about “[Count] FROM op_mstr, apx_det WHERE apx” (10713)
SQL
SELECT count(*) as [Count] FROM op_mstr, apx_det
WHERE apx_account = 347 AND apx_policy = op_policy AND
op_is_pend_init_issue = 0 with (nolock)
DatabaseName PROGRESS
DatabaseVersion 11.01.0000 11
DriverName openlink.jdbc4.Driver
DriverVersion 04.43 (Release 6.3)
Datasource mopstif
Stacktrace The Error Occurred in
/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm: line 29
27: SELECT count(*) as [Count] FROM op_mstr, apx_det
28: WHERE apx_account = #Client.acc_account# AND apx_policy = op_policy AND
op_is_pend_init_issue = 0 with (nolock)
29:
30:
31:
called from /home/WWW-data/pstif-udw/homepage/manage/index.cfm: line 39
37:
38:
39:
40:
41:
Java Stacktrace
at openlink.jdbc4.OPLMessage.makeException(Unknown Source):-1
at openlink.jdbc4.OPLStatement.execute_qry(Unknown Source):-1
at openlink.jdbc4.OPLStatement.execute(Unknown Source):-1
at lucee.runtime.db.driver.state.StateUtil.execute(StateUtil.java:37):37
at
lucee.runtime.db.driver.state.StateStatement.execute(StateStatement.java:43):43
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:232):232
at lucee.runtime.type.QueryImpl.(QueryImpl.java:243):243
at lucee.runtime.tag.Query.executeDatasoure(Query.java:787):787
at lucee.runtime.tag.Query.doEndTag(Query.java:597):597
at
manage.act_wait_or_go_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/act_wait_or_go.cfm:29):29
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:855):855
at
manage.index_cfm$cf.call(/home/WWW-data/pstif-udw/homepage/manage/index.cfm:39):39
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:951):951
at
lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:56):56
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:36):36
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2262):2262
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2225):2225
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217):217
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502):502
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518):518
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091):1091
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673):673
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500):1500
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456):1456
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142):1142
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617):617
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745
Any suggestions:
Thanks!On Friday, April 29, 2016 at 10:54:54 AM UTC-5, Jedihomer Townend wrote:
Hi,
Looks more like the column needs aliasing, so the SQL would start more
like:
SELECT count(*) as [Count] FROM
so that the column is available to lucee to use.
Kind regards
Jedi
On 29 April 2016 at 16:45, Julian Halliwell <julianh...@gmail.com <javascript:>> wrote:
I think that should be <cfif qrypolcount.recordcount LTE 10>
On 29 April 2016 at 16:17, Josh Beach <josh.r...@gmail.com <javascript:>> wrote:
<cfif qrypolcount.count LTE 10>
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>
.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/CAC_5Voo4BF75ecno3WXatwBroXP8YPbQk%2B2faeyd87ZKEzt55A%40mail.gmail.com
.
For more options, visit https://groups.google.com/d/optout.