5 Replies Latest reply on Dec 30, 2010 5:26 AM by $Nith$

    Query multiple rows

    ditto9888 Level 1

      Hi, need some help on XML and XSD.

       

      say I have a table in the database with 3 columns: a, b, c

       

      on my XDP form, I have a table, like a spreadsheet, with 3 columns too: x, y, z

      and it has 10 rows.

       

      I want to pre-fill the form with 10 rows of data,

      so, in my Process's action profile,

      I use JDBC's query multiple rows to get the first 10 records of my database table.

       

      how do I put these 10 rows of data into the table on my form?

       

      TIA for helping me.

      Happy New Year!