[Zope] Checkbox and SQL Method

[CHOY,CHARLENE (HP-Boise,ex1)]

Thanks Eric, I have solved part of my problem =)
  I have a new problem now.
  After the form is being process I have a list ['1','2','3'].
how do I get rid of the bracket and single quotes because I only need 1,2,3
as the argument to my sqlmethod.
  Thanks in advance for your help.

-Charlene

-----Original Message-----
From: Eric Walstad [mailto:eric@walstads.net]
Sent: Thursday, August 09, 2001 4:24 PM
To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail)
Subject: RE: [Zope] Checkbox and SQL Method


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>
>
> ******************************************************************