[Zope] How do I query one variable and place it back into another?

[Marten Quadland]

I am try to use one DTML Method and select a variable from a query and then
place the resulting variable into the second query.  Can't pull it off . . .
any suggestions?

For example,

DTML Method
-------------------------------
<!--#in QUERY1 size=1 start=query_start-->
<input name="var1" type=hidden value="<!--#var var1 fmt="%.0d" null=""-->">
<!--#/in-->

<!--#in QUERY2 size=1 start=query_start-->
<input name="var2" type=hidden value="<!--#var var2 fmt="%.0d" null=""-->">
<!--#/in-->
--------------------------------

QUERY1
--------------------------------
select var1
from blahtable
where col1 = 'yoyo'
--------------------------------

QUERY2
--------------------------------
select var2
from table2
where col2 = <!--#sqlvar var1 type=string-->
--------------------------------




Marten Quadland

<mailto:mquadland@ishophere.com> 
phone: 615-777-0070 ext.124 

I Shop Here - Where do you Shop? 
<http://www.ishophere.com>