How about <dtml-in select_sql_sentence> <dtml-call "insert_sql_sentence(result_of-select=result_of-select)"> </dtml-in> ? ----- Original Message ----- From: "Alejandro Pancani" <apancani@topgroup.com.ar> To: <zope@zope.org> Sent: Tuesday, March 27, 2001 4:44 PM Subject: [Zope] SQL results

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

I tried this but didn´t 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

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )