[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