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
Renier Leenders writes:
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... I think this is an FAQ:
Z SQL Methods look for there arguments either (exclusive) in the request object of in keyword arguments (the latter takes precedence). Dieter
participants (2)
-
Dieter Maurer -
Renier Leenders