Weird question for all you old-timers. Have you ever been able to add a column to a query by just setting a value for it in one row? Like without calling queryAddColumn() or some such? Not that I remember, but someone is asking about that.

Pretty sure it doesn't work.

You're right, doesn't work, but I'm asking if historically it EVER worked. And just to be clear, I'm not recommending any such thing, just trying to answer that question.

I am 75% certain it's not worked back when I used to try such things. Which woulda been CF4.5-6.1-ish

I’ll bring it to some folks’ attention.

Thanks pal

Just because they'll ask, you say "terrible error message" but what would be your expected msg/response? Is the Lucee response acceptable?

Yeah, they're spitting out "implementation detail". Lucee's got it right. ie; I'm not working with a columnMap structure... they are working with a column map structure. TBH it's poss a bug in their code, and the error is bubbling up to CFMLland

Perfect. Thank you sir.

I realise it is not what you're specifically asking about; But - if you just want to add a column that is the same value in every row - you can alter the SQL like below;

SELECT
id, description, 'MYVALUE'
FROM
someTable

Which would give you results like;

1,Description 1 is here, MYVALUE
2,Dexcription 2 is here, MYVALUE
...

I do this when I am working with a lot of joins and want it to be clear where the data from one table stops and the next starts;

select
'111111', a.id, a.xxx, '222222', b.id, b.yyy
from
someTable a 
inner join someOtherTable b on ...

111111, 1, xxx, 222222, 14, yyy
111111, 2, xxx, 222222, 87, yyy
...

I was curious and remembered I'd seen Julian Halliwell renamed columns in a query using

setColumnNames

- turns out you can use it to add columns as well... https://trycf.com/gist/d4c243c3130925290dd4abc27cf29a7a/lucee5?theme=monokai

Instead of QueryAdd, Get result of Queries for tables you need, then build the output based upon QoQ, Example: https://trycf.com/gist/ab1dc9b53327688df3a35ec2ebe1c185/lucee5?theme=monokai