[Zope] SQL results

Phil Harris phil.harris@zope.co.uk
Tue, 27 Mar 2001 16:50:36 +0100


How about

<dtml-in select_sql_sentence>
    <dtml-call "insert_sql_sentence(result_of-select=3Dresult_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 (l=
ike
> 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
>
>
> _______________________________________________
> 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 )