title: How can we add a new row in middle of a cfquery result?
body: <p>I have a query result set from cfquery. I just want to add a new after a particular row number. But When tried each time it inserts the row at the end.</p>
  
  <p>Is there any way I can insert row at the middle of the query?</p>
  
  <pre><code> &lt;cfquery datasource="cse" name="abc"&gt;
      select * from grade 
   &lt;/cfquery&gt;
  
   &lt;cfset i = 0&gt;
   &lt;cfloop query="abc"&gt;
     &lt;cfset i = i+1&gt;
     &lt;cfif i eq 2&gt;
        &lt;cfset queryAddRow(abc)&gt;
     &lt;/cfif&gt;  
   &lt;/cfloop&gt;
  </code></pre>