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.