database connector just work for the first scrip


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 .


Submitted by yannick.lombardi on Tue, 08/12/2014 - 09:25

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

  1. resultset.beforeFirst();
  3. return resultset.getInt('id');
Submitted by nazigh19 on Tue, 08/12/2014 - 09:59

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

Submitted by yannick.lombardi on Tue, 08/12/2014 - 10:04

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.

No answers yet.