51 Posts
ostap
5 years ago
2
Topic

I liked the SQL package to use in the Form as a live value.

An ID is sent to my form. And in the form itself, several fields must display specific values, taking them from the same table in the database.

Ie: [2] - > Live - > "SQL query»

In "settings" for first write on:

Select column column1 from table#__, where id=…

Second:

Select column column2 from table#__, where id=…

And so on.

I am afraid that it is not quite effective, causes increased load on the server and it is more correct to make a single request:

Select column1, Column2,... from table#__, where id=…

Codec Pack?

Get a Book for SEBLOD
4229 Posts
Kadministrator
5 years ago
1
Level 1

Hi, yes code pack would help here onBeforeRender should be the right event but I am not sure it is early enough for live values to take effect in rendering, if not you will need to directly affect rendered html and value properties.

51 Posts
ostap
5 years ago
0
Level 2

 Ok thank you Kias

Get a Book for SEBLOD