vi-solutions
Software + Internet

Joomla 5 Notice

We are pleased to announce that as of January 29, 2024, all of our Joomla extensions are compatible with Joomla 5.

For all who are still updateing from Joomla 3 to Joomla 4: Joomla 4 Migration instructions are available here:

There is now a separate Documentation for Visforms for Joomla 4 and for Visforms for Joomla 5!

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.

SQL

More
4 years 2 months 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
4 years 2 months 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 4:
docs.joomla-5.visforms.vi-solutions.de/en/docs/
Most of this also applies retrospectively to Joomla 3.
Please only ask 1 question per topic :-).

:idea: Ich empfehle Dir die neue und aktuelle Dokumentation für Joomla 4:
docs.joomla-5.visforms.vi-solutions.de/docs/
Das meiste gilt rückwirkend auch für Joomla 3.
Bitte immer nur 1 Frage pro Thema stellen :-).

More
4 years 2 months 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