turn foundset into a valuelist

[m.moest]

Hi,

I have a database table 'db:/dbname/rcg' that has multiple columns including: 'name' and 'id'.

I have a foundset that contain a subset of all ids. Now i want the names of these ids in a valuelist. Does anyone know how to solve this?

[david]

See: http://wiki.servoy.com/display/public/M ... eListItems

Code: Select all

var query = 'select display_value,optional_real_value from test_table';
var dataset = databaseManager.getDataSetByQuery(databaseManager.getDataSourceServerName(controller.getDataSource()), query, null, 25);
application.setValueListItems('my_en_types',dataset);

[m.moest]

Thanks, that is it.