[Zope] Checkbox and SQL Method

CHOY,CHARLENE (HP-Boise,ex1) charlene_choy@hp.com
Thu, 9 Aug 2001 17:25:08 -0400


Hi,
  I am having trouble parsing a list that I got from a form.  My clients can
select as many check boxes as they wish.  When process the form, the program
needs to be able to display all the information that the clients requested
base on the check boxes.  So far I can only display the information if the
client only select one checkbox.  The program will fail if the clients
select more than one checkbox. I believe the problem was that my sqlmethod
does not recognized the list that has been sent in. 
  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>  

****************************************************************************
********************

  Thanks in advance for your help.

-Charlene