[ic] [query] in a [loop]
Rene Hertell
interchange-users@icdevgroup.org
Tue May 6 08:51:00 2003
> Still not working.
>
> [loop prefix=fichiers list="a01b02c01 a01b02c02 a01b02c03"]
> [seti foo][fichiers-code][/seti]
> [scratch foo]<br>
> [query
> type=list
> ml=1000
> sql="select actual_status from [scratch foo] where
> posted_by = '[data session username]'
> and
> initial_status = 'confirmee'
> "]
> [list]
>
> [/list]
> [/query]
> [/loop]
Remove the [list] [/list] tags and add a [sql-param actual_status] into the
[query] tag. Change the [seti foo][/seti] to [tmp foo][/tmp]. That should
work.
Rene