[ic] query in a query list
Xavier GILLET
interchange-users@icdevgroup.org
Sun May 18 16:44:00 2003
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]