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

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

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...

Election day plus 1: Social Media Nightmare

It is election day plus 1, and a very emotional day with no way to win for many.

Social media was a force to be reckoned with this election year.  No matter what position you take, the world is ready to pounce on you and tell you why YOU are evil, intolerant or a deplorable -- and the reason for all their woes.  This isn't a new problem, though...  All of the liberal vs conservative issues are causing rifts between otherwise civil people, and it seems to be the worst on Facebook and twitter.

If I say I am for Hillary:
i am part of the "corrupt system."

If I say I am against Hillary:
I am stupid and uneducated

If I say I am for Trump:
I am against women,
I am religiously intolerant,
I am a bigot

If I say I am against Trump:
I am against the 2nd amendment,
I don't have any idea how government works,
I am part of the problem with American society,
I am against the police

Stay with me now, this isn't meant to make people angry, but it is mean to shine some light on a social …