portal entry

select a category, or use search below
(searches all categories and all time range)
Title:

QueryExecute named parameter gotcha!

| View in Portal
August 07, 2019 07:43:03 AM GMT
3 Comments
<p>I’ve not seen this posted before, apologies if it’s already been discussed! Our team have identified a bug when using QueryExecute and named query parameters. This doesn’t appear to affect all installations of ColdFusion, as it doesn’t affect my machine, but doesn’t work on our QA installation. When using named parameters, ColdFusion can map to the shorting named parameter, ie, if you have both “col1” and “col10” as named parameters, when “col10” gets replaced, it will match “col1” instead. An […]</p>
<p>The post <a rel="nofollow" href="https://coldfusion.adobe.com/2019/08/queryexecute-named-parameter-gotcha/">QueryExecute named parameter gotcha!</a> appeared first on <a rel="nofollow" href="https://coldfusion.adobe.com">ColdFusion</a>.</p>
Labels: CFML Tag/Function, Discussion, QueryExecute, 11, cfml tag/function, discussion, queryExecute

Comments:

That's certainly an odd one, but it would REALLY help if you'd indicate what cf version and update level this did and did not work on.
Comment by Charlie Arehart
2236 | August 13, 2019 12:48:42 AM GMT
Both versions are CF11. This works fine update pack 14 onwards, but didn't work  on update pack 3. I assume it was fixed in a pack between those two, and updating the latest version would resolve this, but wanted to help anyone else who encountered the same issues.
Comment by Chris Bossons
2244 | August 15, 2019 12:54:46 PM GMT
Great, thanks. I pressed because you said it worked on one but not another machine, yet you left it at proposing the workaround. :) Maybe it would help readers to add a closing sentence above (since some folks don't read comments) indicating that later updates did fix it, and that the workaround may help for someone who somehow couldn't update. As for which update fixed it, I see no mention of it in the bugs fixed for the latest cf11 u19 (https://helpx.adobe.com/coldfusion/kb/bugs-fixed-in-coldfusion-11-update-19.html), so it's not easy to tell when exactly it was fixed--or indeed if it affected cf2016 or 18, either.
Comment by Charlie Arehart
2245 | August 15, 2019 01:48:40 PM GMT