Comment included in sql portion of QueryExecute function, example:
/* MAY BREAK ON EXTRA PAYMENT AND SINGLES?
*/
Causes error message “there are more question marks in the SQL than params defined”
With stack trace:
lucee.runtime.exp.ApplicationException: there are more question marks in the SQL than params defined at lucee.runtime.tag.util.QueryParamConverter.convert(QueryParamConverter.java:159) at lucee.runtime.tag.util.QueryParamConverter.convert(QueryParamConverter.java:70) at lucee.runtime.tag.Query._doEndTag(Query.java:563) at lucee.runtime.tag.Query.doEndTag(Query.java:537) at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)
…
Discovered while converting to QueryExecute from query.execute() due to JTDS and MS DB driver differences in handling queries.
More of an FYI, not sure if this is bugworthy. Cannot provide example for here with sample query of queries using queryExecute, as queryExecute will not accept ‘/* comment-style */’ syntax in sql parameter.