-
1. Re: Odd QoQ issue when querying Solr collection
duncancumming Jan 28, 2013 7:11 AM (in response to WolfShade)Key is a reserved word in Coldfusion, so can't be used directly in a QoQ without escaping it. Try wrapping it in [ ] instead, i.e. [key]
It may also help to give it an alias too, e.g. SELECT [key] AS someKey
See the list of reserved words here: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec173d0-7f ff.html and the QoQ guide to using reserved words here: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd -7ff0.html#WSc3ff6d0ea77859461172e0811cbec22c24-7008
-
2. Re: Odd QoQ issue when querying Solr collection
WolfShade Jan 28, 2013 8:18 AM (in response to duncancumming)Och! I knew it might be something simple! Never thought about reserved words.
As soon as my dev system is done re-booting, I'll give that a shot and report back.
Thanks, Duncan!
^_^
UPDATE: Nailed it. Wrapped "KEY" in [brackets] and the issue has been resolved. Thanks, again!

