October 2000 - Zope - Zope lists

Problems with sequence-item
by Taco Scargo 23 Oct '00

23 Oct '00

I get errors when sequence-item is being called to list the contents of a folder E.g. <dtml-in "(1,2,3)" reverse> <dtml-var sequence-item> </dtml-in> correctly outputs 3 2 1 When I do <dtml-in "folder.objectValues()"> <dtml-var id> </dtml-in> it correctly outputs all ids in the folder. But <dtml-in "folder.objectValues()"> <dtml-var sequence-item> </dtml-in> will fail with an error Error Type: AttributeError Error Value: __call__ What am I doing wrong ? Thanks, Taco Scargo ________________________________________________________ 1stUp.com - Free the Web Get your free Internet access at http://www.1stUp.com

4 7

Re: [Zope] Problems with mysql and sql methode
by Oliver Bleutgen 23 Oct '00

23 Oct '00

> At 09:41 23/10/00, you wrote: >>Hmm, I'm not very clear about differences between handling of (table, >>column) names >>in sql-databases, but postgres IS case sensitive (in some sense). > Well I'm confused !!! > I have two databases , one MySQL (3.23.25) one PostgreSQL (7.01), both > with > the same schema. Both have a table 'artist'. The following SQL Method > (Zope > 2.2.1) works with both > select a.artist_id,a.known_name,a.initials >>from artist a > where <dtml-sqltest surname type=string> > Change this to > select a.artist_id,a.known_name,a.initials >>from ARTIST a > where <dtml-sqltest surname type=string> > it still works with PostgreSQL but with MySQL I get > "Table 'tunedb.ARTIST' doesn't exist" > Change this to > select a.artist_id,a.known_name,a.initials >>from ARTIST a > where <dtml-sqltest SURNAME type=string> > Then it still works with PostgreSQL, provided you also change the argument > to the SQL Method from surname to SURNAME. > When you click on the Test tab of an SQL Method it shows the SQL generated > and you can see, in the above example, that the uppercase words are passed > through unchanged to the database > viz. > select a.artist_id,a.known_name,a.initials from ARTIST a where SURNAME = > 'Molloy' > In what circumstances is PostgreSQL case-sensitive ? First, sorry for my (nearly) full-quote, but I think it makes this discussion more readable. To your question, from my testing (I did this with column names only, but I suspect the same behavior for table-names), postgres is case sensitive, but - as I wrote - in another sense. If you don't quote the column-names, they are converted to or interpreted as lowercased names. _But_ if the real name of the table/column is _uppercase_, it will not be matched by this lowercased name - in this sense postgres is case-sensitive. Postgres needs quoted names in sql-queries to respect capitalization (sp?) - and I couldn't <dtml-sqltest ...> get to generate them. This was a major problem for me, because I had to work with a bunch of tables which were exported from foxpro and dbase, and their names were uppercased in the process. cheers, oliver

1 0

ZCatalog question
by olpa＠sybcom.de 23 Oct '00

23 Oct '00

Hi Folks, i have a ZCatalog over a bunch of items with attributes A and B. Now I want to search all elements with attribute A set to value 1 and AT THE SAME TIME with attribute B set to value 2. So a sort of AND combination with two different attributes. How to do ? Regards oliver --- "All language designers are arrogant. Goes with the territory..." (By Larry Wall) --- Oliver Pabst .-------------------------. mailto:olpa@sybcom.de : : phone :+49 681 56600600 : project department : SYBCOM GmbH fax :+49 681 56600660 : : http://www.sybcom.de

1 0

Re: [Zope] Problems with mysql and sql methode
by Oliver Bleutgen 23 Oct '00

23 Oct '00

> MySQL is case-sensitive over table names, so MERCHANTPAYMENT is not the > same as merchantpayment. > Other databases (Postgresql, Informix) are not. > Perhaps the Access/ODBC interface hides the case-sensitivity while the > direct ZMySQLDA does not ? Hmm, I'm not very clear about differences between handling of (table, column) names in sql-databases, but postgres IS case sensitive (in some sense). Few days ago I wrote to messages to this list describing my problems with postgres and capitals in column-names. The handling of these will render <dtml-sqltest ..> useless, because it doesn't quote the name of the vars. I that case postgres will not respect capital letter (will turn them lowercase) but also won't find the column which name is written uppercase. I think it would be usefull to collect the behaviour of different databases and try to find a solution which will work with all of them. The solution we have now clearly doesn't do that. cheers, oliver

2 1

Working with versions
by brocken22＠gmx.de 23 Oct '00

23 Oct '00

Hallo, I've got a question concerning versions. The working with versions in the management screen is obvious to me, but what about hiding the management-screen and working with them. I want to add ZClasses programmatically but some users should only be able to add them after a Controller has checked that everything is o.k. What are the right methods to use??? -- Sent through GMX FreeMail - http://www.gmx.net

2 1

RE: [Zope] NEWBIE: assign next free ID automatically
by Max Møller Rasmussen 23 Oct '00

23 Oct '00

This is untested, but an idea: <dtml-in "objectValues()[:-1]" sort=id reverse> <dtml-call "REQUEST.set('new_id', id+1)"> <dtml-var new_id> It is still subject to failure if 2 or more processes are writing an article in the same time. Furthermore it has to find and sort all the items in the folder. That could take a long time if there are lots of them. Maybe you should somehow insert a dtml-try until you succed in writing the article. Another aproach would be to have the folder with your articles have a property "lastID" and let "nexID" be a method that automatically would increment lastID end return it. Maybe it is possible to lock the lastID property?? >From: Patrick Koetter [mailto:p@state-of-mind.de] >What is it that I want to do? >I want to evaluate the highest ID (all are 'int') within the folder and >assign the next highest. >I'm sure this is easy to you...

1 0

HELP! Permissions problem, ZClass
by Eric Walstad 22 Oct '00

22 Oct '00

Help, pls! I have a ZClass that is functioning beautifully if I am logged in, but the anonymous user keeps getting prompted for a password. The problem occurs when my DTML method trys to create a new instance of the ZClass. I tried giving that DTML method a Proxy of "Manager" but that isn't helping. Any pointers? Thanks, Eric. Here's the traceback: Zope Error Zope has encountered an error while publishing this resource. Unauthorized You are not authorized to access CNewsItem. Traceback (innermost last): File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: buildNews) File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: buildNews) File /usr/local/Zope/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: buildNews) File /usr/local/Zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: buildNews) File /usr/local/Zope/lib/python/DocumentTemplate/DT_With.py, line 146, in render (Object: manage_addProduct['NewsItem']) File /usr/local/Zope/lib/python/DocumentTemplate/DT_Util.py, line 337, in eval (Object: CNewsItem_add(_.None, _, NoRedir=1)) (Info: _) File <string>, line 0, in ? File /usr/local/Zope/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: CNewsItem_add) File /usr/local/Zope/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: CNewsItem_add) File /usr/local/Zope/lib/python/DocumentTemplate/DT_With.py, line 133, in render (Object: CNewsItem.createInObjectManager(REQUEST['id'], REQUEST)) File /usr/local/Zope/lib/python/DocumentTemplate/DT_Util.py, line 331, in eval (Object: CNewsItem.createInObjectManager(REQUEST['id'], REQUEST)) (Info: CNewsItem) File /usr/local/Zope/lib/python/OFS/DTMLMethod.py, line 194, in validate (Object: buildNews) File /usr/local/Zope/lib/python/AccessControl/SecurityManager.py, line 139, in validate File /usr/local/Zope/lib/python/AccessControl/ZopeSecurityPolicy.py, line 209, in validate Unauthorized: (see above)

3 2

Creating Object
by Salvatore DIDIO 22 Oct '00

22 Oct '00

Hello, I am new to Zope I've just installed Zope on Linux. I just can't create any object !. I receive the following message : the object can not be owned by the superuser (line 217 in file Owned.py) Could someone help me ? Thank you very much

5 4

Roxen & Zope, not working
by Adrian Madrid 22 Oct '00

22 Oct '00

I'm having problems running Zope on top of Roxen on a Win2k machine. They both run just fine separate but I can't make it work together. I followed the instructions from http://www.zope.org/Members/magnus/Roxen but I never got it to see the first page. Here are the tracebacks I get: * This is what I get when I try mysite.com: Roxen version: Roxen/2.1.135 NTPike version: Pike v7.0 release 230Requested URL: /Error: Unknown extension .cgimodules/scripting/cgi.pike (version 2.47):547: create(".cgi")modules/scripting/cgi.pike: NTOpenCommand()modules/scripting/cgi.pike (version 2.47):812: create(RequestID())modules/scripting/cgi.pike: CGIScript()modules/scripting/cgi.pike (version 2.47):959: find_file("Zope.cgi",RequestID())/roxen/server/base_server/configuration.pike (version 1.377):1144: low_get_file(RequestID(),0)/roxen/server/base_server/configuration.pike (version 1.377):1334: get_file(RequestID(),0,0)modules/directories/indexfiles.pike (version 1.16):50: parse_directory(RequestID())/roxen/server/base_server/configuration.pike (version 1.377):1214: low_get_file(RequestID(),0)/roxen/server/base_server/configuration.pike (version 1.377):1334: get_file(RequestID(),0,0)/roxen/server/base_server/configuration.pike (version 1.377):1309: handle_request(RequestID())/roxen/server/protocols/http.pike (version 1.277):1951: handle_request()/roxen/server/protocols/http.pike (version 1.277):2175: got_data(0,"GET / HTTP/1.1\r\n"+[317]+": Keep-Alive\r\n\r\n")pike/lib/pike/modules/Stdio.pmod/module.pmod (version 1.83):308: __stdio_read_callback()Request data:GET / HTTP/1.1Accept: application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-comet, */*Accept-Language: en-usAccept-Encoding: gzip, deflateUser-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)Host: 128.187.66.215:7070Connection: Keep-Alive� * And this is what I get when I try mysite.com/Zope.cgi: Roxen version: Roxen/2.1.135 NTPike version: Pike v7.0 release 230Requested URL: /Zope.cgiError: Unknown extension .cgimodules/scripting/cgi.pike (version 2.47):547: create(".cgi")modules/scripting/cgi.pike: NTOpenCommand()modules/scripting/cgi.pike (version 2.47):812: create(RequestID())modules/scripting/cgi.pike: CGIScript()modules/scripting/cgi.pike (version 2.47):959: find_file("Zope.cgi",RequestID())/roxen/server/base_server/configuration.pike (version 1.377):1144: low_get_file(RequestID(),0)/roxen/server/base_server/configuration.pike (version 1.377):1334: get_file(RequestID(),0,0)/roxen/server/base_server/configuration.pike (version 1.377):1309: handle_request(RequestID())/roxen/server/protocols/http.pike (version 1.277):1951: handle_request()/roxen/server/protocols/http.pike (version 1.277):2175: got_data(0,"GET /Zope.cgi HT"+[325]+": Keep-Alive\r\n\r\n")pike/lib/pike/modules/Stdio.pmod/module.pmod (version 1.83):308: __stdio_read_callback()Request data:GET /Zope.cgi HTTP/1.1Accept: application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-comet, */*Accept-Language: en-usAccept-Encoding: gzip, deflateUser-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows 98)Host: 128.187.66.215:7070Connection: Keep-Alive� Any ideas? Anybody running both Zope and Roxen on a Windows machine? Adrian Madrid --------------------------------- Do You Yahoo!? Yahoo! Messenger - Talk while you surf! It's FREE.

2 1

Help creating Object
by Salvatore DIDIO 22 Oct '00

22 Oct '00

Hello, In the manage folder I can't create any object. I got a message telling that the object can not be owned by the superuser. (line 217 in file Owned.py). Can someone help me ? Thanks

1 0