Hi,

after you install this pack you get new field Processing->SQL query. You can use this one e.g. in content view to show some related value.

You will also get a new live value option Processing->SQL query and new restriction option (same name).

For any of this options you need to write sql query that will execute and seblod will use its result as value.

here we go :)

http://www.seblod.com/resources/extensions/plug-ins/sql-pack

Ah that clear things a lot... thanks.... hope you include the link to this guide at product's description page as well for future reference

Hello,

with this plugin, is it possible to set the value of a field with using the value of an other field in the same form ?

For exemple : incrementing Field 2 based on a value from Field1

Field 1 value = id

Field 2 value= SELECT (val+1) FROM my_table WHERE id=Field1 value ?

Thanks

Please read manual mentioned above, what you need is explained at the end in blue box.

Thanks, I'd read it before, what I need to be sure is the system is working not only in a list but also in a form.

I'm sorry, I missed it is a form, in the forms it indeed does not work. You can only use sql plugin as live value or restriction on the form and vlaues from fields does not work in live value plugin.

Thanks, i's an important thing to know. So, I'll find an other solution.