title: Coldfusion 8 JSON - convert return string to query object
body: <p>I'm relatively new interacting with other systems using JSON functions and maybe I'm just brain farting on a basic problem.</p>
  
  <p>I access an API function that returns a query as a JSON string.  The return format is "plain".  The query runs to select a list of schools and creates an array of structures as the return string.</p>
  
  <pre><code>"[{\"city\":\"Adrian\",\"state\":\"MI\",\"school\":\"Adrian College\"},{\"city\":\"Albion\",\"state\":\"MI\",\"school\":\"Albion College\"},.........etc.
  </code></pre>
  
  <p>So now I need to convert this into a query object and work with it but now I just find myself going around in loops of google / test / re-google / re-test.  Any pointers on how to turn this into a query with school / city / state as the columns?</p>