[Zope] SQL results

Alejandro Pancani apancani@topgroup.com.ar
Tue, 27 Mar 2001 12:44:01 -0300


Is there any way to use the results of a query in other SQL sentence (lik=
e
INSERT)  without to have to redefine the variables in the REQUEST.

I tried this but didn=B4t work

<dtml-in select_sql_sentence>
    <dtml-call insert_sql_sentence>
</dtml-in>

The only way that I found was that:

<dtml-in select_sql_sentence>
    <dtml-call "REQUEST.set('result_of_select', result_of_select)">
    <dtml-call insert_sql_sentence>
</dtml-in>

Of course the SELECT sentence returns only 1 match



Alejandro Pancani
apancani@topgroup.com.ar