[Zope] SQL results

Farrell, Troy troy.farrell@wilcom.com
Tue, 27 Mar 2001 09:57:56 -0600


Alejandro,
  If I remember correctly, ZSQL Methods only see variables from REQUEST =
and
those explicitly passed to the method.  With that in mind, try this:

<dtml-in name=3D"select_sql_sentence">
  <dtml-call expr=3D"insert_sql_sentence(var1 =3D var1, var2 =3D var 2, =
. . .)">
</dtml-in>

And let us know.

Troy

-----Original Message-----
From: Alejandro Pancani [mailto:apancani@topgroup.com.ar]
Sent: Tuesday, March 27, 2001 9:44 AM
To: zope@zope.org
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=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 -=20
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )