[Zope] Is it possible to pass output from tinytables to a zsq l method?

Chris Beaven Chris@d-designz.co.nz
Tue, 10 Sep 2002 12:52:41 +1200


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>&nbsp;<dtml-var begin_art>&nbsp;<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>&nbsp;<dtml-var
begin_art>&nbsp;<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 )