The docs for queryExecute, https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/queryexecute.html, mention that returnType was added as an attribute, but there is no documentation on how to use it. Is it a fourth argument? Is it an option in the struct passed as the third argument?

It's not clear on that page but is an option. Which is listed if you follow the link for <https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-p-q/cfquery.html%7Cthe documentation for <cfquery>>. There is also an example at https://cfdocs.org/queryexecute

cool, but Adobe needs to also correct the docs 🙂

Maybe "Added the attribute returnType as an option" would clear it up.

well the history text could be better perhaps, but its not documented in the main section, know what i mean?

Like they did for the disableAutoGenKeys addition.

yeah I was just looking at that the other day - the supported types from what I can tell are:

query

(the default),

array

,

json/array

and

json/struct

so its missing json/struct too.

yeah, I just tried that one and it worked, so not sure if it is official

Yeah, the information appears to be correct under cfquery's syntax section but not in the attributes block under cfquery, and not listed under queryExecute.

Raymond is my hero of the day. I wish I could afford him as one of our own QA guys. 😉

Thanks all. I’ll update the page.

i break everything. when i 'retire' from DevRel, my plan is go into QA

Thanks, everyone. I've updated the doc. I still need to double check on json/struct though. could you please provide a snippet so I can test and pass on to the team? Thanks again.