January 2001 - Zope - Zope lists

RE: ZMySQLDA, Problems Connecting
by Steve McMahon 15 Jan '01

15 Jan '01

>...when I attempt to add a Z MySQL Database Connection to a folder, I get "Invalid connection string" -- no matter what the connection string.... Problem solved. It turned out there was a line of commented-out diagnostics on the page that reported "Invalid connection string." That let me know the problem was an inability to connect through the socket. Checking that, I discovered that the RedHat default install has 0700 permissions for the directory containing the MySQL socket. Changing that to 0711 cleared up my problems. _________________________________________ Steve McMahon, SunType Publishing Systems steve(a)suntype.com voice & fax: (530) 757-7682 http://www.suntype.com

1 0

Re: [Zope] convert a String ...
by Dieter Maurer 14 Jan '01

14 Jan '01

Marc Fischer writes: > how is it possible to convert a string into my own zclass type? > I get a String from a form and want to do some operation like > string.manage_addFile(... on it. So what to do ??? Perhaps some out there is > able to help ... "_.getitem(string)" converts a string into an object. Probably, you will not get a "zclass type". But such a type would probably not have a "manage_addFile" method anyway. Do you mean "Z Instance" rather than "zclass type"? Dieter

1 0

RE: [Zope] renaming python input params in DTML
by Randall F. Kern 14 Jan '01

14 Jan '01

You can't use DTML tags inside an expr="" attribute; the value of expr is python code. To access the sequence-item variable from python, you need: _['sequence-item'] So, try something like this (untested): <dtml-in expr="REQUEST.form.items()"> <dtml-in expr="testSQL(text=_['sequence-key'] + 'x' + _['sequence-item'])"> <dtml-var result> </dtml-in></dtml-in> -Randy -----Original Message----- From: Lee [mailto:lee.reilly@ntlworld.com] Sent: Sunday, January 14, 2001 1:23 PM To: zope(a)zope.org Subject: [Zope] renaming python input params in DTML Hi, I am having a problem passing in a variable to a Python method, which is obtained from the REQUEST object - I'd really appreciate someone's insight into how to correctly go about this. I have a form that submits a parameter named '9728430xp0xclasstest' with a value = 7 to a DTML method. I have a Python method expecting 'text' as a parameter so I want the DTML method to send 'text' onto this with a value = the value of the original parameter appended to name (i.e. 9728430xp0xclasstestx7). So text=9728430xp0xclasstestx7 Does that make sense? The Python method, testSQL, returns 'result'. As I recently found out, I have to make to make use of the REQUEST object to obtain these parameters. The following snippet produces the correct value (9728430xp0xclasstestx7)... <dtml-in expr="REQUEST.form.items()"><dtml-var sequence-key>x<dtml-var sequence-item></dtml-in> ... but how can I can pass this as 'text' to my Python method? Am I on the right track with the following: <dtml-in expr="REQUEST.form.items()"> <dtml-in expr="testSQL(text='<dtml-var sequence-key>x<dtml-var sequence-item>')"> <dtml-var result> </dtml-in></dtml-in> Thank very much for any help you can offer. - Best regards, PS: <dtml-let text="'9728430xp0xclasstestx7'"> <dtml-var text> </dtml-let> ... may help but... <dtml-var standard_html_header> <dtml-in expr="REQUEST.form.items()"> <dtml-let text="'<dtml-var sequence-key>x<dtml-var sequence-item>'"> <dtml-var text> </dtml-let> </dtml-in> ... gives me text = x ! Any help would really be appreciated? Thanks :) -- Lee Reilly mailto:lee.reilly@ntlworld.com ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,, HAVE SKILLS; WILL TRAVEL. I'm currently looking for an internship in the USA in the field of web development. Ideally, I'm looking for a placement for 3 to 18 months. Can you help? More details, my resume, etc. @ http://homepages.strath.ac.uk/~aeu97172/ </shameless plug> _______________________________________________ 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

Re: [Zope] Raw post data
by Dieter Maurer 14 Jan '01

14 Jan '01

Shai Berger writes: > For several reasons, I would like to have direct access to raw posted > data in my dtml-code (an analogue of QUERY_STRING). Can anyone please > show me the light? "REQUEST['BODY']" may work. Dieter

1 0

Re: [Zope] TREE tag - not showing Folderish objects that contain no sub-objects
by Dieter Maurer 14 Jan '01

14 Jan '01

Kevin Howe writes: > ... > <dtml-tree expr="PARENTS[-1]" branches_expr="objectValues()" sort=id> > ... > What I would like to do is display these objects, but ONLY IF they currently > contain some objects, so that if an object does not contain any subobjects > at the moment, it is not displayed. Search the searchable list archive. There has recently been a thread about filtering for "dtml-tree". Search for "branches_expr" to locate the thread. Dieter

1 0

renaming python input params in DTML
by Lee 14 Jan '01

14 Jan '01

Hi, I am having a problem passing in a variable to a Python method, which is obtained from the REQUEST object - I'd really appreciate someone's insight into how to correctly go about this. I have a form that submits a parameter named '9728430xp0xclasstest' with a value = 7 to a DTML method. I have a Python method expecting 'text' as a parameter so I want the DTML method to send 'text' onto this with a value = the value of the original parameter appended to name (i.e. 9728430xp0xclasstestx7). So text=9728430xp0xclasstestx7 Does that make sense? The Python method, testSQL, returns 'result'. As I recently found out, I have to make to make use of the REQUEST object to obtain these parameters. The following snippet produces the correct value (9728430xp0xclasstestx7)... <dtml-in expr="REQUEST.form.items()"><dtml-var sequence-key>x<dtml-var sequence-item></dtml-in> ... but how can I can pass this as 'text' to my Python method? Am I on the right track with the following: <dtml-in expr="REQUEST.form.items()"> <dtml-in expr="testSQL(text='<dtml-var sequence-key>x<dtml-var sequence-item>')"> <dtml-var result> </dtml-in></dtml-in> Thank very much for any help you can offer. - Best regards, PS: <dtml-let text="'9728430xp0xclasstestx7'"> <dtml-var text> </dtml-let> ... may help but... <dtml-var standard_html_header> <dtml-in expr="REQUEST.form.items()"> <dtml-let text="'<dtml-var sequence-key>x<dtml-var sequence-item>'"> <dtml-var text> </dtml-let> </dtml-in> ... gives me text = x ! Any help would really be appreciated? Thanks :) -- Lee Reilly mailto:lee.reilly@ntlworld.com ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,,ø¤º°`°º¤ø,,,, HAVE SKILLS; WILL TRAVEL. I'm currently looking for an internship in the USA in the field of web development. Ideally, I'm looking for a placement for 3 to 18 months. Can you help? More details, my resume, etc. @ http://homepages.strath.ac.uk/~aeu97172/ </shameless plug>

1 0

Re: [Zope] REPOST: dtml-with doesn't work
by Shai Berger 14 Jan '01

14 Jan '01

Philip has already made it clear that this was not his problem, but still, Dieter Maurer wrote: > Just a remark: > > SQL methods do *NOT* look at the DTML namespace *AT ALL*, > just at REQUEST (or the expliciitly passed keyword arguments). > > Thus, "dtml-with", "dtml-let" and friends are all ineffective > with respect to ZSQL methods. > My experience is somewhat different: ZSQL methods in general *DO* look at the namespace just like normal DTML methods, with two exceptions: 1) The major one, is that Dieter's remark does describe (almost) correctly the behavior of <dtml-sqlvar> and <dtml-sqltest>. These two tags only look at a very limited local namespace, initialized with the REQUEST and passed arguments; but even this namespace may be modified, *INSIDE* the ZSQL method, with <dtml-in> and <dtml-let>. However, other tags behave quite normally -- which means that a lot of the problems can be bypassed by thoughtful use of <dtml-var>, especially using the sql_quote modifier (BTW, it is by virtue of this that you can call other methods -- even other ZSQL methods -- from within a ZSQL method). 2) Changing REQUEST does *not* update the local namespace, that is, within a ZSQL method, <dtml-call "REQUEST.set('some_var', 17)"> <dtml-var some_var> doesn't work; but <dtml-var "REQUEST['some_var']"> Does. Hope this helps, Shai.

2 1

Raw post data
by Shai Berger 14 Jan '01

14 Jan '01

Hi guys, For several reasons, I would like to have direct access to raw posted data in my dtml-code (an analogue of QUERY_STRING). Can anyone please show me the light? Thanks, Shai.

4 3

ZMySQLDA, Problems Connecting
by Steve McMahon 14 Jan '01

14 Jan '01

Greetings Zopers, I'm attempting to make connections between Zope and MySQL using MySQL-python 0.3.0 and ZMySQLDA 2.01. The Python/MySQLdb side is working. I can use "connect(db='test')" or "connect(db='test', user='guest', passwd='token')" -- where guest and token are a MySQL username and password -- to build a connection object and go on to do queries. However, when I attempt to add a Z MySQL Database Connection to a folder, I get "Invalid connection string" -- no matter what the connection string I offer. (e.g., "test" or "test guest token" or "test@localhost guest token" or any number of permutations of these. Anybody run into this problem? Any suggestions on avenues to pursue? Thanks, Steve McMahon

1 0

[Skinscript] unable to update property
by Dirksen 14 Jan '01

14 Jan '01

Hi Steve, I ran into a very tricky problem when developing a site with emarket. Here is the structure of my site: root |--acl_users(Membership product) |--emarket |--shoppers The acl_users is an instance of Membership product, which is as a specialist as shoppers, and they both have a WebIC_MemberClass zclass as their rack object class. The difference is that, acl_users stores WebIC_MemberClass persistently, while shoppers just reflects that storage. Here is the skinscript for shopper's rack: WITH acl_users.getItem(self.id) COMPUTE oo=RESULT WITH self.oo COMPUTE email, transCount WHEN OBJECT CHANGED STORE transCount USING self.oo.propertysheets.webic.manage_changeProperties(transCount=self.transCount) When emarket trying to increment a shopper's transCount, I ran into a "ZODB.POSException.ConflictError". The following is the traceback: Traceback (innermost last): File C:\WebSite\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\WebSite\lib\python\ZPublisher\Publish.py, line 199, in publish File C:\WebSite\lib\python\ZPublisher\Publish.py, line 199, in publish File C:\WebSite\lib\python\ZPublisher\Publish.py, line 199, in publish File C:\WebSite\lib\python\ZPublisher\Publish.py, line 195, in publish File C:\WebSite\lib\python\Zope\__init__.py, line 188, in zpublisher_exception_hook (Object: ProviderContainer) File C:\WebSite\lib\python\ZPublisher\Publish.py, line 175, in publish File C:\WebSite\lib\python\Zope\__init__.py, line 235, in commit File C:\WebSite\lib\python\ZODB\Transaction.py, line 251, in commit File C:\WebSite\lib\python\ZODB\Connection.py, line 351, in commit (Info: (('*hdVMVCvgk/wIgJaYf/nkEA==', 'WebIC_MemberClass'), '\000\000\000\000\000\000d\357', '')) File C:\WebSite\lib\python\ZODB\FileStorage.py, line 664, in store (Object: C:\WebSite/var/Data.fs) ConflictError: ('\0039\323C4=\266\210', '\0039\323B\375\036\270U') Is it something wrong with my skinscript? cheers Dirksen __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

2 1