January 2001 - Zope - Zope lists

Zope 2.3
by Tom Deprez 21 Jan '01

21 Jan '01

To all who feels him/herself addressed : Congrats to the new look of zope! And to the new implemented products! All I can say is ... keep up the good work! Regards, Tom.

1 0

Creating PDF's
by Tom Deprez 21 Jan '01

21 Jan '01

Hi, I read in Itamar's 'A Developers Guide to learning Zope' about 'Reportlab'. It is a python library to create pdf files. Is there somebody among here who already used this library with zope? And is it possible to give a little example in how we can use it with zope? Thanks in advance, Tom.

4 4

ZSQL: postgres, SELECT INTO
by Steve Drees 21 Jan '01

21 Jan '01

Has anybody selectively used SELECT INTO with zope/postgres? Zope version: Zope 2.1.6 (binary release, python 1.5.2, linux2-x86) Python version: 1.5.2 (#10, Dec 6 1999, 12:16:27) [GCC 2.7.2.3] System Platform: linux2 ZPyGreSQLDA-0-0-3 I'm trying something like: SELECT DISTINCT song, ipadress, date INTO TEMP d_requests FROM requests WHERE date > <dtml-sqlvar startdate type="string"> <dtml-var sql_delimiter> SELECT COUNT(*) AS num_requests, song FROM d_requests GROUP BY song --------- works fine under psql zope raises an exceptions.ValueError and the db connection dies. traceback follows:

2 2

Zope, emacs & secure ftp
by Geoffrey L. Wright 21 Jan '01

21 Jan '01

Was just wondering what sort of solution people use for secure ftp and zope. I'd like to be able to use efs (or ange-ftp) over a secure connection to zope so I can do development using efs outside of our firewall. Does Zope's ftp server support SSL? Or is there some sort of SSH-based solution? Just curious... //glw

1 0

RE: [Zope] if-else using ZSQL resultset & sendmail query
by Randall F. Kern 20 Jan '01

20 Jan '01

<dtml-in ...> <dtml-if sequence-even> bgcolor is white ... <dtml-else> bgcolor is grey ... </dtml-if> </dtml-in> If you really need the "resultset number", you can use sequence-number. As for <dtml-sendmail> and news, it only sends mail via SMTP, so it can't be used to post news. -Randy -----Original Message----- From: Lee [mailto:lee.reilly@ntlworld.com] Sent: Saturday, January 20, 2001 1:48 PM To: zope(a)zope.org Subject: [Zope] if-else using ZSQL resultset & sendmail query Hi, I've got a few questions, which may be answered by saying, "Not possible"! Any feedback would be appreciated. get_testclass_details is a ZSQL method returning user data from a table. I display the data (strangely enough) in an HTML table and I want alternating rows to have different background colours. I figure that the best way to do this is to obtain the resultset number (i.e. is it the 1st, 2nd or 3rd result row) and do something like the following; <dtml-in...> if (the result set number % 2 == 0) bgcolour is white ... else bgcolour is grey ... </dtml-in...> Is it possible to obtain the resultset number? Also, re: sendmail. I still haven't managed to figure out why it's not posting messages to newsgroups. Maybe some folks at digicool could let me know if this isn't supported? Previous message was: I have another question re: sendmail, which I'd be grateful if someone could answer. Am I correct in saying that <sendmail> does not support newsgroup postings? Adding the following to my message seems to work but it is not being posted on the newsgroup... To: lreilly(a)cs.strath.ac.uk Groups: uk.local.glasgow *and* Newsroups: uk.local.glasgow It sends the mail to me; the group is listed in the header file under 'Newsgroups' when I view *my* received message but it is not getting to the newsgroup. Can anyone comment? Thanks very much for your time, - Best regards, Lee _______________________________________________ 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

if-else using ZSQL resultset & sendmail query
by Lee 20 Jan '01

20 Jan '01

Hi, I've got a few questions, which may be answered by saying, "Not possible"! Any feedback would be appreciated. get_testclass_details is a ZSQL method returning user data from a table. I display the data (strangely enough) in an HTML table and I want alternating rows to have different background colours. I figure that the best way to do this is to obtain the resultset number (i.e. is it the 1st, 2nd or 3rd result row) and do something like the following; <dtml-in...> if (the result set number % 2 == 0) bgcolour is white ... else bgcolour is grey ... </dtml-in...> Is it possible to obtain the resultset number? Also, re: sendmail. I still haven't managed to figure out why it's not posting messages to newsgroups. Maybe some folks at digicool could let me know if this isn't supported? Previous message was: I have another question re: sendmail, which I'd be grateful if someone could answer. Am I correct in saying that <sendmail> does not support newsgroup postings? Adding the following to my message seems to work but it is not being posted on the newsgroup... To: lreilly(a)cs.strath.ac.uk Groups: uk.local.glasgow *and* Newsroups: uk.local.glasgow It sends the mail to me; the group is listed in the header file under 'Newsgroups' when I view *my* received message but it is not getting to the newsgroup. Can anyone comment? Thanks very much for your time, - Best regards, Lee

1 0

Zope 2.3.0b2 bug
by Oleg Broytmann 20 Jan '01

20 Jan '01

Hi! Little bug - if there is no items in a folder - there is no "Import/Export" button. :) I have to create a dummy item to import a zexp. Oleg. ---- Oleg Broytmann http://www.zope.org/Members/phd/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

2 2

Re: [Zope] Creating PDF's
by Oliver Bleutgen 20 Jan '01

20 Jan '01

> Hi, > I read in Itamar's 'A Developers Guide to learning Zope' about > 'Reportlab'. > It is a python library to create pdf files. Is there somebody among here > who > already used this library with zope? And is it possible to give a little > example in how we can use it with zope? Tom, I can't give a working example, it's on a server at work, but integrating zope and reportlab is easy. I tried it because I needed a proof of concept and did did nothing advanced, but I got zope to return a pdf which was always created on the fly. If your interested I'll post/send that small example. Take a look at http://www.zope.org/Members/jdavid/TimetableTag/ for a product which utilizes reportlab or search the reportlab mailing list for zope http://www.egroups.com/messagesearch/reportlab-users?query=zope cheers, oliver

1 0

HELP: ZPatterns Installation on Linux
by J. Atwood 20 Jan '01

20 Jan '01

The instructions in the README.txt and on zope.org are a little vague.. How, indeed, do I " build this extension using the included Setup file in the ZPatterns directory" I can see the Setup file but that is about it. I would be more than happy to write up some documentation (on Zope.org) if someone sends me the answer. RH Linux 6.2, Zope 2.2.2, Latest ZPatterns Thanks, J

2 1

batch processing problem
by Timothy Wilson 20 Jan '01

20 Jan '01

Hi everyone, I was trying to throw together a page with some pictures of my brand-new nephew for his parents to show to relatives. What should have been a relatively simple <dtml-in> iteration through a folder full of images has turned out to be headache inducing. I'm sure that there's something I'm just not understanding, but I can't figure out why the following doesn't work. I've tried many different combinations without success. You can see it for yourself at http://208.42.140.222:9673/olsen/cullypics/ (Sorry, DNS problems.) <dtml-var standard_html_header> <h2 align="center">Cullin Isaac Olsen</h2> <h3 align="center">January 17, 2001<br>8 lb. 1 oz., 22 in.</h3> <br> <table align="center" cellspacing="10"> <dtml-in "PARENTS[0].objectValues(['Image'])" size=1 start=query_start sort=display_order> <tr> <td colspan="2"> <span style="font: bold larger Verdana, Arial, Helvetica, sans-serif">Picture #<dtml-var display_order></span><br> <a href="fullsize/<dtml-var id>_fullsize"><dtml-var sequence-item></a> <dtml-if title><h4 align="center"><dtml-var title></h4></dtml-if> </td> </tr> <tr> <td> <dtml-if previous-sequence> <p align="left"><a href="<dtml-var URL><dtml-var sequence-query>query_start=<dtml-var previous-sequence-start-number>"><p align="left">Previous picture</a></p> <dtml-else>   </dtml-if previous-sequence> </td> <td> <dtml-if next-sequence> <p align="right"><a href="<dtml-var URL><dtml-var sequence-query>query_start=<dtml-var next-sequence-start-number>"> Next picture</a></p> <dtml-else>   </dtml-if next-sequence> </td> </tr> </dtml-in> </table> <dtml-var standard_html_footer> Any ideas? -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/ W. St. Paul, MN | | http://slashdot.org/ wilson(a)visi.com | <dtml-var pithy_quote> | http://linux.com/

1 0