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="">Ben Nadel's</a>, Here is <a target="new" href="">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.

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

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

Getting Started with OpenVAS on CentOS - an open source vulnerability scanner

The Open Vulnerability Assessment System (OpenVAS) is a framework of several services and tools offering a comprehensive and powerful vulnerability scanning and vulnerability management solution. (Taken from the OpenVAS website, which is at )

This blog entry will introduce OpenVAS version 3.1, walk through installation on CentOS and is intended as a "getting started" guide. I'll also do a guide for installing on Ubuntu later.