[Zope] calling Z SQL methods specified by strings

Rua Haszard Morris ruahm@yahoo.com
Sun, 20 Apr 2003 12:55:31 +1200 (NZST)


I realise with the below that I should probably use a
python script.  I still have the same question though
- how can I call the sql methods by name stored in a
string?  i.e. the method names are parameters to the
script, and it should execute the queries, process and
return the query data.

Thanks in advance for any help,
Rua HM.

>> original message
Hi,

I have a form which dynamically allows different SQL
queries to be specified based on the contents of a
subfolder (i.e. each SQL method in the subfolder
becomes a checkbox).

e.g. 
<dtml-in "sqlFolder.objectValues()">
<input type=checkbox name=generateemails:list:string
value=<dtml-var sequence-var-id>><dtml-var
sequence-var-title></input>
</dtml-in>

When the form is submitted, the methods are stored in
a list of strings. 

How can I call (dtml-in style) the SQL methods
specified by the string?

e.g. (this is wrong obviously, but is there a way to
do it?)
<dtml-in generateemails> //the list of queries
returned
  <dtml-in sequence-item>//the current query???
    <dtml-var sequence-item>
  </dtml-in>
</dtml-in>

Any help would be greatly appreciated, as would
replies directly to ruahm@yahoo.com.

Thanks,
Rua HM.


=====
Rua Haszard Morris
Software Engineer & Research Assistant
MARCS Auditory Laboratories
http://apps.uws.edu.au/marcs

http://mobile.yahoo.com.au - Yahoo! Mobile
- Check & compose your email via SMS on your Telstra or Vodafone mobile.