title: Coldfusion query of queries with row numbers passed to second query
body: <p>I'm doing the following query of queries. The first dump of the query shows the entire excel sheet, the second dump shows the results of the second query.</p>
  
  <p>I'm doing a validation check of the excel sheet to make sure there are no more pit bulls breeds brought into the system and I need to be able to tell the user which row on the excel sheet has the pit-bull.</p>
  
  <p>How do I get the row numbers from the first row to appear in the second row? So the user can make changes on the excel sheet.
  Do I have to resort to editing the excel document when it was first uploaded into the server and add a row number column to it? There is probably a better way to accomplish this.</p>
  
  <pre><code>  &lt;cffunction name="validateExcelSheet" access="public" output="yes" returnType="void" 
  hint="check dogs"&gt;
  
      &lt;cfspreadsheet
      action="read"
      src="#SESSION.theFile#"
      headerrow= "1"
      excludeHeaderRow = "true"
      query = "allData"
      rows = "1-#lastRow#" /&gt;
  
  
  &lt;cfscript&gt;    
   pitBullcheck = new Query(
          sql ="SELECT * FROM allData where breed like 'Pit%' ",
          dbtype = "query",
          allData = allData);
          pitBullresult = pitBullcheck.execute().getResult();
     &lt;/cfscript&gt;
  
  &lt;/cffunction&gt;
  </code></pre>
  
  <p>Here's a tag based version of <code>cfquery</code></p>
  
  <pre><code>&lt;cfquery name="pitBullresult" dbtype="query"&gt;
  SELECT *
  FROM allData
  WHERE breed LIKE 'Pit'
  &lt;/cfquery&gt;
  </code></pre>