title: how to loop over the tables of a database?
body: <p>I am trying to loop over the tables of a database using the following code getting an error <code>java.lang.UnsupportedOperationException</code>. i have even tried with <code>cfloop query and other attributes</code> got errors complex value can't convert to simple value. can anyone tell me how shall i have to loop over this query ? Thanks.</p>
  
  <pre><code>&lt;cfquery name="q" datasource="datasource"&gt;
      SHOW TABLES FROM datasource
  &lt;/cfquery&gt;
  &lt;cfloop collection ="#q#" item="i"&gt;
     #q[i]#
  &lt;/cfloop&gt; 
  </code></pre>