I am trying to display sql query results as below
sql.eachRow(select * from issue){row->// log.error("loggggg" +row.values().toString());
}
But it is not displaying results. Am i doing something wrong?
can someone help on this
Hello Vineela,
The name of the table should be jiraissue.
Even i tried with jiraissue .but no use
How is your whole code?
it should be "select * from jiraissue" with quotes.
Yah it is "select * from jiraissue" with quotes
try {sql = new Sql(conn);
def sqlQueryREC ="select * from jiraissue";
sql.eachRow(sqlQueryREC )
{row->
log.error("results")
Nothing is being printed from that log.error. Is my sql.eachRow method syntax correct?
If so how should i display all the rows and what is the syntax for it?
And also please bear in mind that there is a loop here, so it might not have single result. In my code, I was concatenating all id values into stringbuilder.
It looks like you're new here. Sign in or register to get started.
