- Zope - Zope lists

Re: [Zope] Checkbox Help
by Tino Wildenhain 10 Aug '01

10 Aug '01

Hi Todd, --On Freitag, 10. August 2001 12:35 -0400 Todd Loomis <tloomis(a)dmso.mil> wrote: > Tino: > > Thanks, but now I get in the database ['D', 'A']. Its not ['D', 'A'] its a list with the strings 'D' and 'A' :-) ['D', 'A'] is only a view on the list object if it gets translated to a string directly. It depends on you what you actually want to do with the values. You might probably want to make a SQL statement like this: select ... where something in (value1,value2, ...) A quite "clean" way would be: select ... where something in ( <dtml-in valuelist><dtml-sqlvar sequence-item type=string><dtml-unless sequence-end>,</dtml-unless> </dtml-in> ) ... HTH Tino Wildenhain PS: back to the list, since it seems to be an FAQ today. > > Todd > > > At 06:25 PM 8/10/2001 +0200, you wrote: >> Hi Todd, >> >> as a service, Zope gives you a list if more then one >> value of the same name exist in a form. >> >> For what python types and especially lists are please >> see http://www.python.org/ -> Documentation -> Tutorial >> >> However, if you relie on this and get only one value, >> its not a list. However there are posibilities to >> cast an value explicitely to a list. >> >> If you change your form like this: >> >> <input type="checkbox" name="membership:list" value="D"> DMSO   >> <input type="checkbox" name="membership:list" value="A"> AMG   >> <input type="checkbox" name="membership:list" value="E"> EXCIMS   >> <input type="checkbox" name="membership:list" value="M"> MSWG  <br> >> <input type="checkbox" name="membership:list" value="V"> VV&A >> TWG   >> <input type="checkbox" name="membership:list" value="T"> VV&A >> TST   >> <input type="checkbox" name="membership:list" value="I"> MSTWG   >> >> >> You get always a list, no matter if there is one or any checkbox >> checked. If there is no checkbox checked, you do not get anything at >> all! So you might have to look for it (or use a default). >> >> You should avoid using <dtml-var> in SQL Methods. Instead use >> <dtml-sqlvar> since this quoutes correctly. Also <dtml-var ... sql_quote> >> can be used. If you dont do so, you probably open a security hole. >> >> Regards >> Tino >> >> >> --On Freitag, 10. August 2001 11:53 -0400 Todd Loomis <tloomis(a)dmso.mil> >> wrote: >> >>> All: >>> >>> I have a set of check boxes that can be checked if the person is a member. >>> My problem is if I pick more than one membership nothing goes into the >>> database. So when bring the record up to view or edit I get no boxes >>> checked even if they should be, here's my codes: >>> >>> Form: >>> <input type="checkbox" name="membership" value="D"> DMSO   >>> <input type="checkbox" name="membership" value="A"> AMG   >>> <input type="checkbox" name="membership" value="E"> EXCIMS   >>> <input type="checkbox" name="membership" value="M"> MSWG  <br> >>> <input type="checkbox" name="membership" value="V"> VV&A TWG   >>> <input type="checkbox" name="membership" value="T"> VV&A TST   >>> <input type="checkbox" name="membership" value="I"> MSTWG   >>> >>> SQL: >>> <dtml-var membership type="string"> >>> >>> Todd >>> >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> Todd Loomis >>> Web Developer (SAIC) >>> Defense Modeling & Simulation Office >>> 1901 N. Beauregard Street, Suite 500 >>> Alexandria, VA 22311 >>> Office: 703.824.3407 Fax: 703.379.3778 >>> tloomis(a)dmso.mil >>> >>> >>> >>> _______________________________________________ >>> Zope maillist - Zope(a)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 ) >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Todd Loomis > Web Developer (SAIC) > Defense Modeling & Simulation Office > 1901 N. Beauregard Street, Suite 500 > Alexandria, VA 22311 > Office: 703.824.3407 Fax: 703.379.3778 > tloomis(a)dmso.mil > >

1 0

RE: [Zope] Checkbox and SQL Method
by CHOY,CHARLENE (HP-Boise,ex1) 10 Aug '01

10 Aug '01

Hi Tino and Eric, Thanks for all your help =). I have solved my problem. I implemented my application with the "saver" that Tino suggested and it worked ^_^. Have a nice day! -Charlene -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Friday, August 10, 2001 3:57 AM To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail); 'eric(a)walstads.net' Subject: RE: [Zope] Checkbox and SQL Method 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(a)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(a)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 )

1 0

Re: [Zope] ZMySQLDA
by Stephan Goeldi 10 Aug '01

10 Aug '01

>From: Andy Dustman <andy(a)dustman.net> > >MySQL-python/MySQLdb still needs to be compiled. Do this with: > >$ python setup.py build ># python setup.py install There is no setup.py in my Zope tree It seems to me, that there are source and binaries, and that one has to guess himself, if it has to be compiled or not. Access to mySQL works now from Zope, so I think I loaded the binary. The outdated stuff in the Products section of www.zope.org is no good marketing for a content management system. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1

RE: [Zope] Checkbox form data storage was (Help with expr)
by Eric Walstad 10 Aug '01

10 Aug '01

Hi Todd, I'm moving this over to the mailing list in case other's want to join in fun :) Does your database table have *one* string field named "membership" or are there many boolean fields that represent the different memberships that each user record can have? Depending on that answer, you will need to use a different method to store the checkbox data in your database. When your form is submitted, Zope will interpret your check boxes as a list of string values. You can verify this by posting your form to a DTML method that includes: <dtml-var REQUEST> and looking at the form variables. That list represents the items checked in your form. In your ZSQL Method you can use the <dtml-sqlgroup> , <dtml-sqlvar> and <dtml-sqltest> tags to dynamically build your SQL string. Have a look at the "Passing Parameters to Scripts" and "Dynamic SQL Queries" sections of the Zope Book. There are a lot of great examples there. Good luck, Eric. > -----Original Message----- > From: Todd Loomis [mailto:tloomis@dmso.mil] > Sent: Friday, August 10, 2001 8:45 AM > To: eric(a)walstads.net > Subject: RE: [Zope] Help with expr > > > Eric: > > I have a set of check boxes that can be checked if the person is > a member. > My problem is if I pick more than one membership nothing goes into the > database. So when bring the record up to view or edit I get no boxes > checked even if they should be, here's my codes: > > Form: > <input type="checkbox" name="membership" value="D"> DMSO   > <input type="checkbox" name="membership" value="A"> AMG   > <input type="checkbox" name="membership" value="E"> EXCIMS   > <input type="checkbox" name="membership" value="M"> MSWG  <br> > <input type="checkbox" name="membership" value="V"> VV&A > TWG   > <input type="checkbox" name="membership" value="T"> VV&A > TST   > <input type="checkbox" name="membership" value="I"> MSTWG   > > SQL: > <dtml-var membership type="string"> > > Todd > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Todd Loomis > Web Developer (SAIC) > Defense Modeling & Simulation Office > 1901 N. Beauregard Street, Suite 500 > Alexandria, VA 22311 > Office: 703.824.3407 Fax: 703.379.3778 > tloomis(a)dmso.mil > >

1 0

Backup Zope once a day
by Gitte Wange 10 Aug '01

10 Aug '01

Hello, I have created a little cron script that creates a daily tarball from my entire Zope dir. But in order to do this I must stop Zope - create the tarball and then start Zope again. I now that Zope will only be down for about 2 minutes or so but customers don't like that :-) So I was wondering if there was a way to do a daily backup without stopping Zope ? Regards, -- Gitte Wange Jensen Sys Admin, Developer and a lot more MMmanager.org Aps, Denmark Phone: +45 29 72 79 72 Email: gitte(a)mmmanager.org Web: www.mmmanager.org Quote of the day: Chris McDonough: "We should kill two birds with one stone with this..." Ethan Fremen: "Oh, believe me, we've got LOTS of birds lined up to die..." - Ethan Fremen, f2f conversation with chrism, 2001/04/13

4 5

ProxyPass with MS ISA
by Johan Carlsson [Torped] 10 Aug '01

10 Aug '01

Hi folks, Does anybody run Microsoft ISA Server together with Zope? I'm currently looking for the possibility to use ISA for passing request to a Zope server on the inside of a firewall. My first choice was to use Apache and ProxyPass, but unfortunately I am limited to use MS ISA or MS IIS. MyConfig: I just want to replace Apache with MS-ISA if possible INTERNET | +----------------------------------------------------------------------+ | Apache + mod_proxy | ProxyPass / http://x.x.x.x:port | ProxyPassReverse / http://x.x.x.x:port/ +----------------------------------------------------------------------+ | +----------------------------------------------------------------------+ | Firewall +----------------------------------------------------------------------+ | +----------------------------------------------------------------------+ | Zope Server x.x.x.x:port +----------------------------------------------------------------------+ | +----------------------------------------------------------------------+ | Internal Databases +----------------------------------------------------------------------+ Any other ideas how to set this up are welcome. Best Regards, Johan Carlsson www.torped.se

2 3

Re: [Zope] Interfacing to Zope
by Oleg Broytmann 10 Aug '01

10 Aug '01

Please continu to answer to the mailing list. Messages will be archived and indexed by search engines. On Fri, 10 Aug 2001, Robert Frank wrote: > > If you compiled Zope with PCGI, you also will have UNIX domain socket in > > var directory. This socket is used for PCGI protocol. > Yes, I know. Unfortunately, Pike (Roxen's language) can't (yet) handle > these, which is why I want to use TCP based sockets. > If I understood you correctly, then it should make no difference for the > ZServer whether it is a domain socket or a TCP socket? Alas, current PCGI implementation can only use UNIX domain sockets on UNIX (patches accepted). On Windows TCP/IP is used. > (According to the docs, -F followed by a path and file name will use a > domain socket, -F followed by a number will use a TCP socket) -F is only about FastCGI, not PCGI. Yes, FastCGI can use both TCP/IP and UNIX domain sockets. Oleg. ---- Oleg Broytmann http://phd.pp.ru/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

1 0

Backup the Database.
by Jason C. Leach 10 Aug '01

10 Aug '01

hi, To backup the database, do I just need Data.fs? Thanks, j. -- ...................... ..... Jason C. Leach ..

3 3

Interfacing to Zope
by Robert Frank 10 Aug '01

10 Aug '01

Hi, I haven't quite given up. It just has to be possible, PCGI and fastcgi can do it, so why not I? I've rechecked the protocol and am quit sure that I've gotting it right. While checking, I noticed that PCGI (the wrapper, actually) will start a python process called pcgi_publisher.py. Is this necessary? As I understood the documentation, when using the ZServer for listening on a (TCP) port, this is all it needs. Does ZServer on unix work with TCP sockets or only with domain sockets? If I start Zope with' python z2.py -X -F 1234 -D', then it will listen on the port 1234, but it will never spew anything out ... Does anyone have a clue as to what happens (which processes are started and how they interact) if you use PCGI? I just find it hard to believe that there is no documentaion on this subject ... Robert ------------------------------------- Institut fuer Informatik tel +41 (0)61 267 14 66 Universitaet Basel fax. +41 (0)61 267 14 61 Robert Frank Klingelbergstrasse 50 Robert.Frank(a)unibas.ch (NeXT,MIME mail ok) CH-4056 Basel (remove any no_spam_ from my return address) Switzerland http://www.ifi.unibas.ch/~frank

2 1

Re: [Zope] ZMySQLDA
by Stephan Goeldi 10 Aug '01

10 Aug '01

>From: "js(a)aixtraware.de <Joachim Schmitz>" > >You should use the newest version which you get here: > > http://sourceforge.net/projects/mysql-python > Thank you very much. This should be mentioned at http://www.zope.org/Members/MikeP/ZMySQLDA There only is version 1.1.3 available without link. I now installed: ZMySQLDA-2.0.7.linux-i686.tar.gz and MySQL-python-0.9.0.linux-i686.tar.gz extracted them from my zope root. Is there anything more to do? Compiling etc.? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1