vi-solutions
Software + Internet

Joomla 6 Notice

We are pleased to announce that all our Joomla extensions have been compatible with Joomla 6 since October 14th, 2025.

For those currently upgrading from Joomla 3 to 4: Instructions for Joomla 4 migration can be found here:

There are standalone documentations Visforms Joomla 4, Visforms Joomla 5 and Visforms Joomla 6.

Forum

Visforms Subscription user can ask questions in our forum. Please log in with the relevant user first.
Everybody can access the forum for reading.

Please only ask 1 question per topic.

Important information for almost every question:
V1: Which Visforms version is running?
V2: Which Joomla version is running?
V3: Which PHP version is running?

SQL

More
6 years 1 month ago #6534 by av_74
Replied by av_74 on topic SQL
Sorry, I don't speak English well. I use google translation but the approximate translation does not allow me to fully understand how SQL fields work. I'm trying to fill a select field with a field from a Visform table ...

More
6 years 1 month ago #6535 by Administrator AV
Replied by Administrator AV on topic SQL
HI,

your sql must be something like

select id as value, F1 as label from aspt_visforms_1

the as value and as label must be there!
value and label which are returned by the sql statement are use to create the options

Regards,
Aicha
:idea: I recommend you the new and up-to-date documentation for Joomla 6:
docs.joomla-6.visforms.vi-solutions.de/en/docs/
Please ask only 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 6:
docs.joomla-6.visforms.vi-solutions.de/docs/
Bitte immer nur 1 Frage pro Thema stellen :-).

More
6 years 1 month ago #6536 by av_74
Replied by av_74 on topic SQL
Sorry I did not understand Indeed my SQl request was not good. Now it works: SELECT id as value, F1 as label FROM `aspt_visforms_1` limit 20
Thank you very much for your help, I hope I did not waste you too much time.
Thanks again

Moderators: Administrator AV, Administrator IV
Powered by Kunena Forum

Visforms Subscription

Visforms Extensions

Useful extensions for Visforms which enable you to integrate your forms perfectly into your website and to perform special tasks which turn Visforms into much more than just a form generator.

Info