[Zope] Checkbox and SQL Method

[Eric Walstad]

Hi Charlene,

I don't think you need to worry about the brackets.  They indicate that the
parameter is a "list," which I believe is what <dtml-sqlvar ... multiple>
expects to receive.
It looks like your list contains a bunch of strings.  If you want the list
to contain "int"s, try this:

In your form, let Zope handle the data conversion by specifying that the
checkbox values are "int"s:

<input type="checkbox" name="selected_lcn:int" value="<dtml-var index>">
-----------------------------------------^^^^

See the section of the Zope Book named "Passing Parameters to Scripts" (page
126 in the PDF version) for info on how Zope can handle parameter
conversions.  It's pretty cool!

Eric.


> -----Original Message-----
> From: CHOY,CHARLENE (HP-Boise,ex1) [mailto:charlene_choy@hp.com]
>
> 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]
> 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.

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