GroovySQL and (manually) iterating over a ResultSet

[Maarten Boekhold]

Hi all,

I'm aware of Sql.eachRow() etc, but I need more control while iterating 
over each row of a ResultSet. To run my query, I can use 
Sql.executeQuery(), which returns a ResultSet, and I can of course run 
".next()" on that. But I'll lose all the nice groovy-features of getting 
to the row results.

Is there any way to get a GroovyRowResult for the current row of a 
ResultSet that was returned by Sql.executeQuery()?

Maarten