I'm accustomed to setting up queries like this:
But I just upgraded to 5.3(.1.95) from 5.2(.9.31) and this code now generates:
Searching for other issues that may relate or show a path out for me; I see this:
Java 1.8.0_202 (Oracle Corporation) 64bit
OS Linux (4.4.0-34-generic) 64bit
Once again i checked this ticket and confirmed the issue happened on Lucee latest version 22.214.171.124 SNAPSHOT also. If we execute query once, then the sql was removed from the query. So we try to execute the query once again means it throws an error like "the required sql string is not defined in the body of the query tag, and not in a sql attribute". And added a test case for this ticket.
Pull Request: https://github.com/lucee/Lucee/pull/888
Problem still exists in Lucee 126.96.36.199
Any updates on this issue?
I think it’s just a one liner, but I’m not sure why it was done in the first place…. i.e. any side effects?
It’s not actually anything to do with clearParam, calling execute removes the sql