- Zope - Zope lists

(no subject)
by Tom Deprez 20 Apr '99

20 Apr '99

Hi all, I use PostGreSQL (if you need to know) 1) the SQL Method : INSERT INTO list VALUES ( , ,) seems to work fine (new data is entered in database) It only gives the result text of 'this was not a query'... how comes? 2) I've made DTML Document with : <FORM METHOD="post" ACTION="???????"> <TABLE BORDER="0"> <TR> <TD>New Item:</TD> <TD><INPUT NAME="item_string"></TD> </TR> <TR> <TD>Vendor:</TD> <TD><INPUT NAME="vendor_string"></TD> </TR> <TR> <TD>Quantity:</TD> <TD><INPUT NAME="quantity_int"></TD> </TR> </TABLE> <INPUT TYPE="submit"> </FORM> 3) How do I glue these together? So that when pressing submit the values are inserted in the database?? I've putted the SQL Method in the ACTION, but this doesn't seem to work. 4) Actualy It should return a new page with inserting of ... succesfull (inserting ... was not successfull)... how can this be done? 5) Instead of letting the user enter the vendorname (<INPUT NAME="vendor_string">), I would like to give him a combobox (<SELECT> NAME...). This combobox should be filled with the result of a query to all vendors in the database. How can this be done? i.e. Putting the result set of a query in a select box. 6) If I 5 can be done, the insert SQL should slightly change : INSERT INTO list VALUES ( , ,) with the vendorcode_int comming from another sql : select vendorcode from vendors WHERE  How can this be done??? Help, can somebody help me with these? Really thanks in advance! Tom.

1 0

Re: [Zope] SQL INSERT
by Gilles.Lavaux 20 Apr '99

20 Apr '99

Hello, Don't worry to much, I got the same message. But the insert is done well. It seams to me that if you use something else than a select SQL(update ot insert in my experience) you get this message. Gilles >Hi, > >I use Zope with PostGreSQL > >I've added a ZSQL Method and just want to test it > >INSERT INTO list >VALUES ( > , > ,) > >But I always get, this was not a query!

1 0

SQL INSERT
by Tom Deprez 20 Apr '99

20 Apr '99

Hi, I use Zope with PostGreSQL I've added a ZSQL Method and just want to test it INSERT INTO list VALUES ( , ,) But I always get, this was not a query! As test, I entered the values: Horse, 100, 60 I don't understand? My query seems to be right... TIA, Tom.

1 0

RE: [Zope] Checkboxes in dtml and external methods
by Rob Page 20 Apr '99

20 Apr '99

Hi Phil: > I have a DTML form ahich looks, simplified version, like this: > > <form action="receiver" method=post> > <input type=checkbox name=cb>option 1 > <input type=checkbox name=cb>option 2 > <input type=checkbox name=cb>option 3 > <input type=checkbox name=cb>option 4 > <input type=checkbox name=cb>option 5 > > <input type=submit name=ok value=ok> > </form> > > when this form is submitted I need, in 'receiver', to pass > the multiple > values of 'cb' through to an external method. Hmm. I think your're after the behavior of a multiple select LIST (i.e., SELECT) with the UI of a checkbox. I don't think that will work. If you're really after the select use that. Otherwise I think you'll have to change the name of each checkbox input widget to get visibility of each on individually on the ACTION document. --Rob

4 3

searching back through the enclosing documents.
by Anthony Baxter 20 Apr '99

20 Apr '99

If I have a number of DTML documents including each other with , then inside document1 referring to document2, and so on, how can I, from the innermost document, walk back up the calling chain of documents, looking at each on the way? Using acquisition just gives me the chain of folders from the innermost document back up to the top - not what I want. Thanks, Anthony

1 0

Checkboxes in dtml and external methods
by Phil Harris 20 Apr '99

20 Apr '99

Hi all I have a DTML form ahich looks, simplified version, like this: <form action="receiver" method=post> <input type=checkbox name=cb>option 1 <input type=checkbox name=cb>option 2 <input type=checkbox name=cb>option 3 <input type=checkbox name=cb>option 4 <input type=checkbox name=cb>option 5 <input type=submit name=ok value=ok> </form> when this form is submitted I need, in 'receiver', to pass the multiple values of 'cb' through to an external method. My question is , How? I've tried def'ing the function to look like this def f(self, cb=cb): for a in cb: print a but this only tells me that cb is a selection, hmm. Any ideas? TIA

1 0

Tree questions
by David Ascher 20 Apr '99

20 Apr '99

Currently I'm using a tree tag which looks like:  <A HREF="">  </A>  (stolen from the ZDP FAQ). I'd like to modify it so that the root of the tree is fixed (as in the help system), and so that only folders which do not have the 'hidden' property set are shown. Any hints? --david ascher

2 5

Re: [Zope] Funny problem with DTML, please help!
by pan＠aster.net 20 Apr '99

20 Apr '99

I managed to get it to work. It seems that the variable first mentioned in  gives an error when used in:    and not in    The rest of the variables can be incremented without problems. This is really strange?! I have it now working as:  Calculate the vote percentage                 Now display the results  <h2> Total :  votes</h2> <ul> <li>Yes :  votes (%)</li> <li>No :  votes (%)</li> </ul> pan(a)aster.net writes: > Hi guys, > > I hope someone can help me with this one, because it's almost driving > me crazy :-) > > The following code fails with an error for count_yes: > >  > Calculate the vote percentage >  >  >  > >  >  >  >  >  >  >  >  >  >  >  > >  > Now display the results >  > > <h2> Total :  votes</h2> > > <ul> > <li>Yes :  votes (%)</li> > <li>No :  votes (%)</li> > </ul> > > > When I change > >  > > to > >  > > it works as expected, no errors, but that's not what I want :-( I've > tried, superstitiously, to change count_yes to several other things, > but no luck. It always gives me an error for the vairable I > substitute for count_yes. The strangest thing is that the same code > works for count_no and count_all ?!? > > Any ideas? > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

1 0

Tree, followup
by David Ascher 20 Apr '99

20 Apr '99

Given the following tree tag:   <A HREF="Code/">  </A>   How can one: 1) avoid the + showing up for folders which contain only hidden folders? 2) have the sort do a case-insensitive sort (one of my original questions still lives: 3) keep the tree always showing the entire hierarchy ) Thanks. --david

2 1

Reverse Acquisition and getPath from object
by Johan Carlsson 20 Apr '99

20 Apr '99

Hi, I'm trying to figure out how to do reverse acquisition (in other words to find the first occurrence of a certain object below a particular object. And then how to get that (or any objects) path/URL. Both DTML or Python solutions would do. Best Regards, Johan Carlsson torped johan carlsson birkagatan 9 113 36 stockholm telefon 08-32 31 23 mobil 070-558 25 24 fax 08-32 89 47 johanc(a)torped.se

2 1