- Zope - Zope lists

More than one condition in<dtml-if>
by Angietel 15 Jan '01

15 Jan '01

The following is my DTML code, purposely to valid the entry field and return the right sql method according to the situation:- <dtml-if "_['<dtml-var custname>']!=""" AND "_['<dtml-var custid>']=="""> <dtml-in sqlSearchcust3> #// if the custid is blank and custname is not blank then will use sqlSearch3 <dtml-elif "_['<dtml-var custid>']!=""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust2> #// if the custid is not blank and custname is blank then will use sqlSearch2 <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']=="""> <dtml-in sqlSearchcust> #// if the custname is not blank and custid is not blank then will use sqlSearch <dtml-else> <dtml-var expr="REQUEST['/Customer/View/searchallcust']"> #// if the custname is blank and custid is blank then will go to view a list of customer record. </dtml-if> The following is the ZOPE error:- Unexpected tag, for tag <dtml-elif "_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']!=""">, on line 9 of a For my sql method syntax are as follow:- 1.sqlSearchcust3 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=ne type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> 2. sqlSearchcust2 select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=ne type=string> </dtml-sqlgroup> 3. sqlSearchcust select * from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> This is urgent! Please give me some solution, Thanks!

1 0

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