- Zope - Zope lists

re: dtml-sqltest and MS Access data types
by Harlow Pinson 16 Dec '01

16 Dec '01

It seems that the <dtml-sqlvar ... type="nb"> in a ZSQL method will write to a Long Integer data type in MS Access. I have not tried the other Access data types like memo, currency, etc. If anyone has experience with these, please share them with the list. Thanks. > Hi. This probably has a simple answer. > If I set up an field in a MS Access 2000 table with a data type of > Long Integer, and then try to write to it using a ZSQL method and > the DTML "dtml-sqltest" tag with type set to "int" or "float" I get an > ODBC error. > The Zope Book lists the possible data types available for sqltest > > as: int string, float, and nb > The only thing i've found to work is setting type to "string" > Are the other MS Access data types, like long integer, memo, > data/time, currency, etc supported by the the dtml-sqltest tag? > What are the workarounds? Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

1 0

URL Redirection problems...
by Vitor Varalonga 16 Dec '01

16 Dec '01

Hi! I'm facing a problem concerning URL redirection inside Zope: Suppose a try to make a redirection to a DTML document using it's relative path instead of the absolute one: DTML >> <dtml-call expr="RESPONSE.redirect('/abc/xpto?a=1&b=2&c=3')"> Python >> container.REQUEST.RESPONSE.redirect("/abc/xpto?a=1&b=2&c=3") So far so good... The redirection process goes on apparently well. But if I try to reach the variables I passed in the query string (e.g., REQUEST["a"]), kaput... what a surprise... they don't exist in the REQUEST object as I expected. Apparently the variables are not stored in the REQUEST object. Now the good thing is that the query string is not lost since its stored in a special variable called QUERY_STRING. So if I execute: <dtml-var expr="REQUEST['QUERY_STRING']"> I should get: "a=1&b=2&c=3" I can always parse the string and get the values for each variable, but is there any logical explanation for this? Thanks in advance, Vitor Varalonga

3 5

Zope digest, Vol 1 #1830 - 20 msgs
by a.dewit＠niwa.cri.nz 16 Dec '01

16 Dec '01

Hi, I'll be back on Monday Dec 17th but may check my mail periodically while away. Arian

1 0

INSTANCE_HOME...Please..
by Ben Ocean 16 Dec '01

16 Dec '01

Hi; I'm trying to get Jim Cain's multiple zope instances script working. I would like to get this working so that I can build INSTANCE_HOME on top of it and install a bunch of products without having to always re-do everything! I have this output from zstart (designed to start my one instance of zope): #su nobody -c \ > "/usr/local/bin/python /home/httpd/ZopeInstallation/zope0/z2.py \ > -p /home/httpd/cgi/zope0/Zope.cgi \ > -w '' -m '' -f 8080 -t 2 -Z /home/httpd/ZopeInstallation/zope0/var/zProcessManager.pid \ > INSTANCE_HOME=/home/httpd/ZopeInstallation/zope0 \ > /home/httpd/ZopeInstallation/zope0/z2.log 2>&1 &" I've created the extra files (Zope.cgi, z2.log). I wasn't quite sure what pid Jim wanted for his *manager.pid*, so I assumed the zProcessManager was what he was after and stuck that in. At any rate, when I run the above I just get a prompt returned, but Zope isn't started. Can someone please let me know what I'm doing wrong? TIA, BenO

1 0

HOWTO: Using Xron on Zope 2.4.x
by Jean Jordaan 16 Dec '01

16 Dec '01

Hi all .. I struggled with this myself today, so I summed up the wisdom of the archives for those who come after ;) To use Xron on Zope 2.4.x, some hackery is required .. 1. Import DateTime correctly. Instead of: from Globals import DateTime do this: from DateTime import DateTime You need to do that once each in 'Dispatcher.py' and in 'XronDTMLMethod.py' 2. Implement the patches in this thread: http://lists.zope.org/pipermail/zope-dev/2001-July/012486.html In short: you need to do this: from Products.PluginIndexes.FieldIndex.FieldIndex import FieldIndex and instead of this: self._catalog.addIndex('name', 'FieldIndex') you now need to do this in a couple of places: self._catalog.addIndex('name', UnIndex('name')) 3. Follow the workaround described here: http://lists.zope.org/pipermail/zope/2001-April/087151.html (To get around bad interaction between Xron and 'Z2.py' on startup.) This is a drag. It has to happen every time you restart Zope. Yawn. I tried to mitigate it by running something like this:: cd lib/python/Products/Xron mv __init__.py __init__.py.not rm -f __init__.pyc cd ../../../../ (which I called called './xron_begone') from './start'. Then call http://server/Control_Panel/Products/Xron/manage_performRefresh and finally run './xron_comeback', which is the inverse of './xron_begone'. (Anyone have any better suggestions?) 4. Slay the dragon hinted at here: http://lists.zope.org/pipermail/zope-dev/2001-July/012502.html AFAIK, this is fixed by providing authentication information in 'Dispatcher.py':: (headers,response)=rpc(furl,'username','password') # Fire event You should now be running Xron without any more problems. Unless I missed something, of course! Corrections and elaborations welcome. Regards, Jean Jordaan

1 0

Installing 2.4.3: SyntaxError: from __future__ imports
by Jean Jordaan 16 Dec '01

16 Dec '01

Hi there. I downloaded Zope-2.4.3-linux2-x86, untarred it, and ran ./install [root@blommie 2-4-3]# ./install ---------------------------------------------------------------------------- -- Compiling python modules File "/usr/local/zope/creme/2-4-3/lib/python2.1/test/nocaret.py", line 2 [x for x in x] = x SyntaxError: can't assign to list comprehension SyntaxError: from __future__ imports must occur at the beginning of the file (test_future3.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (test_future4.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (test_future5.py, line 4) SyntaxError: from __future__ imports must occur at the beginning of the file (test_future6.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (test_future7.py, line 3) ---------------------------------------------------------------------------- -- Is this a problem? Jean

2 1

sql SELECT from a list - Beginner's Question
by Herring, William O. 16 Dec '01

16 Dec '01

I have a sql table which has 2 columns, v1 and v2. v1 is unique. I want to allow the user to enter up to 50 or less possible v1's, of their own choosing, and then simply view them. So the form page would have entries for up to 50 entry requests for v1. However, they may enter only 25, 30, 40, whatever they would like. So the sql without zope, if there were only 3 records requested, might look like: SELECT v1, v2, FROM tablename WHERE v1='1' or v1='3' or v1='5'; How do I build the form, sql method, and return list to accomplish this? I'm sure this has been done, so if someone could point me to a HOWTO or an example, it would be greatly appreciated. --Thanks.

5 6

Install Problem - probably stupid newbie thing
by Virgil H. Huston, Jr. 16 Dec '01

16 Dec '01

I have tried twice now to install Zope on a site on my server. I already have one other instance of Zope running on the server (successfully), but under a different IP number. I can open the Zope main screen, but the log-in will not accept the admin password the install script generated. Here are errors I get when I do the install. ------------------------------------------------------------------------------ Compiling python modules File "/home/sites/site14/users/zopecopy/Zope-2.4.3-linux2-x86/lib/python2.1/te st/nocaret.py", line 2 [x for x in x] = x SyntaxError: can't assign to list comprehension SyntaxError: from __future__ imports must occur at the beginning of the file (te st_future3.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (te st_future4.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (te st_future5.py, line 4) SyntaxError: from __future__ imports must occur at the beginning of the file (te st_future6.py, line 3) SyntaxError: from __future__ imports must occur at the beginning of the file (te st_future7.py, line 3) Here is what I get when I run start: ------ 2001-12-16T02:14:43 INFO(0) Zope New disk product detected, determining if we ne ed to fix up any ZClasses. ------ 2001-12-16T02:14:44 PANIC(300) z2 Startup exception Traceback (innermost last): File /home/sites/site14/users/zopecopy/Zope-2.4.3-linux2-x86/z2.py, line 625, in ? File /home/sites/site14/users/zopecopy/Zope-2.4.3-linux2-x86/ZServer/HTTPServe r.py, line 396, in __init__ File /home/sites/site14/users/zopecopy/Zope-2.4.3-linux2-x86/ZServer/medusa/ht tp_server.py, line 570, in __init__ File /home/sites/site14/users/zopecopy/Zope-2.4.3-linux2-x86/lib/python2.1/asy ncore.py, line 298, in bind error: (98, 'Address already in use') Any ideas on what the problem might be? I looked at zpasswd.py, but have no clue how to change the password. Thanks, Virgil -- Regards, Virgil Huston Kudzu Media covering the media world http://kudzumedia.com mailto:huston@kudzumedia.com

2 1

html_quote
by Lucas Vogel 16 Dec '01

16 Dec '01

I have Products that I've tried installing that fail because they can't seem to import html_quote from somewhere. Any help on how to fix this would be appreciated. Traceback (most recent call last): File "/usr/local/zope/243/lib/python/OFS/Application.py", line 563, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/zope/243/lib/python/Products/BookmarkFolder/__init__.py", line 35, in ? import bookmark_folder File "/usr/local/zope/243/lib/python/Products/BookmarkFolder/bookmark_folder.py", line 36, in ? from Products.WarpFramework import product_base_item, base_item File "/usr/local/zope/243/lib/python/Products/WarpFramework/product_base_item.py", line 30, in ? import utils File "/usr/local/zope/243/lib/python/Products/WarpFramework/utils.py", line 37, in ? import html_widgets File "/usr/local/zope/243/lib/python/Products/WarpFramework/html_widgets.py", line 27, in ? from ZPublisher.HTTPRequest import html_quote ImportError: cannot import name html_quote

3 2

RE: [Zope] Automatically run an external method?
by sean.upton＠uniontrib.com 15 Dec '01

15 Dec '01

I think what Bruce is asking is agnostic of this sort of thing, but I imagine he's referring to a whole object. If I understand correctly, this sort of thing exists in the CMF to trigger workflow states. Independent of the CMF, though, what you would need (I think, not 100% sure) to do is wrap object constructors & methods that change them, (for TTW adding of objects) and use a custom PUT() and/or PUT_factory() in the ObjectManager-derived container or your object itself (in order to change what happens when a file is uploaded via FTP or DAV into that container); I haven't done this, but I think there are those on this list that have done something like this. If I was trying to figure out how this is done, I would try to ask folks who have been into any workflow-related product code... Sean -----Original Message----- From: Lennart Regebro [mailto:lennart@regebro.nu] Sent: Saturday, December 15, 2001 2:36 PM To: Bruce(a)EckelObjects.com; zope(a)zope.org Subject: Re: [Zope] Automatically run an external method? From: "Bruce Eckel" <Bruce(a)EckelObjects.com> > Is it possible to automatically run an external method every time a > file is saved? That is, is there some kind of file where I can say > "when you're saved, call this method?"t "Saved"? What do you mean? Saved to disk, or uploaded to Zope, or changing the properties? _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0