Skip to main content

Converting a query to Array ... and Back again, for Flex sake...

There have been a few blog posts on how to convert a query into an array of structures.  Here is <a target="new" href="http://www.bennadel.com/blog/124-Ask-Ben-Converting-a-Query-to-an-Array.htm">Ben Nadel's</a>, Here is <a target="new" href="http://www.mximize.com/function-query-to-array-of-structures">Carlos Gallupa's</a>, and there are more out there.

Now that you are a master at converting query to array-of-struct, how about converting it back to a query?  No, not just for kicks, but perhaps for that crazy array you built, that you now want to pull via CFC into a Flex app ? (this is the reason I bothered, b/c u know that CF queries get auto-translated into ArrayCollections in Flex, don't you ??)<more/>If you had an array of structures called "result," you can loop over the array, and reconstruct the query using the key names from your structs and dynamically populate the query set onr row at a time.

<code>
<cfset qrsResultSet = QueryNew(StructKeyList(result[1]))>
<cfloop from="1" to="#ArrayLen(result)#" index="j">
   <cfset temp = QueryAddRow(qrsResultSet,1)>
      <cfloop list="#StructKeyList(result[1])#" index="f">
         <cfset temp = QuerySetCell(qrsResultSet,f,Evaluate("result[j].#f#"),j)>
      </cfloop>
   </cfloop>
</code>

Nice and simple.  The only thing that could go wrong is if some of your structs have different keys, in which case you should do a bit of error checking, handling.  Perhaps check if the struct key is in the query, and if not, add it.

Popular posts from this blog

Making Macbook Air with 128GB SSD usable with Bootcamp

I recently got a new Macbook Air 11" (the 2012 version) and loaded it with goodies like 8GB ram and 2GHz Core i7.  What I DIDN'T upgrade was the internal SSD.  My config came with 128GB SSD and I refused to pay $300+ to upgrade it to 256GB.  Yeah I know, some call me cheap, but SSds cost $75-$150 for 240GB, so adding another 128GB for $300 seemed way too steep for me.  I figured "ok, I'm going to make 128G work!"

Here is the story of how that went...

Installing python 3.4.x on OSX El Capitan

I love "brew" package manager, but sometimes being too progressive breaks things.  I have several python apps that I maintain that get deployed to AWS using Elastic Beanstalk.  AWS eb can deploy with python 2.7 or 3.4.  Any recent 'brew install python3" will get 3.5.1. #annoying

Dell XPS M1330 + Snow Leopard Hackintosh

I have been working with a Dell XPS M1330 laptop for a few years now.  It doesn't quite match up to the newest notebooks in terms of performance, but it certainly still has some life in it.  I had previously installed OSX 10.5.x on it as an experiment, and had moderate success.  I decided to revisit this idea again to install Snow Leopard (OSX 10.6) on the Dell M1330, and keep some notes for those of you brave enough to Hackintosh your own machine...