GROOVY Questions and Answers

How could you retrieve a single value from data base using Groovy?

To recover a single value from the database you can use the command

row = sql.firstRow (‘select columnA, column from tableName’)

println “Row: columnA = $ {row.columnA} and column = ${row.columnB}”