[solved]dynamic module parameters

[wojtekkk87]

Hallo,
Short question... It is possible to have dynamic parameter in params page of my module?

e.g. I would like to add <select> element with articles categories or sections but it's not possible with xml manifest file...

Is there another posibility?

I hope You know what i mean...

edit:
Yes this is possible! It looks like below (in my case);)

Code: Select all

<param type="sql" name="groupid" label="GROUPID" description="GOUPIDDESC" query="SELECT id AS value, groupname AS groupid FROM #__tg_groups" />

[raashell]

Thanks for posting this. I ran into the same problem and wasn't able to figure out how to correctly format the sql parameter. Nothing came up until I changed the parameter id and name to reflect the SQL 'AS' alias.

[alan-s]

addendum...

Although I could generate a select box froma query the id was blank until you assign the field selected as 'value' eg 'SELECT id as value, title ' etc.


hth

[CZBios]

for Joomla! 2.5 here:

Code: Select all

http://docs.joomla.org/SQL_form_field_type