[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