thanks for the prompt reply.

Can these grids be populated base on sql para
meters or should the params

The module can show data from a database based on "SELECT" SQL query. For this set "Choose source type" parameter to "SQL" and enter an SQL query in "SQL -> SQL query" parameter.

Regards,
ARI Soft

how do i pass a parameter to a paramerised query

Explain in more details what parameters do you mean? It is possible to use in "WHERE" clause of "SELECT" SQL query predefined variables like {$UserId), {$UserLogin} and etc. It is also possible to use request variables in the next format:

{$REQUEST:key}

Where "key" is a name of a request variable.

Regards,
ARI Soft

hi
exactly that a parameter in the where clause .
What i would like to do is click on a row in the grid and pass a parameter to another article . the query in the new article must accecp the parameter from the the previous article. hope this makes sense

You can use "Columns Settings -> Format" parameter to create a link from a main table to a secondary table and send a value as request parameters. For example if a main table contains "id" column and a secondary table is loaded into article with ID = 71 and you want to send "id" parameter from a main table to a secondary table. Set "Columns settings -> ID" to id and "Columns settings -> Format" to the next value:



in main table module settings. In a SQL query of secondary table you can use {$REQUEST:pId} parameter.

Regards,
ARI Soft