- Zope - Zope lists

RE: [Zope] what's the id of the root object?
by Shaw, Howard 20 Apr '99

20 Apr '99

Go to the root folder. Go to the export tab, leave the blank empty, and press export. It will create a file '.bbe' containing everything in your database. YMMV. Howard C. Shaw III Programmer/SysAdmin St. Thomas High School > ---------- > From: David Ascher[SMTP:da@ski.org] > Sent: Tuesday, April 20, 1999 12:31 PM > To: The Zope Group > Subject: [Zope] what's the id of the root object? > > I don't know how to refer to the id of the root of my Zope tree. The > management tree interface doesn't give it a name (the folder in the > top-left corner is unlabeled). I'd like to export my entire tree into > a > .bbe file, but I don't know how to refer to the root object. > > --david > > > _______________________________________________ > 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

publishing objects
by Scott Lewis 20 Apr '99

20 Apr '99

hi folks, i've got some beginner questions about zope. i spent a fair amount of time with various documentation, but couldn't find the answers. first, the specific question. the docs talk about publishing objects, with zope translating URLs to method calls. i get the impression that i can call arbitrary Python objects through zope, but i can't get it to work. i've tried it with IIS and the included HTTP server. let's say i want to call somemethod() in test.py. the docs say that http://localhost:9673/test/somemethod will do it. but where should test.py live? what's the home document directory of the builtin HTTP server? and if i use IIS, how do i get it to use zope. by calling http://localhost:9673/manage, i can access the zope ODB, but not python modules outside the database. is this possible? using IIS, i could access ODB objects via http://localhost/zope/cgi/zope.exe/manage, but again, how do i get to the python objects? do the modules have to exist in the zope ODB? if so, how do i import them? i know about external methods, but it seems cumbersome to create them, method by method, object by object. what i want to do is create a web application for reading and writing information from a database (a registry of trainers and trainings). i have begun developing this using ASP, IIS, and SQL Server. i'm always looking for non-microsoft alternatives. it looks like i can develop business objects in python that model the business rules, then use zope to access the objects and control the presentation. in another language, those business objects would encapsulate the database access. i know zope has database adapters, but if i don't already have data in a relational database, do i even need to use one. could the application be implemented solely with the object database? i'm used to relational databases, so when i start with new projects i start with the database. but maybe the zope ODB provides what i need... any ideas? thanks in advance for your time. -scott ----- Scott Lewis Baltic Avenue Productions csl(a)balticave.com

3 2

Funny problem with DTML, please help!
by pan＠aster.net 20 Apr '99

20 Apr '99

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?

2 1

what's the id of the root object?
by David Ascher 20 Apr '99

20 Apr '99

I don't know how to refer to the id of the root of my Zope tree. The management tree interface doesn't give it a name (the folder in the top-left corner is unlabeled). I'd like to export my entire tree into a .bbe file, but I don't know how to refer to the root object. --david

1 0

RE: [Zope] SQL Queries and Key Errors
by Shaw, Howard 20 Apr '99

20 Apr '99

Thank you. That worked perfectly. Howard C. Shaw III Programmer/SysAdmin St. Thomas High School > ---------- > From: Jordan B. Baker[SMTP:jbb@spyderlab.com] > Sent: Tuesday, April 20, 1999 11:54 AM > To: Shaw, Howard > Cc: 'Zope(a)zope.org' > Subject: Re: [Zope] SQL Queries and Key Errors > > On Tue, 20 Apr 1999, Shaw, Howard wrote: > > > This same query works perfectly under myadmin2.0 against the same > > database. Any ideas why it fails here? I thought it might be because > > 'valid' was a reserved word, but I seriously doubt that 'vald' is. > > > > Error, exceptions.KeyError: unhandled > > > > SQL used: > > > > SELECT (PASSWORD('testing')=password) as vald > > FROM researchers > > WHERE uid='test' > > This seems to be a bug somewhere in either the MySQL driver of the > Zope > glue. Try CONCAT(password-crap) to cast the result to a string > automatically. > > Hopefully this will help you. :) > > ------- > Jordan B. Baker -- jbb(a)spyderlab.com > weaving the web @ http://www.spyderlab.com > > > > _______________________________________________ > 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

SQL Queries and Key Errors
by Shaw, Howard 20 Apr '99

20 Apr '99

This same query works perfectly under myadmin2.0 against the same database. Any ideas why it fails here? I thought it might be because 'valid' was a reserved word, but I seriously doubt that 'vald' is. Error, exceptions.KeyError: unhandled SQL used: SELECT (PASSWORD('testing')=password) as vald FROM researchers WHERE uid='test' Traceback (innermost last): File lib/python/ZPublisher/Publish.py, line 877, in publish_module File lib/python/ZPublisher/Publish.py, line 590, in publish (Info: /genus/uber/checkpassdb/manage_test) File lib/python/Shared/DC/ZRDB/DA.py, line 305, in manage_test (Object: CopySource) File lib/python/Shared/DC/ZRDB/DA.py, line 286, in manage_test (Object: CopySource) File lib/python/Shared/DC/ZRDB/DA.py, line 390, in __call__ (Object: CopySource) File /home/zope/lib/python/Products/ZMySQLDA/db.py, line 185, in query KeyError: (see above) Howard C. Shaw III Programmer/SysAdmin St. Thomas High School

2 1

RE: [Zope] (no subject)
by Rob Page 20 Apr '99

20 Apr '99

> seems to work fine (new data is entered in database) It only > gives the > result text of 'this was not a query'... how comes? Probably because the INSERT returns no data. I don't know if this is a feature/function of the Database Adapter or the underlying Python database connection code. The MS Access lash-up returns This query returned no data. I suppose that, _technically_, an INSERT isn't a query (a question)... ?? :^) > 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? Create a DTML document called drRecordInsert and make it the ACTION target of your form listed above. In dtRecordInsert do something like:   <P>Record inserted.</P>  <OPTION VALUE=""></OPTION>  </SELECT> > 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  The original sql wouldn't change -- the vendor_code_int would still come in with the REQUEST from the form! Hope this helps! -Rob

1 0

RE: [Zope] (no subject)
by Shaw, Howard 20 Apr '99

20 Apr '99

See my responses below. Howard C. Shaw III Programmer/SysAdmin St. Thomas High School > ---------- > From: Tom Deprez[SMTP:Tom.Deprez@uz.kuleuven.ac.be] > Sent: Tuesday, April 20, 1999 8:39 AM > To: zope(a)zope.org > Subject: [Zope] (no subject) > > 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? > This is not a problem. All it means is that it did not result in a query object being returned. (I.e. there were no 'results') > 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. > You need to have the form names the same as the variables in your table, or use another DTML page to parse the results. That is, your vendor_string needs to be a vendor_int. See my response below to accomplish this. > 4) Actualy It should return a new page with inserting of ... > succesfull > (inserting ... was not successfull)... how can this be done? > Can't help you here, except to say that if you use a second DTML page to call the SQL query, it can provide a customized response as well. > 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. > Create an SQL query 'venderlistdb' SELECT vendorname, vendorid FROM vendors ORDER by vendorname and in the DTML document with the form <select name=vendorcode_int size=5>  <option value=>  </select> > 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  > Don't need this extra select. With the snippet above, you show them the name, but you get the code. > How can this be done??? > > Help, can somebody help me with these? > > Really thanks in advance! > > Tom. > > > _______________________________________________ > 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

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