portal entry

Simple and elegant.  Great use of arrayReduce().

Comment by David Byers

<p>Yes, very nice. Thanks, John (aka poor yorik. “Alas”, I wonder how many get the quip in your “alias”!)</p><p>About the code, I hope you'll submit it to the cflib site (cflib.org). Folks do still search there for possible CFML solutions to problems. </p><p>You’ll see a link there for submitting content, and indeed it’s now hosted on github (so submissions are by PR to that now). Ray is still the project owner, and though there are a couple of PRs outstanding from 2017, it’s worth a shot to see if it would get posted.</p><p>Thanks of course for the cffiddle.org link, in the meantime.</p>

Comment by Charlie Arehart

Hi Charlie, Happy to add it to cflib - looks like it's a Jekyll site now so will have to find some time to figure that out!

Comment by aliaspooryorik

Very nice thinking outside the box! This will be handy, thanks! :)<span></span>

Comment by Aaron Neff

This functionality is already built into CF (CF10+): <strong>writeDump(queryNew("i,label,foo,bar", "integer,varchar,varchar,varchar", data));</strong> For more info, see the rowData attribute in queryNew() here: <a href="https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/querynew.html" rel="nofollow">https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-functions/functions-m-r/querynew.html</a>

Comment by Jeff Coughlin

<p>@Jeff Coughlin Thanks for your comment, I’m aware of the data parameter for QueryNew. I didn’t use that here as you need to know the columns in advance before you can pass in the array. So sure, I could have used arrayReduce to find all the fields names, then used that do the `QueryNew(fields_found_in_array)`, but dynamically adding the cols seemed to be a much neater way to handle it.</p><p> </p>

Comment by aliaspooryorik

This was patched in <strong>CF2018 update 5</strong> (allowing you to just send in an array of structs and it essentially does all the same code you wrote in the backend). <strong>queryNew(data);</strong> However, assuming you don't have CF2018 update 5+ and you don't have the column names, then you're out of luck without looping and to get the data like you did. In that case, it's a cool function (thanks!) Just for kicks I wrote some code to work with queryNew, an array value, and getting the column names. It worked on the first try, but without realizing it I essentially just rewrote your code (facepalm). <span></span> <strong>accumulator = ""; columns = data.reduce(function(accumulator, item) { item.each(function(key) { if (!listFind(accumulator, key)) { accumulator = listAppend(accumulator, key); } }); return accumulator; }); writeDump(queryNew(columnNames = columns, data = data)); </strong>

Comment by Jeff Coughlin