April 2000 - Zope - Zope lists

dtml-calendar efficiency?
by Michael Ciavarella 06 Apr '00

06 Apr '00

Hi all, I've been bouncing around the idea of adding an optional tag parameter 'batchMethod' to the <dtml-calendar> tag. This parameter would specify a method that could be used to pre-fetch data in the date range being rendered. Rather than reinventing the wheel, is there another (ie already exists) way to efficiently back the <dtml-calendar> tag with a ZSQL method? With the standard "usage", the tag issues one call to the method (i.e. one query) for each date on the presented calendar. Thanks in advance mike

1 0

PTK Issue Tracker
by Yanko, Curtis (GSP) 06 Apr '00

06 Apr '00

Is that tracker the iTracker product or something new? -Curt Yanko

2 1

Problems with invalid email id's and sendmail tag
by Daniel.Weber＠SEMATECH.Org 06 Apr '00

06 Apr '00

our local smtp server apparently returns an error when an invalid local address is sent via the sendmail tag. This is not a problem when there is only one email address on the To: line, but I have several forms that mail to multiple recipients, so the error bombs the entire mail. Note that sending an invalid email address to a remote server works fine and I get the reaction I want - an email to the From: account stating there was an invalid address so I can clean it up. Is this an smtp issue or is there some way to clean it up? Is the sendmail code in mailhost.py the place to work on it? If any mail gurus have any suggestions, I'd appreciate it. Right now I'm writing an external method to parse the returned error, get the invalid address, strip it from the To: list, mark the email id as bad and try to resend the message. It's a rather long, awful looking piece of work....

1 0

Re: Newbie method rendering question -- Squishdot
by Larry Albert 06 Apr '00

06 Apr '00

I tried this again, but I'm still having problems. I would like to include the contents of a Squishdot site, which is at /squish/index_html, within a DTML method at /Squishmirror. After some offline suggestions following my earlier post, I've tried <dtml-var squish> in Squishmirror, which gets me simply the phrase "<Products.Squishdot.Squishdot.SquishSet instance at 12cdce0>" encoded in the HTML of the output. Same result for <dtml-var "_.getitem('squish', 1)"> and <dtml-var "squish()">. However, <dtml-var "squish"> gets me "<SquishSite instance at 011EF790>" in the HTML, as does <dtml-var "_.getitem('squish', 0)">. One of these should have worked, shouldn't it? Or is there something about products, or Squishdot in particular, that resists being called this way? Do I need to pass the site a different namespace somehow? I'd like to be able to include the method, not just redirect to it. Any help would be appreciated. Larry Albert lda(a)rice.edu Earlier post: >I would like to include the contents of a Squishdot site, which is at /squish/index_html, within a DTML method at /Squishmirror. In Squishmirror if I use > ><dtml-with squish> > <dtml-var "index_html()"> ></dtml-with> > >it gives me an error, seemingly in the process of rendering /index_html (not the /squish/index_html that I want.) If I instead try > ><dtml-with squish> > <dtml-var "squish.index_html()"> ></dtml-with> > >it gives me an error because it can't render the first siteheader variable within /squish.index_html. > >Is it not possible to render a product from a different location? Or am I just getting the calling syntax wrong? (Or both?) > >Thanks for any help, > >Larry Albert >lda(a)rice.edu >

2 1

RE: [Zope] Nested ZSQL methods
by Marcus Collins 06 Apr '00

06 Apr '00

Perhaps details() returns a column called 'author'? Just a guess. hth, -- Marcus > -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: 06 April 2000 12:09 > To: Zope List > Subject: [Zope] Nested ZSQL methods > > > Hi, > I *thought* I was getting Zenned up. Maybe not :( > > I have two ZSQL methods in the same folder called 'LTSN', 'details' > and 'author', where output from 'details' is used to query 'author' > for information, ie > > <dtml-in "details(new_id=tst_id)"> > <dtml-in "author(code=Contact_Shortcode)"> > <dtml-var Firstname> <dtml-var Surname><br> > </dtml-in> > </dtml-in> > > This gives a TypeError. > > Traceback (innermost last): > File /home/MEDFAC_SERVER/lib/python/ZPublisher/Publish.py, line > 165, in publish > File /home/MEDFAC_SERVER/lib/python/ZPublisher/mapply.py, > line 160, in mapply > (Object: more) > File /home/MEDFAC_SERVER/lib/python/ZPublisher/Publish.py, line > 102, in call_object > (Object: more) > File /home/MEDFAC_SERVER/lib/python/OFS/DTMLDocument.py, line 166, > in __call__ > (Object: more) > File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_String.py, > line 502, in __call__ > (Object: more) > File > /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_In.py, line > 691, in renderwob > (Object: details(new_id=tst_id)) > File > /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_In.py, line > 633, in renderwob > (Object: author(code=Contact_Shortcode)) > File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_Util.py, > line 335, in eval > (Object: author(code=Contact_Shortcode)) > (Info: Contact_Shortcode) > File <string>, line 0, in ? > TypeError: call of non-function (type string) > > Thing is, that this code works fine. > > <dtml-in "details(new_id=tst_id)"> > <dtml-in "LTSN.author(code=Contact_Shortcode)"> > <dtml-var Firstname> <dtml-var Surname><br> > </dtml-in> > </dtml-in> > > Can anyone enlighten me here? This is baffling... > > cheers > tone. > ------ > Dr Tony McDonald, FMCC, Networked Learning Environments Project > http://nle.ncl.ac.uk/ > The Medical School, Newcastle University Tel: +44 191 222 5888 > Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2 > > _______________________________________________ > 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 ) >

2 1

Nested ZSQL methods
by Tony McDonald 06 Apr '00

06 Apr '00

Hi, I *thought* I was getting Zenned up. Maybe not :( I have two ZSQL methods in the same folder called 'LTSN', 'details' and 'author', where output from 'details' is used to query 'author' for information, ie <dtml-in "details(new_id=tst_id)"> <dtml-in "author(code=Contact_Shortcode)"> <dtml-var Firstname> <dtml-var Surname><br> </dtml-in> </dtml-in> This gives a TypeError. Traceback (innermost last): File /home/MEDFAC_SERVER/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/MEDFAC_SERVER/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: more) File /home/MEDFAC_SERVER/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: more) File /home/MEDFAC_SERVER/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: more) File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: more) File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_In.py, line 691, in renderwob (Object: details(new_id=tst_id)) File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_In.py, line 633, in renderwob (Object: author(code=Contact_Shortcode)) File /home/MEDFAC_SERVER/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: author(code=Contact_Shortcode)) (Info: Contact_Shortcode) File <string>, line 0, in ? TypeError: call of non-function (type string) Thing is, that this code works fine. <dtml-in "details(new_id=tst_id)"> <dtml-in "LTSN.author(code=Contact_Shortcode)"> <dtml-var Firstname> <dtml-var Surname><br> </dtml-in> </dtml-in> Can anyone enlighten me here? This is baffling... cheers tone. ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

1 0

RE: Problem with dtml-in
by a.wacknitz＠francotyp.com 06 Apr '00

06 Apr '00

> Hello, > > I moved my SQL-queries to a folder named SQL. > Now <dtml-call "SQL.sqlMyQuery"> works fine but <dtml-in > "SQL.sqlMyQuery"> gives me a KeyError with an error value of > 0. What am I doing wrong? Ok, I found the solution: <dtml-in "SQL.sqlMyQuery()"> did it... Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

How to pass parameters containing single quotes to ZSQL Methods?
by Jason Wong 06 Apr '00

06 Apr '00

I want pass something like: day='Monday' to a ZSQL method using this <dtml-in "qry_Controller_Info_List(_.None, _, criteria='day=''Monday''')"> As it stands it doesn't work, I get this error: Error Type: sql.error Error Value: ('07001', -3010, '[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.') tia - Jason Wong Digital View Ltd 2201 Nanyang Plaza 57 Hung To Road Kwun Tong HONG KONG Tel: +852-2861-3615 Fax: +852-2520-2987 www.digitalview.com

1 0

Problem with dtml-in
by a.wacknitz＠francotyp.com 06 Apr '00

06 Apr '00

Hello, I moved my SQL-queries to a folder named SQL. Now <dtml-call "SQL.sqlMyQuery"> works fine but <dtml-in "SQL.sqlMyQuery"> gives me a KeyError with an error value of 0. What am I doing wrong? TIA, Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

Return object from a ZSQL method
by Allen Wallis 06 Apr '00

06 Apr '00

Hi, I'm still puzzled by the actual type of the object returned from a ZSQL method (a SELECT query). At the moment I've been getting by with something along the lines of <dtml-let results="queryDatabase"> <dtml-if "results"> Results: <dtml-in results> <dtml-var col_name> ... </dtml-in> <dtml-else> No Results </dtml-if> </dtml-let> where col_name is some column name, and queryDatabase is my ZSQL method. However I now have the case where this is not working as expected. The results object returned always evaluates true when tested (even when empty). Also, when I tried to use the _.len(results) method, it always returns 1. I thought it might return the number of records that were found in the SQL query. Can someone please explain where I'm going wrong, and possibly also tell me the type of object that is returned by a ZSQL method. I've been reading the ZSQL manual but can only find how to use your own class. thanks Allen

1 0