cfml

Fun CFML quiz.  Read this code and decide what you think it does.  Then run it and see if you were right :slightly_smiling_face:  Note: Adobe CF behaves differently.
<https://trycf.com/gist/86d6f4c1fe54baa964055d0ac61042ec/lucee5?theme=monokai>
Answer in the thread.

These aren't all documented, but Lucee will accept in `queryAddRow()` and the third param of `queryNew()`

• An array of simple values (placed positionally in the new single row)
• A struct of values (placed via key name matching column name in a single row)
• An array of structs (One new query row per array item, each struct added like bullet #2
• A struct of arrays (placed via key name matching column name, *one row per array value*)

That last bullet I never knew until I was reading the Java code today in Lucee.

And there's two interesting things about it
• each struct value can have a different length array and there won't be an error.  Extra rows will just have an empty string if the array for that row didn't have enough items
• It's also impossible to set an actual array into a cell value when using this approach as Lucee assumes your array is meant to be translated into separate rows.

Ticket for the heck of it
<https://luceeserver.atlassian.net/browse/LDEV-3933>

I certainly would expect what ACF is doing, especially since the column has an `object` datatype.

^^^ what <@U0AEFTKRV> says.

I'd also expect me to raise a point with <@U01EY27APNH> to get the examples sorted out to be clearer and more to the point on both of them, especially `queryAddRow`. And `queryAddRow` needs its parameters table updated to reflect reality.

Lucee's behaviour with `queryAddRow` seems like a bug.  A struct should only add _one_ row to the query (ie: CF has it right, Lucee has it wrong).

Bravo to cfdocs for having clear, concise and complete examples for `queryAddRow`

Weird that ACF 10, 11 and 2016 all error out on the first line of code: "Invalid construct. on line 2"...

<@UJD93135E> Add semicolons if you want to run it on older versions of CF :slightly_smiling_face:

The code works all the way back to CF11 with semis