title: Store sql.eachRow() of groovy sql to a List
body: <p>do you know how to store the result from</p>
  
  <pre><code>    sql.eachRow()
  </code></pre>
  
  <p>of groovy sql to a list? for example def personList = [] ?</p>
  
  <p>example:</p>
  
  <pre><code>    sql.eachRow('select lastname from users where id='active')
  </code></pre>
  
  <p>What I want is to store the result ie. lastnames to a list ie def personlist = [];
  I know I can easily do this by namedQuery and I've already done it. But their is some underlying reason about this. Thanks in advance.</p>