Error with groovy

Q&A
1

hi
i tried to fill a check list with this script:

import groovy.sql.Sql
def list =
sql = BonitaSql.newInstance(“jdbc:postgresql://host:5432/schema”,“user”, “pass”, new org.postgresql.jdbc.Driver())
sql.eachRow “SELECT type_id from types”,{list += it.type_id}
sql.close()
return list

I have an advertence in the word : “it”

but when I execute the process the portal give me an error: “dont find the form pages”

2

Your sql.eachRow is wrong, see here:

http://stackoverflow.com/questions/6116198/groovy-sql-eachrow-and-rows-method

regards
Seán

PS: If this reply answers your question, please mark a resolved.