Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

"Variable Usage in Queries" not functioning

Description

If "Variable Usage in Queries" is set to "Throw an Exception" in Lucee Admin, then the following query still executes:
<CFQUERY name="test" datasource="x">
select * from test
where A = "#url.tmp#"
</CFQUERY>

Environment

Lucee 5.3.5.92 on Debian

Attachments

3
  • 16 Apr 2020, 03:04 pm
  • 16 Apr 2020, 03:04 pm
  • 15 Apr 2020, 01:22 pm

Activity

Show:

Pothys - MitrahSoft 17 April 2020 at 14:32

As per the reporter said, I close this ticket.

Andrew Bollington 17 April 2020 at 12:24

Hi all; yes, happy to close the ticket - thanks for looking at the issue so promptly. I do think the functionality is confusing; but I agree it’s working!

Michael Offner 17 April 2020 at 11:13

server admin settings are only used in case a setting is not set in the web admin, we are aware that this can be missleading and we are actually working on an improvment.

But are you fine we close this ticket, in that case it works as expected.

Zac Spitzer 17 April 2020 at 06:59

I guess web should just default to inheriting from the server settings, that way you can override it, but the default comes from the server

Andrew Bollington 16 April 2020 at 16:00

Ahhh - sorry, I misunderstood. Yes, if I make the change in Web Admin, then it works as expected.

In my defence, if that’s the intended functionality, then I fail to see the value of having this setting in the Server admin. It’s almost misleading. Effectively, it’s just setting the default value for a new web instance - without having any impact on anything already running?

 

Closed

Details

Assignee

Reporter

Priority

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 14 April 2020 at 20:44
Updated 17 April 2020 at 14:34
Resolved 17 April 2020 at 14:34

Flag notifications