database connector just work for the first scrip

Q&A
1

hi
i have problem with database connector
just the first variable is known in in my form (datalist)
pic
when i want show other variable except the first one , empty list will be shown .

2

What script did you use for the second variable ?
When I do something like this, I use this kind of script :

resultset.beforeFirst();
resultset.next();
return resultset.getInt(‘id’);

3

thank you
i didnt write this line : resultset.beforeFirst();
is it initialize resulset ?

4

For each script, you need to return the resultset to the beginning, or it will point nothing if it already is to the end of the set.