[Zope] SQL query results as <dtml> values ?

Graham Chiu anon_emouse@hotmail.com
Wed, 31 May 2000 12:09:33 +1300


In article <39343A8B.EF9EA5A3@tampabay.rr.com>, Richard Smith
<ozric@tampabay.rr.com> writes
>Maybe my question was too dense. I will try again. 
>lets say I do this in a ZSQL method 
>SELECT * FROM foo;
>of course I get a table of results.
>Now can I some how run another query
>base on the results, like to do an UPDATE and
>have the <dtml-sqlvar type=blah> use the values from the
>table ?  Please, I just need a little help here.
>
>Thanks
>Richard

<dtml-in "sqlFirstMethod()">
 
  returning value1, value2 ... valueN

 <dtml-call "sqlSecondMethod(arg1=value1, arg2=value2 ... )">

</dtml-in>

-- 
Regards,  Graham Chiu
gchiu<at>compkarori.co.nz
http://www.compkarori.co.nz/index.php
Powered by Interbase and Zope