- Zope - Zope lists

ZSQLMethod add?
by Bo M. Maryniuck 02 Aug '02

02 Aug '02

I do from python script: context.manage_addZSQLMethod('id', 'title', 'connId', '', 'select * from test') ...or from DTML Method...: <dtml-call "manage_addProduct['OFSP'].manage_addZSQLMethod('id', 'title', 'flu', '', None)"> ...and all the time got this: Error Type: AttributeError Error Value: manage_addZSQLMethod Traceback (innermost last): File /usr/local/Zope-2.5-stable/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/Zope-2.5-stable/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/Zope-2.5-stable/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: DB) File /usr/local/Zope-2.5-stable/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/Zope-2.5-stable/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: ttt) File /usr/local/Zope-2.5-stable/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: ttt) File /usr/local/Zope-2.5-stable/lib/python/OFS/DTMLMethod.py, line 127, in __call__ (Object: ttt) File /usr/local/Zope-2.5-stable/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: ttt) File /usr/local/Zope-2.5-stable/lib/python/DocumentTemplate/DT_Util.py, line 159, in eval (Object: manage_addProduct['OFSP'].manage_addZSQLMethod('id', 'title', 'flu', '', None)) (Info: None) File <string>, line 2, in f File /usr/local/Zope-2.5-stable/lib/python/AccessControl/DTML.py, line 29, in guarded_getattr (Object: ttt) File /usr/local/Zope-2.5-stable/lib/python/AccessControl/ZopeGuards.py, line 47, in guarded_getattr AttributeError: (see above) -- Sincerely yours, Bogdan M. Maryniuck We use Linux for all our mission-critical applications. Having the source code means that we are not held hostage by anyone's support department. (Russell Nelson, President of Crynwr Software)

3 3

Report to Recipient(s)
by Bradford1/UK/Equifax＠equifax.com 02 Aug '02

02 Aug '02

Incident Information:- Originator: zope-announce-admin(a)zope.org Recipients: zope(a)zope.org, zope-announce(a)zope.org Subject: [Zope-Annce] ANNOUNCE: Pound - reverse proxy and load balancer - v0.8 Message from zope-announce-admin(a)zope.org was quarantined because it contained banned content. This message contains information from Equifax, Inc. which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e:mail postmaster(a)equifax.com.

7 8

StructuredText & LocalFS in Python Script
by Elena Schulz 02 Aug '02

02 Aug '02

Dear List, having the following objects: sourceFolder points to a LocalFS-Instance, fileId points to a file in the LocalFS-Instance, and convert_nonascii_1(string) is just a method to exchange some text in string. in DTML I can do the following: <dtml-var "convert_nonascii_1(_.str(_.getitem(sourceFolder, 1)[fileId]))" fmt=structured-text> But how is it done in Python Script? if myLFSname is the name of the LocalFS-Instance and file.txt the name of a file in the LocalFS-Instance this works fine: context.myLFSname['file.txt']() But as soon as I try to do it with sourceFolder and fileId, I get only errors even if the Script can resolve both. Does anybody know why? And how do I use structured Text in Python Script as in DTML: <dtml-var my Var fmt=structured-text> Thanks a lot for your help, Elena

3 2

Beginner question: user defined variables
by Michael Guerrero 02 Aug '02

02 Aug '02

Hello, This my first zope project. I am trying to declare a variable called 'tot' for a total field. Within a dtml-in I would like to add a value to this variable. Then display the value of 'tot' after the dtml-in finishes. I have tried the following ( I have placed my comments at the end of each line): <table> <dtml-in sql_billtest> <dtml-call "REQUEST.set('tot','tot' + charge_amt)"> -- here is where I try to declare/add to the variable 'tot' <tr> <td><dtml-var invoice_num></td> <td><dtml-var item_type></td> <td><dtml-var charge_amt fmt="%0.2f"></td> -- for each row I want to add this field to 'tot' <td><dtml-var tap_num></td> <td><dtml-var subscriber_name></td> </tr> </dtml-in> <tr> <td><dtml-var tot></td> -- now I want to display the value of 'tot' </tr> </table> When I try this I get 'cannot add type "float" to string'. Is there a way to declare 'tot' as a float? Is this the correct way to do this? I have the 'Zope Bible' but it doesn't have any good examples. One way a was able to get the total was to put another dtml-in after the first and user the 'total' statistics variable. <dtml-in sql_billtest size="1"> <tr> <td><dtml-var total-charge_amt fmt="%0.2f"></td> </tr> </dtml-in> I do not prefer this way. Since 'sql_billtest' is a database query I do not want to query the database twice (once for the detail and once to get the total). Thanks for your help. Mike

2 1

session within standard_error_message
by KevinL 02 Aug '02

02 Aug '02

Can you set values inside the session object from within standard_error_message? I note that doing a request.RESPONSE.redirect requires a "lock=1" arg, I'm wondering if session variable setting suffers similar problems or not. Reason I ask is, I have an app that tries to set session variables within the standard_error_message, and debug indicates the variables are there within that transaction, but gone on the next request from the browser. KevinL

4 4

Log File Analysis Software
by James Bragg 02 Aug '02

02 Aug '02

Hello everyone! I'm attempting to get Sawmill (www.sawmill.net) working with Zope log files. First, Is anyone using Sawmill with Zope? If you are would you care to share your log definition file with me :o) Second, what module is responsible for writing the Z2.log file? Is this part of Medusa, ZServer, or Zope? Third, does anyone know where I can get the field definitions for the Z2.log file. I can't seem to find any docs on it. Almost finally, what other log file analysis tools are people using with Zope? Would you care to share your opinions? Finally, If I'm being blatantly stupid here, please forgive me I'm still a newbie :o) Thanks in advance for any advice or encouragement you have to offer. -james

3 2

Open Office, WebDav and Zope.....
by William P Hewitt 02 Aug '02

02 Aug '02

How does one get webdav running with 2.5.1..... I edited z2.py and added a webdav port, but I seem to be lost wtih how I then call it..... Any advice/experiences would be appreciated.....

2 1

RE: [Zope] Pointer to ZSQL Method using the UPDATE call
by McDonnell, Larry 02 Aug '02

02 Aug '02

Hi, Thanks to all for their solutions, I'm up and running. -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Ed Leafe Sent: Thursday, August 01, 2002 4:37 PM To: McDonnell, Larry Cc: zope(a)zope.org Subject: Re: [Zope] Pointer to ZSQL Method using the UPDATE call On Thursday, August 1, 2002, at 03:27 PM, McDonnell, Larry wrote: > I have been poking around to try to find the proper syntax to do an > UPDATE > within and ZSQL Method. I will need to update several fields within the > call. I tried using the following: > > update field_service_log > set <dtmlsql-var caller_name type="string"> > where <dtml-var service_log_num = service_log_num> > > It will save but produce an error. TIA You might want to check out the patch to SQLgroup made by Andy Dustman. I posted a similar question a couple of weeks ago, and got this reply: http://groups.yahoo.com/group/zope/message/94058. I've installed the two patch files (but not SQLBlender itself), and it's working flawlessly. I now have ZSQL methods for updating that look like: update reg <dtml-sqlgroup set noparens> <dtml-sqltest iplayerid type="int" op="eq"> <dtml-comma> <dtml-sqltest ilastteamid type="int" op="eq" optional> <dtml-comma> <dtml-sqltest clastteamtype type="string" op="eq" optional> <dtml-comma> <dtml-sqltest cotherdesc type="string" op="eq" optional> <dtml-comma> <dtml-sqltest itryoutage type="int" op="eq"> <dtml-comma> <dtml-sqltest cpostip type="string" op="eq"> </dtml-sqlgroup> where iid = <dtml-sqlvar iid type="int"> ___/ / __/ / ____/ Ed Leafe http://leafe.com/ http://foxcentral.net _______________________________________________ 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

DCOracle2
by Ruslan Spivak 02 Aug '02

02 Aug '02

Hello zope users, When I try to make a DCOracle2 connection I get: Invalid connection string: scott/tiger@orcl1 , but from python command line I can easily do connection to oracle with that string. I am stuck. Please help. Best regards, Ruslan mailto:alienoid@is.lg.ua

2 1

MailHost.send sends empty message
by John_Knutson＠candle.com 02 Aug '02

02 Aug '02

I am trying to send an email message from a Python script but all gets received is an empty message . I've tried using a variable insetad of a string constant but that doesn't make any difference. context.MailHost.send ("text" , mto=address, mfrom ="cassini(a)candle.com", subject=subject, encode=None) On a related subject, how would I construct a list of "to" addresses? Would it be an array or some sort of concatenated string? If the latter, how would it be delimited? I'm using Python here because I can't figure out how to do this (simply) with a Page Template so if anyone could point me at or send me such an example I'd be very grateful. Cheers, John Knutson Candle Corporation

1 0