- Zope - Zope lists

Newbie Alert how to make Zope work off line
by stefano.ciccarelli＠thewhitebird.com 14 Feb '01

14 Feb '01

Hi, I would like to know if there is any way to run Zope without being connected to the Internet. It would be very useful to me to minimise connection time, since I have a dial up connection home. I am running Zope 2.2.5 on Win 95. My Internet connection uses DHCP Thanks, Stefano

4 3

constraint in postgres
by Olaf Zanger 14 Feb '01

14 Feb '01

hi there, i want to make some constraint-restrictions with two tables in postgres create table address ( id serial, country_id int4, ....); and create table country (id serial, ...); i want to make sure that the country-row with "id=2" is not deleted if there is still a corresponding data-set with "country_id=2" in the address table. e.g. address: 1, 2, ... country: 2, ... now country wouldn't be allowed to be deleted. how to do that? thanks fo help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

3 2

Editing with Emacs in Zope 2.3.0
by Anselm Lingnau 14 Feb '01

14 Feb '01

I'm trying to use Emacs with ange-ftp to edit DTML code on a remote Zope 2.3.0 server. My problem is that, when I want to edit a DTML document with a pathname like »/user@host 8021:/foo/bar/baz«, first of all I get a dired buffer offering me »baz« (and nothing else), which is then opened with the name »/user@host 8021:/foo/bar/baz/baz« (in spite of the fact that »baz« is not a directory). Then afterwards saving the DTML document fails (which is probably to be expected). Has anybody else experienced this? I've read the Using Emacs with Zope howto but it doesn't mention problems like this. Anselm -- Anselm Lingnau ......................... lingnau(a)tm.informatik.uni-frankfurt.de An experienced pickup truck driver is a person who's wrecked one. An inexperienced pickup truck driver is a person who's about to wreck one. -- P. J. O'Rourke, *High Speed Performance Characteristics of Pickup Trucks*

2 1

RE: [Zope] [Zope]: export to excel
by Farrell, Troy 14 Feb '01

14 Feb '01

Subrahmayan, I can't speak for everyone you write to, but you should probably just send your requests to the zope(a)zope.org list. You need to write a method that writes the data out as comma separated values. To work with IE, you need to make your method name end with ".csv". You should also do a <dtml-call "REQUEST.set_header('Content-Type', 'application/vnd.ms-excel')"> or try <dtml-call "REQUEST.set_header('Content-Type', 'text/csv')"> Troy -----Original Message----- From: K H Subrahmanyan [mailto:subrahmanyan.kalathur@wipro.com] Sent: Wednesday, February 14, 2001 5:37 AM To: Dieter Maurer; curtis(a)cardgate.net; zope(a)pri-um.com; webmaven(a)lvcm.com Cc: zope(a)zope.org Subject: [Zope] [Zope]: export to excel hi, I would like to export the data in my zope database to excel. I have done the reverse process that is, I have stored the excel file in text format and imported the data into my database and now I want to export back. is there any method. thanks in advance. subrahmayan _______________________________________________ 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] ZOPE : SQL methods
by Dieter Maurer 14 Feb '01

14 Feb '01

K H Subrahmanyan writes: > I am using zope and gadfly for my project. > but while using the SQL methods, I get the error if I use the "like" option. > > E.g.. select * > from table > where > Emp_name like "*rama*" > > I will get the following error. Maybe, you should look at an SQL book or other SQL description... 1. strings are surrounded by '...' not "..." 2. the "match sequence" wildcard is "%" not "*" Dieter

5 6

VirtualHostMonster
by Jason C. Leach 14 Feb '01

14 Feb '01

hi, What's VirtualHostMonster and where can I track it down? j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

4 3

RV: [Zope] Z2 CONFLICT Competing writes at...
by Juan Carlos Coruña 14 Feb '01

14 Feb '01

> -----Mensaje original----- > De: Chris Withers [mailto:chrisw@nipltd.com] > Enviado el: miércoles, 07 de febrero de 2001 0:06 > Para: Juan Carlos Coruña; zope(a)zope.org > Asunto: Re: [Zope] Z2 CONFLICT Competing writes at... > > > > What means this error? > > It means two Zope threads were trying to modify something in the dealer > folder at the same time, and in such a way that one thread held onto the > object for so long that the other one timed out... > > > After upgrading from Zope-2.2.5 to 2.3.0 I became this error > > What products do you have installed? > SQLSession and Z MySQL. > What kind of object is 'dealer' and what kind of objects are contained > within it? > dealer is a folder and contains dtml methods, dtml document, python scripts, folders, access rule, MySQL database connection, sesion folder, external method. > cheers, > > Chris

1 0

Zope multiIP
by Ruberl Michele 14 Feb '01

14 Feb '01

Hi everybody, I have Zope running on a machine which has a few IP addresses. Is it somehow possible to make it listen on port 8080 of just one or some of these IPs, as for instance is possible in Apache with the Listen directive? Thank you Michele

3 2

Re: [Zope] Z2 CONFLICT Competing writes at...
by Chris Withers 14 Feb '01

14 Feb '01

You should really reply to the list as well. Sorry, I can't help you with this :-S Chris Juan Carlos Coruña wrote: > > > -----Mensaje original----- > > De: Chris Withers [mailto:chrisw@nipltd.com] > > Enviado el: miércoles, 07 de febrero de 2001 0:06 > > Para: Juan Carlos Coruña; zope(a)zope.org > > Asunto: Re: [Zope] Z2 CONFLICT Competing writes at... > > > > > > > What means this error? > > > > It means two Zope threads were trying to modify something in the dealer > > folder at the same time, and in such a way that one thread held onto the > > object for so long that the other one timed out... > > > > > After upgrading from Zope-2.2.5 to 2.3.0 I became this error > > > > What products do you have installed? > > > SQLSession and Z MySQL. > > What kind of object is 'dealer' and what kind of objects are contained > > within it? > > > dealer is a folder and contains dtml methods, dtml document, python scripts, folders, access rule, MySQL database connection, sesion folder, external method. > > cheers, > > > > Chris

1 0

Connecting to MySQL
by Donald Braman 14 Feb '01

14 Feb '01

I'm finding it difficult to put all the pieces together to MySQL enable Zope. I know I need MySQL-python-0.3.x and the ZMySQLDA ... and that to install those I need distutils ... but I'm running MySQL 3.23.33 on RedHat 7.0 and the distutils setup.py is conking out (I think) because all the directories are different. Is there an easier way? If not, can someone hold my hand a bit and tell me what files/directories I need to specify in the setup.py. I'm fairly new (two days with) Zope, (one day with) MySQL, and Python. -Don

2 1