Hello Alain,
The function CONCAT_WS() fits your needs perfectly as to join two or more strings with a separator!
The message 'success: found 28 entries' does tell you that you have a valid select statement which returns a record set having 28 entries.
The test is not looking for this:
But the SQL statement SQL statement must return a value and a label (Visforms Documentation).
This is why the list remains empty.
www.vi-solutions.de/en/documentations/do...m-database-using-sql
Please re-try something like this:
SELECT id as value, CONCAT_WS('F166','F167') as label FROM aspt_visforms_6
This SQL statement gives you a listbox filled with options, which have the recordset id as option values and the 'string-concatenation' (names) as option labels (or visible text).
The option value (the recordset id of the selected name) get saved to the database into the SQL listbox field.
Or re-try something like this:
SELECT CONCAT_WS('F166','F167') as value, CONCAT_WS('F166','F167') as label FROM aspt_visforms_6
This SQL statement gives you a listbox filled with options, which have the 'string-concatenation' (names) as option values and as option labels (or visible text).
The option value (the 'string-concatenation' of the two names) get saved to the database in the SQL listbox field.
As a general note I have to tell you, that some decent experience in writing/understanding SQL select statement is quite helpful.
Nothing else or special (apart from must return a value and a label) goes on here.
Must return a value and a label means, that the statement as to declare the two resulting parts:
'something' as value
'something' as label
Best regards, Ingmar