August 2003 - Zope - Zope lists

button in ZPT
by Michael Bleijerveld 08 Aug '03

08 Aug '03

Instead of a textlink I want to use a button (form) as a replacement for the following statements. Has anyone suggestions ? <a tal:condition="previous" tal:attributes="href string:${request/URL0}?start:int=${previous/first}" href="previous_url">previous</a> Regards. Michael

2 1

password for website??
by Rex McKanry 08 Aug '03

08 Aug '03

Hi, I'm real new at using Zope and need to find out how to require a user to enter a user name and password for Zope. Kind of like the login in screen I get when I want to connect to Zope and work on a web page. This is the last thing I need for my school project then it's all the paperwork showing the design stuff. Thanks, Rex __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

2 1

SQL Queries, DTML Methods and XML-RPC
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 08 Aug '03

08 Aug '03

Hello, After some research, I've still not come up with any great solution to this problem (Though I did see a few things on the web, archives, etc ...) I would like to have methods callable through XML-RPC that return the result of SQL queries (Z SQL Methods). So far, the best luck I've had is by using a DTML Method. The big problem is that DTML Method doesn't take positional parameters ... (In hind sight, this is probably is shortfall of DTML Methods ... if they're really "methods", then they should take parameters through aparameter list, much like Python Scripts ... no? ). Anybody know a way around this? One other option I have thought of so far: Since DTML Methods are methods of their folders, I could do the same through a product: create a fodlerish type and extend it with my own methods, which will then be available through XML-RPC. This is more painful to create and manage, not only for the obvious reasons, but because I may have many methods I wants to create for XML-RPC access, and constantly creating new folderish types for that pupose isn't very elegant or sustainable. Also did I not hear there' sissue with calling SQL Methods from product code ? I'll look into that. Does anybody have any better way to do this? Any suggestions would be much appreciated! Thanks, Jean-François Doyon Internet Service Development and Systems Support GeoAccess Division Canadian Center for Remote Sensing Natural Resources Canada http://atlas.gc.ca Phone: (613) 992-4902 Fax: (613) 947-2410

1 0

Re: sql_quote in dtml-var in zsql-Methods
by Elena Schulz 08 Aug '03

08 Aug '03

Hi Jim, thanks for your answer. Yes, I know about the quoting problem and what dtml-var does. But acording to my findings dtml-var plus sql_quote doesn't do the same thing. I couldn't find that it was doing anything with the quoting. That's why I'm asking. Also the different way dtml-var plus fmt=sql-quote. But I will check again. But another question: what should be done in the following construct: select <dtml-var myCol> from <dtml-sqlvar myTable> Here another kind of quoting would be needed or the following could be done: myCols = "a_table_col from a_table; delete * from a_table; select * " Thats the same problem, isn't it? What would help here? Just a double quoting like: select "<dtml-var myCol>" from <dtml-sqlvar myTable>? -- Elena

2 1

mysql error...
by Chris Bowlby 08 Aug '03

08 Aug '03

Hi All, Got an issue with a search feature that was configured by a client of mine, when they choose to search using a keyword, they get this error: Site Error An error was encountered while publishing this resource. _mysql_exceptions.NotSupportedError Sorry, a site error occurred. Traceback (innermost last): File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 106, in publish File /usr/local/www/Zope/lib/python/Zope/__init__.py, line 182, in abort File /usr/local/www/Zope/lib/python/ZODB/Transaction.py, line 107, in abort File /usr/local/www/Zope/lib/python/Shared/DC/ZRDB/TM.py, line 60, in abort File /usr/local/www/Zope/lib/python/Products/ZMySQLDA/db.py, line 328, in _abort NotSupportedError: (1196, "Warning: Some non-transactional changed tables couldn't be rolled back") I'm not much of a Zope user/admin, so someone might need to be really specific about what this error actually means, it seems to be that a table might be missing from the mysql datatbase, but I need some confirmation on that, also if that is the case, where would I get the schema for this table..

3 2

how to get the name of the element from the formulator in zpt
by Exteam 08 Aug '03

08 Aug '03

hi i need to get the name of the element from the formulator in zpt. i have done some thing like this, <input type="text" tal:attributes="value python:'%s' % record['test_table_name1']; name python:form.test_table_name.get_value('title')"> test_table_name1 is my column name in the db table & test_table_name is my formulator element in the formulator . Title of test_table_name is "test table name" in the formulator. this displays a text box with the value coming from db using a py script & name as title of the element , <input type=text name="test table name" value=abc> abc comes from db using py. but how do i get the name of the element as name attribute in the input type=text ie, how to display <input type=text name="field_test_table_name" value=abc> plz help me thanks harish ________________________________________________________________________ Send free SMS using the Yahoo! Messenger. Go to http://in.mobile.yahoo.com/new/pc/

2 1

loading zope within python interpreter
by Michael Long 08 Aug '03

08 Aug '03

Hi, Is there a recipe/product that will load the ZODB as well as the zope environment from within the python interpreter? I would like to be able to play/test with a product that I am creating from within the interpreter. tia, Mike

3 2

can't pack large Data.fs (2.5GB)
by Marcus Schopen 08 Aug '03

08 Aug '03

Hi, can't pack a 2.5GB big Data.fs through the ZMI: Zope Error: ---------- Zope has encountered an error while publishing this resource. Error Type: OverflowError Error Value: integer addition ---------- System is Debian woody with ext3: ---------- (Zope 2.6.2 (CVS 20030518 source release, python 2.1, linux2), python 2.1.3, linux2) Python Version 2.1.3 (#1, Sep 7 2002, 15:29:56) [GCC 2.95.4 20011002 (Debian prerelease)] System Platform ---------- traceback: ---------- 2003-08-07T23:16:18 ERROR(200) ZODB packing Traceback (innermost last): File /home/dzug/Zope/lib/python/ZODB/DB.py, line 502, in pack File /home/dzug/Zope/lib/python/ZODB/FileStorage.py, line 1503, in pack (Object: /home/dzug/Zope/var/Data.fs) File /home/dzug/Zope/lib/python/ZODB/fspack.py, line 658, in pack File /home/dzug/Zope/lib/python/ZODB/fspack.py, line 442, in findReachable File /home/dzug/Zope/lib/python/ZODB/fspack.py, line 459, in buildPackIndex OverflowError: integer addition ---------- If it was a LFS problem the zope wouldn't run. And I think the woody's python (Version: 2.1.3-3.2) is built with LFS support. Any ideas? Cheers, M. -- Marcus Schopen (0> P.O. Box 10 25 25 //\ Deutsche Zope User Group D-33525 Bielefeld V_/_ www.dzug.org

2 3

Re: [Zope] From FTP to FTP copy support?
by Jaroslav Lukesh 08 Aug '03

08 Aug '03

> Odesílatel: Chris Withers <chrisw(a)nipltd.com> > Jaroslav Lukesh wrote: > > I was test it with sample files, this is OK, but folder and some files that > > I want to remote copy have error in creation via FTP (I must make it via > > ZMI). > > Find otu why the creation is failing. What type of objects are you trying to create? It depends on the name of imported objects, not the type (DTML Document (default for FTP), images, Folders). For example I frequently use object names like "1", "01" etc, but it does not allow to create "images" folder too. At another place of folder tree it allows to create documents/folders with that names. Somebody few times ago says me that FTP has sometime problems with acquisition. BUT: I run Zope on Windows (development, need MSIE) and on Linux (HQ server). On Linux these problems occur less frequently (I cannot remember if any ?? ) than under windows. Regards JL.

1 0

Plone error
by tore.agblad＠swipnet.se 08 Aug '03

08 Aug '03

Hi. I get this message when trying to start after adding Plone to the Products folder. Any ideas ?? /Tore in Sweden Traceback (most recent call last): File "/usr/share/zope261/lib/python/OFS/Application.py", line 541, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/usr/share/zope261/lib/python/Products/CMFPlone/__init__.py", line 3, in ? import migrations ImportError: No module named migrations ________________________________ Tore Agblad Trulsegårdsvägen 15 423 59 Torslanda tore.agblad(a)swipnet.se ------------------------------------------------- WebMail från Tele2 http://www.tele2.se -------------------------------------------------

1 0