[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> <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 )