November 2000 - Zope

SQL and dtml-tree
by Mike Kelland 29 Nov '00

29 Nov '00

I'm attempting to create a tree structure using dtml-tree from SQL results but I'm finding the documentation exceedingly cryptic. What I want to do is create the following structure: Client1 (tree Branch) Project1 Edit | Delete Project2 Edit | Delete Client2 Project1 Edit | Delete Client3 Client4 out of a database contaning the above information (ie client names, project names, and unique identifiers for each). I have the SQL queries that will give me the appropriate information I just need how to make the dtml-tree tag work with this. Any help whatsoever would be useful, thanks! Mike mike(a)studiomatic.com

1 0

Re: [Zope] Editing SQL methods from Emacs (+ FTP server)?
by Anthony Baxter 29 Nov '00

29 Nov '00

I added a patch for ftp-enabling SQL Methods to either the collector or the zopeshell patch manager on sourceforge (I forget which right now, and it's late and I'm going to bed right now...) If you can't find it, email me and I'll dig it up. >>> Stephane Bortzmeyer wrote > > All the texts explaining the wonders of Zope tell that you can edit your DTML > files from (X)Emacs, and not from the lame editor you get from your browser > with the default HTML form. > > It works great for DTML but ange-ftp (GNU emacs 20.7) refuses to open the SQL > methods ("File exists but cannot be read"). Is there a solution, besides > writing it offline and uploading it into Zope? > > > > > _______________________________________________ > 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 ) > -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

5 4

(no subject)
by Anderson Ami 29 Nov '00

29 Nov '00

Zopers, Anybody knows how can I change the value of a property of an object which has a dynamic (string variable) name ? thanks, Anderson

1 0

Re:External Methods
by Kini Natekar 29 Nov '00

29 Nov '00

Hi, I am currently running a external method .This method calls a python script using the following line <a href=\"http://localhost/cgi-bin/test.py?%s+%s\">%s</a>" %(name,age,gender) Instead of calling the python script we want to add the script as an external method in zope.The problem we are currently facing is in generating the above link dynamically. How do we solve the above problem ? Thanks, Kini. __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/

2 1

Re: [Zope] Help with Nested ZSQL methods
by Pavel V. Piankov 29 Nov '00

29 Nov '00

try calling like this : <dtml-in "sql_get_items(_.None,_)"> also you might what to use dmt-sql var instead of dtml-var inside ZAQL Methods. regards -- pashah >Here's the operative part of the dtml method that calls these methods: >============================================== ><dtml-in sql_get_schedules> > <TABLE BORDER="3"> > <TR><TH>Item No.</TH><TH>Description</TH><TH>Mn/DOT >No.</TH><TH>Units</TH></TR> > <dtml-in sql_get_items> > <TR> > <TD><dtml-var ItemNo></TD> > <TD><dtml-var Description></TD> > <TD><dtml-var MnDOTNo></TD> > <TD><dtml-var UnitDescription></TD> > </TR> > <dtml-in> > <TABLE> ></dtml-in> >============================================== > >I get the error: > >Error Type: Bad Request >Error Value: ['SchedID'] > >I suspect there is some type of namespace-related problem going on here >where the var SchedID is not getting passed to the internal ZSQL method. > >P. Johnson

1 0

ZopeFind expression
by Oliver Bleutgen 29 Nov '00

29 Nov '00

I fear this is anywhere in some howtos, but I couldn't find it. How can I get properties of a DTML-Documents parentfolder as expression in ZopeFind? At least I couldn't get the "Find" in Zope's webinterface to show all DTML-Documents whose parent-folder has a certain property. I guess I'm missing a method which gives me the Parent-object without the REQUEST object. cheers, Oliver

1 0

Re: [Zope] VHost logs.
by Oliver Bleutgen 29 Nov '00

29 Nov '00

> Jason C. Leach wrote: >> hi, >> >> Has anyone implemented there own logging for Virtual Sites? >> >> I was thinking in the site rules an External Method could be called, >> passed the Request obj, and from that generate logs for virtual sites. >> >> If anyone has done that, or knows of a better way I'd be interested in >> hearing it. > I'm not exactly sure what your goal is... but if you're just trying to > generate separate log files for each of your virtual sites, I'm > accomplishing > that by having my virtual sites proxied behind Apache (using SiteAccess > and > the ProxyPass directive) and specifying the log files for each VirtualHost > in > my httpd.conf file. You can control the contents of the logs using the > LogFormat directive; I use the same format for all of my virtual hosts, > but I > think you can specify a different log format for each host if you desire. > If you're trying to accomplish something else which requires you to handle > the > logging on the Zope side of things, then it seems to me that your idea > would > work, although I'd want to find out how my server performance would be > affected... I also would prefer to split the log via regexp-filters just before doing statistics or rotating (ie. not in zope). A pure logfile doesn't reveal useful informations anyway without some processing. Related question: Is there away to stop zope's logging, as apache as proxy logs fine for me? cheers, oliver

1 0

Help with Nested ZSQL methods
by paul_s_johnson＠urscorp.com 29 Nov '00

29 Nov '00

I thought I saw this answer to this one time on http://www.zope.org once, but for the life of me I cannot seem to find it. I have two ZSQL methods, both tested and work. ZSQL method 1 =========================== method id= sql_get_schedules SELECT * FROM Schedules WHERE JobID = <dtml-var JobID> ORDER BY SchedSeq ZSQL method 2 =========================== method id= sql_get_items SELECT * FROM Items WHERE SchedID = <dtml-var SchedID> ORDER BY ItemNo These two tables are linked by the common field "SchedID" Here's the operative part of the dtml method that calls these methods: ============================================== <dtml-in sql_get_schedules> <TABLE BORDER="3"> <TR><TH>Item No.</TH><TH>Description</TH><TH>Mn/DOT No.</TH><TH>Units</TH></TR> <dtml-in sql_get_items> <TR> <TD><dtml-var ItemNo></TD> <TD><dtml-var Description></TD> <TD><dtml-var MnDOTNo></TD> <TD><dtml-var UnitDescription></TD> </TR> <dtml-in> <TABLE> </dtml-in> ============================================== I get the error: Error Type: Bad Request Error Value: ['SchedID'] I suspect there is some type of namespace-related problem going on here where the var SchedID is not getting passed to the internal ZSQL method. P. Johnson P.S.: I must Lotus Notes ( http://www.iarchitect.com/lotus1.htm ) at my place of employment. Any errantly inserted HTML or other weird garbage not intentional.

1 0

exchange parameters between DTML Documents
by Andrei Belitski 29 Nov '00

29 Nov '00

HI! In dependance of a link I would like to pass some document name as parameter to another DTML Document which displays for example the properties of the parameter document. How can I do it? I would appreciate any hints, thank you in advance

2 1

Zope restarting itself?
by Martin Winkler 29 Nov '00

29 Nov '00

Hi listies, maybe someone of you heard of a feature that Zope can restart itself when it dies abnormally. (Linux/Unix version). I found such a service for Windows NT, but not for Linux, although I am sure that I saw it a while ago somewhere... Is this just a parameter for z2.py or is there a special program for this task? Hoping for help, Martin -- Sent through GMX FreeMail - http://www.gmx.net

3 2