turn foundset into a valuelist

Classic Servoy
1

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?

2

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

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);
3

Thanks, that is it.