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:
select * from ?
If you want to keep using the GString, just change the last line to:
Paul King - 06/Jan/08 01:43 AM 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:
select * from ?
If you want to keep using the GString, just change the last line to:
Improvement
Closed
Minor
provide GString versions for Sql.rows and Sql.firstRow() [minor breaking change]
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: