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

Renier Leenders rf.leenders@planet.nl
Tue, 10 Sep 2002 02:37:58 +0200


Hi there,

For a couple of days a try to pass output from a tinytable to a zsql meth=
od=20
without any success because the variables exist only during the looping..=
=2E

Tinytable:=20
name: contents
columns: content   begin_art   end_art

Looping:
<dtml-in contents>
<a href=3Dwet_query><dtml-var content>&nbsp;<dtml-var begin_art>&nbsp;<dt=
ml-var=20
eind_art></a><BR>
</dtml-in>

Zsql method: wet_query
select * from <dtml-var id> where artnr >=3D <dtml-sqlvar begin_art=20
type=3D"string"> and artnr <=3D <dtml-sqlvar end_art type=3D"string">

Does someone know how i can pass <dtml-var begin_art> and <dtml-var end_a=
rt>=20
to the zsql method?

Any suggestions will be greatly appreciated.

Renier