[Zope] Passing python generated SQL to ZSQL in a DTML method

[hpinson at indepthl.com]

Hi. I have a dynamic Python generated SQL string which is available 
to a dtml-method page:

<dtml-var generated_sql> parses to: select item_id from items

I want to pass that string to a ZSQL method named: sqlMethod

with the argument: the_sql

and the content: <dtml-var the_sql>

In a dtml method i want to call sqlMethod, pass the generated_sql to 
it, and return the results, that is:

<dtml-in sqlMethod>
  <dtml-var item_id>
<dtml-in>

Any suggestions on how to approach this?

Harlow Pinson
Indepth Learning
Email: hpinson at indepthl.com 
Web: http://www.indepthl.com
Voice: 505-994-2135
FAX: 208-475-7678