cfml

does lucee have a way to turn an array of structs into a query?
 ( i could see how that would be potentially problematic with non-common keys), but worth a shot

<@U07ACFUSG> Doesn't `queryNew()` accept an array of structs?

You'd just need to provide the column names and types

I feel silly since i built the sql function in commandbox, but i just couldn’t remember if it was that easy

<@U07ACFUSG> <https://trycf.com/gist/65c8049a2507c49586e54cad154461fb/lucee5?theme=monokai>

```data = [
    {
      cola : 'value1a',
      colb : 'value1b'
    }, 
    {
      cola : 'value2a',
      colb : 'value3b'
    }, 
    {
      cola : 'value3a',
      colb : 'value3b'
    }
]

dump( data )

qry=queryNew( 'cola,colb', 'string,string', data )

dump( qry )```

you can also pass array of structs to queryAddrow()

Yes, but I don't like that behavior :slightly_smiling_face:

The same ambiguity exists in both places though--
<https://luceeserver.atlassian.net/browse/LDEV-1206>

Ooh, nice. Looks like they changed this for Lucee 6

Though, I guess my ticket was more about having a struct with an array inside of it-- which isn't really what you said.  Carry on :slightly_smiling_face:

<https://docs.lucee.org/reference/functions/querysetrow.html>

i also like this addition `*Introduced:* 5.3.8.120`