- Zope - Zope lists

Bug in Z ODBC DA?
by Martijn Faassen 20 Apr '99

20 Apr '99

Hi there, My voyage through bug land seems to continue: I've been using the Z ODBC database adaptor to speak SQL to an Access database on the NT server that Zope is running on here. This all works fine for SELECT and INSERT statements. Now I've gotten to DELETE statements, however. I'm trying to delete a record from a table called 'entiteit' (entity). Each record in that table has a unique 'entiteit_id'. Records in the table 'entiteit' can be pointed to by records in the table 'bestelling' (orders), by referring to this 'entiteit_id'. I've established a referential integrity relationship in Access between the two tables, to ensure that records in 'entiteit' can't be removed if their entiteit_id is still in use by records in the 'bestelling' table. Whenever I try to DELETE a record (by entiteit_id) in the entiteit table, I get an ODBC error message in the Zope traceback, saying basically (I think) that this violates referential integrity. This is odd, as I'm trying to delete records that *aren't* referred to from anywhere (the only table that *can* refer to entiteit is bestelling anyway). It gives this error message for any table. (traceback at the end) In order to try to rule out it was an ODBC problem in itself, or a fault of mine in making this Access table, I've created a small Python script that uses the Python DB API to talk to ODBC. This script can delete records just fine, unless they're referred to from the bestelling table. ODBC therefore seems to be okay. Unless someone can give a reasonable explanation of why this happens, this points to a bug in the Zope ODBC database adaptor. Anybody have similar experiences? Apologies for my Dutch here :) Regards, Martijn The promised traceback:

1 1

previous question
by Tom Deprez 20 Apr '99

20 Apr '99

Hi, Part 1 (concerning: 'this is not a query') of previous question is already answered by several of you! Thanks! Anybody ideas of the other problems I encountered? Thanks, Tom.

1 0

DTML Documents vs. DHTM Methods
by Johan Carlsson 20 Apr '99

20 Apr '99

Where can I find a great explanation of the difference between DTML Methods and DTHL Documents? //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

4 4

(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