August 1999 - Zope - Zope lists

ANN: SQLPackage v 0.1 available
by Paolo Bizzarri 20 Aug '99

20 Aug '99

Hi Zopers, version 0.1 of the SQLPackage is available. No docs currently available, apart from this mail. SQLPackage is available from my zope page: http://www.zope.org:18200/Members/pibizza/SQLPackage.bbe You have to download it, put in your import directory in the zope dir, and then import from the Zope interface. For usage, you have to put all the DTML and SQL methods high in your Zope tree. They should be visible from where you call them. Then, for each table you want to use (for example orders) with SQLPackage, create a folder (for example Orders). In the folder properties, add the table_name (the name of the sql table), the table_id (the name of the unique id of the table) and the table_title (the name of the table you want to show on the WEB). Then, in the folder just created, create a DTML method called ShowRecordForm. Follow the example given in the TableFolder contained in the distribution. You have to use as input fields the name of the fields of the table (in our example, orders). To really use the thing, now you can do as follows: - to call the insert form, use name_of_the_table_folder/InsertForm. In our example, this means Orders/InsertForm. This will show an insert form, with all the fields you have put in the ShowRecordForm. - to call the delete form, use name_of_the_table_folder/DeleteForm?your_table_id=some_value. In our example, this could mean Orders/DeleteForm?order_id=17. This will show you a request for confirming the delete of the record n. 17 from your order table. - to call the update form, use name_of_the_table_folder/UpdateForm?your_table_id=some_value. In our example, this would mean Orders/UpdateForm?order_id=14. This will show you a form with all the fields you have put in the ShowRecordForm. Not much more to say. The connection used is a mysql connection that use the test db (which is standard in all the distributions of mysql I have seen). Try and enjoy. Ciao Paolo -- Paolo Bizzarri - Responsabile Marketing I3 Icube Srl Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: p.bizzarri(a)icube.it WWW: www.icube.it Tel: (+39) 050 97 02 07 Fax: (+39) 050 31 36 588

1 0

pcgi error message.
by Andreas Kostyrka 20 Aug '99

20 Aug '99

Hi! At the moment I'm a bit stymified about a nonworking ZOPE :( So what exactly does this mean: Temporarily Unavailable The resource you requested is temporarily unavailable - please try again later. (102) failure during connect Andreas -- Andreas Kostyrka | andreas(a)mtg.co.at phone: +43/1/7070750 | phone: +43/676/4091256 MTG Handelsges.m.b.H. | fax: +43/1/7065299 Raiffeisenstr. 16/9 | 2320 Zwoelfaxing AUSTRIA

2 9

RE: [Zope] pcgi error message.
by Rob Page 20 Aug '99

20 Aug '99

> At the moment I'm a bit stymified about a nonworking ZOPE :( > > So what exactly does this mean: > > Temporarily Unavailable > > The resource you requested is temporarily unavailable - > please try again later. > > (102) failure during connect Usually stuff like this means that you're PCGI info file is not correclty configured. The PCGI executable couldn't connect to the zope process for some reason. --Rob

1 0

RE: [ZDP] Two How-Tos
by Paul Everitt 20 Aug '99

20 Aug '99

OK, I just added these two to the Catalog. A search for "looping" shows your first How-To. Thanks Tony! BTW, for those of you getting KeyErrors on searches...we're hoping to fix that today. For the time being, do your searches by going to the Search page. --Paul > -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Friday, August 20, 1999 9:01 AM > To: Zope List; zdp(a)zope.org > Subject: [ZDP] Two How-Tos > > > Simple one on DTML looping > http://www.zope.org:18200/Members/tone/looping > and another one on upgrading a Zope distribution > http://www.zope.org:18200/Members/tone/upgrade > > comments etc. welcomed. > tone out. > ------ > 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 > > _______________________________________________ > ZDP maillist - ZDP(a)zope.org > http://www.zope.org/mailman/listinfo/zdp >

1 0

RE: [Zope] Authorization error with for missing values ??
by Brian Lloyd 20 Aug '99

20 Aug '99

> In article <37BD187F63.62E6BRIAN(a)smtp.garage.co.jp>, Brian Hooper > <brian(a)garage.co.jp> writes > >This works fine if none of the birthdates are NULL; however > if birthdate > >is NULL, then I get an authorization dialog, even though I am already > >logged into Zope as a Manager in the top-level acl_users folder. The > >only way to get past the authentication dialog is to log in > as the Zope > >superuser. > > I think this is an old unaddressed bug. Any Zsql method that > returns a > set containing nulls brings up the authentication challenge. > Goes back > at least to 1.11pr1. Hi guys, This has been fixed in 2.0.0b5. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

RE: [Zope] Slice Bug in Zope 2b5 ?
by Paul Everitt 20 Aug '99

20 Aug '99

Hello Oliver. It is _very_ important to file this kind of bug in the Collector: http://www.zope.org/Collector/ This is how we are tracking what needs to be done for a final release. Thanks! --Paul > -----Original Message----- > From: Oliver Dissars [mailto:oliver@dissars.de] > Sent: Friday, August 20, 1999 8:53 AM > To: zope(a)zope.org > Subject: [Zope] Slice Bug in Zope 2b5 ? > > > Hello, > > since I installed the b5 of Zope 2 I can not use anymore the > slicing function for > database result sets. The following query works with b4 > without any problems: > > select > LastName as Nachname, > FirstName as Vorname, > Company as Firma > from contacts > order by LastName > .............. > > > Wenn I try to use the result slicing for database queries in > b5, Zope generates > this error message: > > ------------------------- cut here > -------------------------------------- > Error Type: TypeError > Error Value: slice index must be int > > Traceback (innermost last): > File > /test/Zope-2.0.0b5-src/lib/python/ZPublisher/Publish.py, line > 209, in publish_module > File > /test/Zope-2.0.0b5-src/lib/python/ZPublisher/Publish.py, line > 179, in publish > File /test/Zope-2.0.0b5-src/lib/python/Zope/__init__.py, > line 199, in zpublisher_exception_hook > (Object: list_all_contacts_2) > File > /test/Zope-2.0.0b5-src/lib/python/ZPublisher/Publish.py, line > 165, in publish > File > /test/Zope-2.0.0b5-src/lib/python/ZPublisher/mapply.py, line > 154, in mapply > (Object: manage_test) > File > /test/Zope-2.0.0b5-src/lib/python/ZPublisher/Publish.py, line > 102, in call_object > (Object: manage_test) > File > /test/Zope-2.0.0b5-src/lib/python/Shared/DC/ZRDB/DA.py, line > 307, in manage_test > (Object: list_all_contacts_2) > File > /test/Zope-2.0.0b5-src/lib/python/DocumentTemplate/DT_String.p > y, line 502, in __call__ > (Object: <string>) > File > /test/Zope-2.0.0b5-src/lib/python/DocumentTemplate/DT_In.py, > line 610, in renderwb > (Object: list_all_contacts_2) > File > /test/Zope-2.0.0b5-src/lib/python/DocumentTemplate/DT_InSV.py, > line 388, in __getitem__ > File > /test/Zope-2.0.0b5-src/lib/python/DocumentTemplate/DT_InSV.py, > line 212, in query > TypeError: (see above) > ------------------------- cut here > -------------------------------------- > > > Changend anything from b4 to b5 for slicing? > > > Thanks. > > regards, > Oliver > > > > > > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Something about DataTime!
by Elaine Kong 20 Aug '99

20 Aug '99

Hello! I am the first time use the Zope.I have some questions when i am using Zope.I want to make a web page of news. The news that after the current date will not display in the web page? How can i do that? How can i get the current date? I have some idea but i don't know that is correct or not.The idea is set a property to the DTML Document,called expire. If the news is after the expire that won't display in the web page. For example, i have a DTML Document called news1 and i set a property (expire) to it . How can i call it's property (expire) ? How to compare with the current date? Please help me to solve these questions. Thank you very much. Elaine Kong. My E-mail address: elainekong(a)hutchcity.com

2 1

from 1.10.3 to 2.0 ?
by Joachim Schmitz 20 Aug '99

20 Aug '99

how can I import a 1.10.bbe file into 2.0. I know I read about a conversion script, but I don't find it in b5. Gruß Joachim Schmitz WWW-Consultant email: js(a)ac-copy.net tel: +49-241-89491-0 fax: +49-241-89491-29

1 0

RE: [Zope] pcgi error message.
by Brian Lloyd 20 Aug '99

20 Aug '99

> Hi! > > At the moment I'm a bit stymified about a nonworking ZOPE :( > > So what exactly does this mean: > > Temporarily Unavailable > > The resource you requested is temporarily unavailable - > please try again later. > > (102) failure during connect > > Andreas Andreas, This *usually* means one of several things: o (Most common) the user "nobody" (or whatever user your web server runs as) doesn't have permission to read and/or write in the var directory of your installation. If you are using ZServer w/PCGI, nobody should only need read (but the user that you are running ZServer as must have read and write). If you are using PCGI alone to crank up the process by itself, then nobody will need both read and write in the var directory. o if you are using PCGI w/ZServer, something bad could have happened at startup and the PCGIServer isn't listening (so the pcgi-wrapper fails to connect). Usually this would cause ZServer to fail to start, though. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

RE: [Zope] How to hack the standard_html_header
by Paul Everitt 20 Aug '99

20 Aug '99

BTW, this is a feature we are going to add to the Personalization. That is, give you a spot to supply your own CSS (without having to maintain your own std header). --Paul > -----Original Message----- > From: Stephan Richter [mailto:SRichter@ixl.com] > Sent: Thursday, August 19, 1999 11:22 PM > To: zope(a)zope.org > Subject: [Zope] How to hack the standard_html_header > > > Hello guys, > > Just wanted to ask how you can edit the standard_html_header > at the Zope Portal. > I really would like to do this, so I can put my own CSS at > the right spot. > > thanks, > stephan > -- > Stephan Richter > iXL - Software Designer and Engineer > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1