[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
>