- Zope - Zope lists

1000-record limit?
by Christopher J. Kucera 26 Sep '00

26 Sep '00

Greetings! I know I saw this discussed a long time ago, but I completely failed to find the thread anywhere, so here goes . . . We're running a somewhat older release of Zope with ZOracleDA, and we've run up against a 1000-record limit when returning data for reports, etc. I know that this is intended behavior (careful_range in DT_Util.py), but I'm wondering what the reasoning is, and if I should be even considering playing around with this (I'm assuming it was put in there for *some* reason . . . :) Thanks in advance for your help! -CJ

2 2

ZClass + ZSQLmethods bug in 2.2.2?
by Alexander Schonfeld 26 Sep '00

26 Sep '00

Hi, I've seen lots of ZSQLmethods patches and such and tried a few of them under 2.1.6, but thought upgrading to 2.2.2 would fix this problem. It didn't. Basically: 1. Create a ZClass 2. Inside create a DTML method and ZSQLmethod 3. from the dtml method call the ZSQLmethod 4. do a <dtml-with "myClassInstanceObj"> <dtml-var myMethod> </dtml-with> 5. get a Unauthorized error no matter what the access privileges are set to This is with the "MySQLda". Is there a newer MySQLda somewhere that fixes this? Or some patch (that works with 2.2.2???)?! Running 2.2.2 from source... now with less hair... Sincerely, Alex. ================================ Zope Error Zope has encountered an error while publishing this resource. Unauthorized You are not authorized to access sqlGetValue. Traceback (innermost last): File /Zope-2.2.2/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /Zope-2.2.2/lib/python/ZPublisher/Publish.py, line 187, in publish File /Zope-2.2.2/lib/python/ZPublisher/Publish.py, line 171, in publish File /Zope-2.2.2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: testmeth) File /Zope-2.2.2/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: testmeth) File /Zope-2.2.2/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: testmeth) File /Zope-2.2.2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: testmeth) File /Zope-2.2.2/lib/python/DocumentTemplate/DT_With.py, line 146, in render (Object: testcrp) File /Zope-2.2.2/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: craptest) File /Zope-2.2.2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: craptest) File /Zope-2.2.2/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: sqlGetValue(tableId='Artist',columnId='Name',keyId='3f69016017c39d5da0a1d60d0a98dbed55d46414')) File /Zope-2.2.2/lib/python/DocumentTemplate/DT_Util.py, line 331, in eval (Object: sqlGetValue(tableId='Artist',columnId='Name',keyId='3f69016017c39d5da0a1d60d0a98dbed55d46414')) (Info: sqlGetValue) File /Zope-2.2.2/lib/python/OFS/DTMLMethod.py, line 194, in validate (Object: testmeth) File /Zope-2.2.2/lib/python/AccessControl/SecurityManager.py, line 139, in validate File /Zope-2.2.2/lib/python/AccessControl/ZopeSecurityPolicy.py, line 209, in validate Unauthorized: (see above) 1010011010101001101010100110101010011010 0 Digital Garage　デジタル車庫　:) 1 Alexander Schonfeld 0 alex(a)garage.co.jp - pear - 03-5454-7219 1 http://www.zope.ne.jp/ http://www.garage.co.jp

1 0

Newbie-question on ZCatalog
by Marc Breitenreicher 26 Sep '00

26 Sep '00

Hi, I'm trying to build a Catalog with a report table just as the one on http://classic.zope.org:8080/Collector/tableBrowse?cfDescAndTitle=catalog That's a table with document-title, date and the first 30 words of the document-content. My problem: how can I insert the content into the ZSearch report-file? Is there a simple way just like finding out the document-url ( here it is <dtml-var "catalog.getpath(data_record_id_)"> )? Thanks for your help Marc

1 0

Help needed with namespace
by a.wacknitz＠francotyp.com 26 Sep '00

26 Sep '00

Hello all, after updating to Zope-2.2.0 I have problems with ZSQL methods. It seems as if the namespace of ZSQL methods has changed sind Zope-2.1.x. I cannot access the AUTHENTICATED_USER object anymore - it is not known to ZSQL methods: <dtml-sqlvar AUTHENTICATED_USER> gives an "Missing input variable, AUTHENTICATED_USER" error and <dtml-var "AUTHENTICATED_USER.getUserName()"> gives "error type: NameError error value: AUTHENTICATED_USER" The security mechanism of my application heavily depends on this object! What has happened to the ZSQL methods? I have already updated to Zope-2.2.2 but with no luck so far. Any help is greatly appreciated, Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

personal portal and Palm syncronization
by Brian.Burton＠nlynx.com 26 Sep '00

26 Sep '00

I was building a personal site to weblog my engineering and personal stuff (based on Squishdot and Event Folder), and the thought occurred to me that it would be really neat if I could syncronize my Palm to this personal site. Using the Event Folder, I have a calendar, Squishdot provides the memos, I would need some other product to do the ToDos, and some other product could provided the contact management list. All that would be needed would be a way to sync between the Palm and the Zope site. Any ideas? (Heck, I could even see a company providing this as MyPalmPortal or something like that! Then I would not have to depend on a particular computer to sync my Palm with and I would have a better way of entering memos when I had access to a web browser. Any ideas how the sync would be done?

4 3

Use of the :records variable type and ZSQL methods
by Calvin Parker 26 Sep '00

26 Sep '00

I am trying to take in a form that has multiple records like this: <FORM ACTION=add_records> Field1<INPUT TYPE="text" NAME="testlist.Field1:records:ignore_empty" SIZE="30"> Field2<INPUT TYPE="text" NAME="testlist.Field2:records:ignore_empty" SIZE="30"><br> Field1<INPUT TYPE="text" NAME="testlist.Field1:records:ignore_empty" SIZE="30"> Field2<INPUT TYPE="text" NAME="testlist.Field2:records:ignore_empty" SIZE="30"><br> Field1<INPUT TYPE="text" NAME="testlist.Field1:records:ignore_empty" SIZE="30"> Field2<INPUT TYPE="text" NAME="testlist.Field2:records:ignore_empty" SIZE="30"><br> <INPUT TYPE="submit" VALUE="go" </FORM> I want to loop through the records on the add_records page. It works fine if I do this and just display them: <table> <dtml-in testlist> <tr> <td><dtml-var Field1 missing></td><td><dtml-var Field2 missing></td> </tr> </dtml-in> </table> I get the following error if I try looping it through a ZSQL Method: Error Type: Bad Request Error Value: ['Field1', 'Field2'] Here is the code I used and sqlTest is the ZSQL Method that just inserts the two fields into a test DB: <dtml-in testlist> <dtml-call sqlTest> </dtml-in> What am I doing wrong? Calvin

2 3

Re: [Zope] multiple ZOPE ...
by Simon Coles 26 Sep '00

26 Sep '00

>We host zope using mutliple installations of zope. Yes, that's what we do for our "Professional" Zope hosting. For "FreeZope", you just get your own folder, and it lives under http://freezope.nipltd.net/yourplace. We have a standard list of products, and we don't allow people any more. > It is better this way >because then the clients can control which products they have installed, they >can tweak their products without bothering anyone else, they can stop and >restart zope whenever they please...the basically have full control. You >can't do that with more than one client using the same instance. All the advantages you mention, plus you can let them upgrade their Zope version when they need it. We want to upgrade FreeZope to 2.2.x at the moment, and its something we need to be cautious about. There are a lot of people on FreeZope, and the move to 2.2 can break a fair number of things. Given its this painful on a free service, I'd hate to be trying to upgrade a shared server that had paying clients. >Yes it does use a fair bit of memory, but you would expect your client to pay >for it accordingly. Its also requires a fair number of configuration steps (raise the OS account, install Zope, configure Apache, configure MySQL, setup DNS, setup log analysis etc.), which takes time - although we'll probably automate some or all of this at some point. If you allow your customers shell access to the machine you also need much greater security awareness than you'd have for just a normal firewalled web server. Simon -- --------- My opinions are my own, NIP's opinions are theirs ---------- Simon J. Coles Email: simon(a)nipltd.com New Information Paradigms Work Phone: +44 1344 753703 http://www.nipltd.com/ Work Fax: +44 1344 753742 =============== Life is too precious to take seriously ===============

1 0

Favorites
by rishi 26 Sep '00

26 Sep '00

Hi guys I've got a reply that my explaination was not good, let me try again; I have a website running on zope with apache. The users of my site can store memo's and bookmarks there. The following tihng is going on; they are uploading the bookmark file manualy, by exporting from IE or NS. There is a util called "ImportExportFavorites", a javascript syntax that gets the bookmarks and post them to the server. --" javascript:window.external.ImportExportFavorites(false,'your server adress') "-- when I use this util, it will send it's data tru the http_user_agent called "favorites", is there a posible way for grabbing the data it is sending into zope ? it will send a file called 'img.fav' Thanks.

3 3

mxDateTime anyone
by Jason Cunliffe 26 Sep '00

26 Sep '00

Hello Whenever I end up wanting to do some real work with dates and time I end up being referred to the lovely mxDateTime package. http://starship.python.net/~lemburg/mxDateTime.html Unfortunately Zope does not use this yet.. The real shame is that it is not the standard default for Python and then everyone could benefit. Q1: Is there any plan to use mxDateTime in Zope? Q2: Has anyone here been working with it anyway, via External Methods for example? I would love to hear what you have been doing and how you solved any Zope namespace conflicts, passing of variables etc.. I posted on this back in the spring and did get some kind advice, but ran in to some other problems, which I could not solve then. So at the time I decided to compromise, avoid those hassles and use Zope's built-in tools. But the nagging problem won't go away that a more robust system is needed, And with the cool timestamp arithmetic and functions that mxDateTime has. I have an application where we want to have lots of data older than the beginning of Unix for example.. [my birthday to take a trivial example]. Application #1 is history database system where all sorts of places, art etc can be handled via Zope. Without a decent DateTime mechanism I can't see how to use it. Maybe I am missing something about Zopes features, but it look like it will be a mess for anything pre1970. I hope I am wrong.. Application #2 is for intermodal transport - lots of shifting relative dates and times, odd arithmetic to do with days of week, 2nd Thursday in the month etc. mxDateTime is great for all this. Q3: Does anyone have tips or good advice how to do this with Zope's own if mxDateTime can be used? Thanks - Jason ________________________________________________________________ Jason CUNLIFFE = NOMADICS.(Interactive Art and Technology).Design Director

1 0

Guess Who . . .
by Spicklemire, Jerry 26 Sep '00

26 Sep '00

. . . has a opening posted on their Web Site for a C/C++ programmer with Zope / Python experience? http://www-3.ibm.com/employment/us/empl/jofK23137.html Email Software Engineer (CA-K23137) Category: Software Location: CA Division: Other Divisions Work as a part of a small team developing a hosted domain e-mail service for small businesses. Desired Skills Excellent C/C++ coding skills, Unix Development experience (FreeBSD, AIX, Linux a plus), Experience with OPEN SOURCE code (or work with legacy code), Working knowledge of SMTP, sendmail, POP3, IMAP, LDAP, Experience with scripted HTML languages (ZOPE, Python) a plus Education Required Bachelors Degree Computer Science (or equivalent) required Experience Required Six years work related experience

2 1