[ic] query in a query list

Xavier GILLET interchange-users@icdevgroup.org
Sun May 18 17:03:00 2003


answer was in the documentation.
Sorry.

[query
type=list
prefix=foo
list_prefix=bar
ml=1000
sql="select texte_message from messages where
        ref_conversation = 'C[scratch conversation]'
        and
 message_type = 'Conversation'
 order by date_message asc"
]
[bar]
[foo-increment] : [foo-param texte_message]<br>
[/bar]
[/query]


----- Original Message -----
From: "Xavier GILLET" <xavier.gillet.perso@wanadoo.fr>
To: <interchange-users@icdevgroup.org>
Sent: Sunday, May 18, 2003 10:43 PM
Subject: [ic] query in a query list


> Hi,
>
> I have a problem with this code.
> First query return a list and for each line I can reload the page to have
a
> second list of results with the second query.
>
> The problem is the second query return nothing...
>
> Thanks for help.
>
> Xavier (Mister X) - France
>
>
> [query
> prefix=sql
> type=list
> ml=1000
> sql="select envoye_a_username, code, statut, debut_conversation,
> fin_conversation from messages where
>         envoye_par_username = '[data session username]'
>         and
>  message_type = 'Début'
>  order by debut_conversation desc"
> ]
> [sql-list]
>
> <a href="[area form='
>     voir_[sql-param code]=1
>     mv_todo=return
>     mv_nextpage=@@MV_PAGE@@']"><b>Détails</b></a>.
> [if cgi voir_[sql-param code]]
> [perl]$CGI->{voir_[sql-param code]}='';[/perl]
>
>         [tmp conversation][sql-param code][/tmp]
>         [query
>         type=list
>         ml=1000
>         sql="select texte_message from messages where
>                  ref_conversation = 'C[scratch conversation]'
>                  and
>                  message_type = 'Conversation'
>                  order by date_message asc"
>         ]
>         [list]
>         [sql-increment] : [sql-param texte_message]<br>
>         [/list]
>         [/query]
>
> [/sql-list]
> [/query]
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>