[ic] query in a query list

[Xavier GILLET]

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]