Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.0-JSR-3
-
Fix Version/s: 1.5.2
-
Component/s: SQL processing
-
Labels:None
-
Number of attachments :
Description
provide
groovy.sql.Sql.rows(GString)
groovy.sql.Sql.firstRow(GString)
analogous to
eachRow and query
Added. Just a note for existing users of the String versions of the rows() and firstRow() methods. If you are using GStrings with the String versions of these methods, you may need to add ".toString()" to your GStrings otherwise you may experience wierd behavior. E.g. if you have something like:
def table = 'PERSON' GString query = "select * from $table" def result = sql.rows(query)The query will be passed looking for parameters and be changed to:
If you want to keep using the GString, just change the last line to:
def table = 'PERSON' GString query = "select * from $table" def result = sql.rows(query)