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>
******************************************************************
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>
******************************************************************
Hi Charlene, you can do this with <dtml-var expr="_.string.join(yourlist,',')"> However this is a bit risky. An attacker could fake your form and send arbitratry strings with it! More complex, but saver would be something like that: <dtml-in yourlist> <dtml-unless sequence-start>,</dtml-unless> <dtml-sqlvar sequence-item type=int> </dtml-in> There might even be a group statement for SQL Methods, but I dont remember it at the moment. Note the square brackets you see are only a view on the list object what python provides if you just show the object. Regards Tino --On Donnerstag, 9. August 2001 16:18 -0700 "CHOY,CHARLENE (HP-Boise,ex1)" <charlene_choy@hp.com> wrote:
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>
******************************************************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
CHOY,CHARLENE (HP-Boise,ex1) -
Eric Walstad -
Tino Wildenhain