First of all, you won't be getting the end user to access the zsql method directly so you'll need a little wrapper to display the results. EG: show_art (just make it do a <dtml-in wet_query> and display the results inside it) Next, make sure that the wet_query ZSQL method has the 2 variables that it wants to get listed in the "Arguments" box Then just do this: <dtml-in contents> <a href=show_art?begin_art=&dtml-begin_art;&end_art=&dtml-end_art;><dtml-var content> <dtml-var begin_art> <dtml-var eind_art></a><BR> </dtml-in> So now since you are passing the variables to the show_art wrapper, they will be available to the query. -----Original Message----- From: Renier Leenders [mailto:rf.leenders@planet.nl] Sent: Tuesday, 10 September 2002 12:38 p.m. To: zope@zope.org Subject: [Zope] Is it possible to pass output from tinytables to a zsql method? Hi there, For a couple of days a try to pass output from a tinytable to a zsql method without any success because the variables exist only during the looping... Tinytable: name: contents columns: content begin_art end_art Looping: <dtml-in contents> <a href=wet_query><dtml-var content> <dtml-var begin_art> <dtml-var eind_art></a><BR> </dtml-in> Zsql method: wet_query select * from <dtml-var id> where artnr >= <dtml-sqlvar begin_art type="string"> and artnr <= <dtml-sqlvar end_art type="string"> Does someone know how i can pass <dtml-var begin_art> and <dtml-var end_art> to the zsql method? Any suggestions will be greatly appreciated. Renier _______________________________________________ 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 )