- Zope - Zope lists

Searching method due to situation
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 Searching 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

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