passing variable to dtml method -> sqlmethod
Greetings. I have a Z SQL Method that calls a select statement like so: select * from chart where <dtml-sqltest link op=eq type=nb optional multiple> I am calling this from a DTML method that formats the results. I need to call the method several times on a page, passing different values for link. I can send a value from the DTML method to the SQL method, but cannot work out how to send it from the dtml page. Do I have to start writing scripts here? Help appreciated. Don
On 23/8/02 2:18 am, "zopelist@robertson.net.nz" <zopelist@robertson.net.nz> wrote:
Greetings. I have a Z SQL Method that calls a select statement like so:
select * from chart where <dtml-sqltest link op=eq type=nb optional multiple>
I am calling this from a DTML method that formats the results.
I need to call the method several times on a page, passing different values for link. I can send a value from the DTML method to the SQL method, but cannot work out how to send it from the dtml page. Do I have to start writing scripts here?
Help appreciated.
Don
Not sure I've got it, but this might work (untested) <dtml-in "['link1', 'link2', 'link3']" prefix=my_link> <dtml-in "SQL(link=my_link_item)"> Formatting.... </dtml-in> </dtml-in> So no, no scripts needed - but they don't bite :) Hth Tone -- Dr Tony McDonald, Assistant Director, FMCC, http://www.fmcc.org.uk/ The Medical School, Newcastle University Tel: +44 191 243 6140 A Zope list for UK HE/FE http://www.fmcc.org.uk/mailman/listinfo/zope
participants (2)
-
Tony McDonald -
zopelist＠robertson.net.nz