March 2001 - Zope - Zope lists

ZSQL & LIKE Operator
by Donald Braman 28 Mar '01

28 Mar '01

I'm trying to get Zope to submit a "like" statement to MS Access (please don't ask why I'm using MS Access; it's a temporary situation). Anyway, I can't get a working ZSQL method LIKE and a wildcard. I try: SELECT * FROM Cases WHERE Short_Case_Name LIKE 'Plessy v. Ferguson' works fine; I try: WHERE Short_Case_Name LIKE 'Plessy*' I get no data matching query. I can run the query through MS Access SQL view just fine; not sure why it's not working with ZSQL. Donald Braman donald.braman(a)yale.edu

4 3

Re: [Zope] indirect calling of methods with parameters
by Dieter Maurer 28 Mar '01

28 Mar '01

Bernd Worsch writes: > .... > I'm trying to call a method that needs parameters indirectly. Reading the "Name Lookup" section in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html will make such things easy (I hope, at least). Dieter

2 1

Re: [Zope] dtml-in patch
by Dieter Maurer 28 Mar '01

28 Mar '01

Oleg Broytmann writes: > Can anyone (especially from DC) explain the lates patch to DT_In.py? > > < if index==first and index > 0: > --- > > if index==first or index==last: The original patch came from me. And indeed, it was supposed to provide uniform navigation both at the start and end of the sequence. It worked nice for us. I posted the original patch to the Collector (ages ago). You may find it also under: URL:http://www.dieter.handshake.de/pyprojects/zope/dt_in.pat I did not yet check the changes as applied in Zope 2.3.1. This will happen mid April. Dieter

2 1

Re: [Zope] integration w/ Lotus Notes
by Simon Coles 28 Mar '01

28 Mar '01

On 27/3/01 1:16 am, "Sundar Narasimhan" <sundar(a)ascent.com> wrote: > Hi, Does anyone have any help/suggestions wrt. how I can go about > connecting a Zope app. to Lotus Notes? > > Has anyone attempted/done such a thing already? You'd be surprised how many people in the Zope world came from Notes/Domino :-) "connecting a Zope app. to Lotus Notes" can cover whole range of things. We've got Zope and Domino working together in a single system, in a variety of ways. What is the specific problem you are trying to solve? 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 ===============

2 2

How do I get a string value of a DateTime object, in a given format
by Chris Beaumont 28 Mar '01

28 Mar '01

Hello, I'm sorry to ask such a basic DTML question...I just haven't been able to get this to work.. I'm hoping to use the Python slicing format to extract the various parts of a "pCommon" or aCommon" format date (the output from an SQL query) so that I can use them individually.. What is the syntax to get the string value of this non-strftime format date object, so that I can put it into a string variable for slicing? Thank you, Chris

2 1

ZMySQLDA connection error when adding
by Gitte Wange 28 Mar '01

28 Mar '01

Hello again, I hope not you are tired of my newbie questions already :-) Finally I succeed in adding MySQL functionality to Zope but I can't add a connection. This is the error I get when I try: Error Type: IOError Error Value: [Errno 2] No such file or directory: '/usr/local/Zope-2.3.0-linux2-x86/lib/python/Shared/DC/ZRDB/connectionAdd.dtml Traceback (innermost last): File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/App/special_dtml.py, line 127, in __call__ (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 479, in __call__ (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 408, in cook (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 400, in read (Object: manage_addZMySQLConnectionForm) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 580, in read_raw (Object: manage_addZMySQLConnectionForm) IOError: (see above) Any good ideas ? Regards, -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte(a)mmmanager.org ************************

7 11

Re: [Zope] Zope Hosting
by Jan Lentfer 28 Mar '01

28 Mar '01

27.03.2001 08:46:02, Casey Duncan <cduncan(a)kaivo.com> wrote: > >Take a look at: http://www.zope.org/Resources/ZSP > >Several companies doing hosting are listed there. >-- >| Casey Duncan I already looked through all the companies listed there. But unfortunatley only very few of them have pricing or hosting options on their site. So I just wondered if someone on this list personally knows or has heard of a good Zope hoster. Jan -------- Jan(a)MountainbikeHQ.de http://www.MountainbikeHQ.de - Your home for DH,DS and CC Mountainbiking & http://test.MountainbikeHQ.de - the new instance of Mountain Bike Headquarters!

3 2

multiple SQL commands over ODBC
by Donald Braman 28 Mar '01

28 Mar '01

I'm trying to get two SQL commands that work seperately to work in the same ZSQL Method. The commands are Zope ZSQL -> ZODBCA -> MSODBC -> MSAccess: Update Cases SET Weighted_Score = 123 (this is a dummy number, just to test) WHERE Score > 0 SELECT * FROM Cases WHERE Weighted_Score > 0 ORDER BY Weighted_Score Both work seperately; I've also tried inserting a semicolon after the first and both commands. Any ideas? Donald Braman donald.braman(a)yale.edu

3 2

A typical Zope problem
by Chris Cioffi 28 Mar '01

28 Mar '01

I know this is a common complaint, but I just found a particularly nasty example: On the download page (http://www.zope.org/Products) I am encouraged to download and install the latest Hotfix, currently dated 3/8/2001. Looking at the link to more Zope fixes and the readme for this latest Zope hotfix I am told that this is important and should install right away. Fine. Nowhere am I given a link to instructions on HOW to install this hotfix. I don't care how easy it is to install a hotfix, please give me some documentation on what to do with this .tgz file I'm getting. I'm trying to learn Zope and the Zope way. However, for a product with a version of 2.3 to have such poorly organized documentation is just amazing. I know Zope has some really great documentation out there... And that's the problem, the documentation is just "out there" and to find it I have to luck out and find a link right to it, or read through dozens of pages that mention, but don't address the question I have. Zope is billed as a great content managment system/framework, but Zope.org site seems more a poster child for a content _publishing_ system. Management of that content is sorely lacking. I had to pass over Zope for other products twice in the last month, largely due to poor documentation: I knew Zope could do it, I just can't find any decent material on how. The Zope tutorial and Zope Book just say that development is possible but don't go into the details of developing Zope applications. (We won't go near Products...) I know I have the source, great, will you pay my salary for the next 2 months while I get a grip on that? I don't have time otherwise. I'm able to spend a little time learning, but the cost/benefit equation is making me think that Zope just isn't ready for prime time, which is a shame since I looks like Zope could provide a quantum leap foreward in making the web the platform of choice. I know this sounds just like a whiny complaint, but this is a complaint born out of a frustration at seeing what I think is a really great platform being relegated to a niche because the documentation isn't well organized. Chris

6 5

Re: Re: [Zope] multiple SQL commands over ODBC
by Donald Braman 28 Mar '01

28 Mar '01

With the semicolon, I get: Error, sql.error: ('37000', -3517,'[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.' Without the semicolon I get: Error, sql.error: ('37000', -3100,"[Microsoft][ODBC Microsoft Access Driver] Syntax error. in query expression 'Score > 0\012\012SELECT *\012FROM Cases\012WHERE Weighted_Score > 0'." Don ---------Included Message---------- Date: Tue, 27 Mar 2001 16:48:29 -0800 From: "Andy McKay" <andym(a)ActiveState.com> Reply-To: "Andy McKay" <andym(a)ActiveState.com> To: <donald.braman(a)yale.edu>, <zope(a)zope.org> Subject: Re: [Zope] multiple SQL commands over ODBC What error are you getting? Cheers. -- Andy McKay. ----- Original Message ----- From: "Donald Braman" <donald.braman(a)yale.edu> To: <zope(a)zope.org> Sent: Tuesday, March 27, 2001 4:31 PM Subject: [Zope] multiple SQL commands over ODBC > I'm trying to get two SQL commands that work seperately to work in the > same ZSQL Method. The commands are Zope ZSQL -> ZODBCA -> MSODBC -> > MSAccess: > > Update Cases > SET Weighted_Score = 123 (this is a dummy number, just to test) > WHERE Score > 0 > > SELECT * > FROM Cases > WHERE Weighted_Score > 0 > ORDER BY Weighted_Score > > Both work seperately; I've also tried inserting a semicolon after the > first and both commands. Any ideas? > > Donald Braman > donald.braman(a)yale.edu > > > > _______________________________________________ > 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 ) > ---------End of Included Message---------- Donald Braman donald.braman(a)yale.edu

1 0