Hi Charlene, It looks to me like your SQL is set up to only handle one "index" value. If I understand your question, you need something like this in your SQL: SELECT * FROM data WHERE index IN (1, 3, 5, 7, 11); You can then use that list to populate the list of "indexes" used in the SQL IN clause. I think the <dtml-sqltest> tag will do the iteration over the list for you. Check out the "Dynamic SQL Queries" section of the Zope Book for more details. HTH, Eric.
If I get a list of input values for the argument of my sql method from the check box, how do I call the sqlmethod to repeatedly display them. My sqlmethod only has one argument.
The following is some of the snippet of my codes.
============================= sqlmethod: selected_item ============================= Argument: selected_number
"SELECT * data where index = <dtml-sqlvar selected_item type=int>"
******************************************************************
============================= dtml-method: list_selected_item ============================= <dtml-var standard_html_header> <form action=selected_item action=post> <dtml-in lookup_item size=50 start=query_start> //lookup_item is another sql method <dtml-if sequence-start> <dtml-comment> there is some more codes here </dtml-comment> <table> <tr> <th>Index</th> <th>Checkbox</th>
</dtml-if sequence-start>
<tr> <td><dtml-var index null=""></td>
<td><center><input type="checkbox" name="selected_lcn" value="<dtml-var index>"> </center></td> <dtml-if sequence-end>
</table> <dtml-comment> Some other codes here </dtml-comment>
</dtml-if sequence-end>
<dtml-else>
There was no data matching this <dtml-var title_or_id> query.
</dtml-in> <input type=submit value="Generate Report"> </form> <dtml-var standard_html_footer>
******************************************************************