SQL

Hello
I would like to fill in a Select field using an SQL query: SELECT * FROM `aspt_visforms_1`
But I can't find where to put this request

Thank you for your help

Visforms Subscription Visform 3.12.10

Hi,

the fields that can create options form sql-Statements (listboxsql, radiosql and multicheckboxsql) where added to visForms 3.13.x/subscription 3.4.x, which are currently available as beta versions.
You have to update to visForms 3.13.9 and Subscription 3.4.7, if you want to use this feature.
As we do not distribute beta versions via Joomla! update manager, you have to download the installation packages from the downloads menu manually.

Regards,
Aicha

Thank you the SQL fields appear now
When I test the request I have: success: found 10 entries
but they do not appear in the Select field of the form

Hi,
if you use the sql statement
SELECT * FROM `aspt_visforms_1`
this can obviously not work.
Which information from this * should be use in the option list?

As stated in the documentation ( www.vi-solutions.de/en/documentations/do...m-database-using-sql ), which I would like you study carefully, "The SQL statement must return a value and a label"!

Regards,
Aicha

sorry I forgot to specify the field
SELECT `F1` FROM `aspt_visforms_1` WHERE 1
but it doesn't work

Hi,

please check out the documentation. "The SQL statement must return a value and a label"!
Your sql-Statement is still not correct. It cannot work with regards to creating listbox options.

Regards,
Aicha