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>