- Zope - Zope lists

ANN: P SQL Input Wizard 1.0.1
by Paulo Eduardo Neves 27 Apr '99

27 Apr '99

Since people asked for it, here is a new version of the input wizard. You can download from the usual place: http://www.zope.org/Download/Contrib/sqlinputwiz1.0.tar.gz New Features (from WHAT's NEW): 1 - Thanks to Anthony Baxter <anthony(a)interlink.com.au> now the Wizard supports Oracle and Sybase databases; 2 - You can make a column optional. If the column id isn't acessible by the insert sql method, then it doesn't take part in it. This way the row will have the database default value; 3 - If a string type can be null in the database then the sqlvar type is nb, instead of string; 4 - A quit button in every page for leaving the wizard before finishing. This way you won't leave garbage in the object database. Here a quick description from the README file: P MySQL Input Wizard will help you to create database insert interactions. Just select the tables and columns where you want to insert data and the wizard will create: 1. A form where you can fill your data 2. A SQL method with the correct command 3. A result page that calls the SQL method ... Advantages of using the wizard: o You won't have to learn Zope syntax to insert data in your DB:-) o No need to remember all your database tables and columns names o No more typos when writing your database insert forms and methods o Have consistent naming in forms and SQL variables o Waste your time building a usable interface, instead of writing repetitive code and looking for DB info The Wizard is reported to work with MySQL, Oracle 8.0.5 and Sysbase/MS SQL Server 6.5. It's very easy to adapt to other DBs. To do it take a look at comments in file DBInfo/InfoBase.py, and use the implemented DBs as examples. I welcome feedback. regards, -- Paulo Eduardo Neves mailto:neves@inf.puc-rio.br PUC-Rio de Janeiro

3 2

Zope Code Exchange
by Jordan B. Baker 27 Apr '99

27 Apr '99

I have been working on a site that will allow people to contribute files into various categories. I was wondering if there would be any interest in a site for DTML and external methods to be categorized, searched and downloaded? Something along the lines of the PHP code exchange (http://px.sklar.com) Anyways, a couple questions: 1) Does anyone else think this is a good idea? 2) Does anyone know of other examples of this kind of site that we can draw on for inspiration? I think a Zope Code exchange would be a great place for new users to find common solutions to problems, also for seasoned users to find well-written methods so they don't have to re-invent the wheel. ------- Jordan B. Baker -- jbb(a)spyderlab.com weaving the web @ http://www.spyderlab.com

4 3

Database hosed!?
by Bill Anderson 27 Apr '99

27 Apr '99

Hello, after restarting one of my Zope servers, it fails and I get the following: ... raise DatabaseError, ( DatabaseError: The database contains records, starting at position 112192, that have time stamps 629676609.614 seconds in the future. This could lead to database corruption. Please double check your system clock! Now just how hte heck do I fix this one? (outside of modifying the code to ignore the date and hope I can fix it once it is up and running?) System info: ============ ZopeHTTPServer Latest non-CVS version DEC Alpha Linux 2.2.1 RH 5.2 (standard glibc) __ Bill

4 5

New versions of a product
by Robert Leftwich 27 Apr '99

27 Apr '99

What is the best strategy to use when upgrading to a new version of a Zope Product that is already in production and has significant amounts of data in it? The issues are : 1. Modified hierarchy of objects 2. New classes/objects - not a problem as they don't exist in the earlier version. 3. Deleted classes/objects (i.e. no longer required) 4. Renamed classes/objects 5. New methods/attributes - not a problem as they don't exist in the earlier version. 6. Deleted methods/attributes (i.e. no longer required) 7. Renamed methods/attributes Robert Leftwich

2 1

I want to stream data through an external method.
by Jay, Dylan 27 Apr '99

27 Apr '99

What I have is several large files for downloading that I don't want to put inside BoboPOS as importing them seems to take forever. It is also more convienient if they exist outside the OODB. So what I want to do is for the user to dl the file through Zope. I have the following external method that works def serveFile(self, file, RESPONSE): RESPONSE.setHeader('Content-type', 'application/x-msdownload') dl_name = "C:/Provision/downloads/"+file dl_file = open(dl_name,'rb') retval = dl_file.read() dl_file.close() return retval However I think this is quite inefficient and will probably not work when large number of users attempt to download the same file at the same time. Anyone have a better solution?

1 0

Re: [Zope] Authentication with ie5 and zope.
by Martijn Pieters 27 Apr '99

27 Apr '99

At 06:32 27/04/99 , Jay, Dylan wrote: >Has anyone found a solution to basic authentication with ie5 and iis4.0. >This is HUGE problem for me as my site has to go live in less than a week >and it relies on have users authenticate themselves through the UserDB >package. If they can't use ie5.0 to do this, then I have a big problem. > Yes, it's a bug/feature of IIS 4.0. I wrote a HOWTO on repairing it, it's now at: http://www.zope.org/Support/SupportFAQ/2/view?doc=4 (IIS4 Custom Errors prevent authentication). -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | Tel: +31-35-6254545 Fax: +31-35-6254555 | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ------------------------------------------

1 0

Authentication with ie5 and zope.
by Jay, Dylan 27 Apr '99

27 Apr '99

Has anyone found a solution to basic authentication with ie5 and iis4.0. This is HUGE problem for me as my site has to go live in less than a week and it relies on have users authenticate themselves through the UserDB package. If they can't use ie5.0 to do this, then I have a big problem.

1 0

online shopping cart frame work for zope?
by Joseph Skinner 27 Apr '99

27 Apr '99

Hi I was wondering if anyone had an example framework for a shopping cart system done in zope. I am currently looking into building this sort of thing and am looking for some example code to get me started. Thanks in advance Joe. -- Joseph Skinner joe(a)snail.earthlight.co.nz ---------------- interesting quote goes here ------------------------- Analyst Programmer Earthlight Communications 100% Dunedin owned and operated

1 0

RE: [Zope] Has anyone tried to make Zope invisible using IIS
by Jay, Dylan 27 Apr '99

27 Apr '99

I tried using the isapi filter and it only sort of works. Any links of the first page use the original address not the one that was filtered. What I would like is for it to be completely transparent ie all links point to the virtual directory not the exe file. I assume this doesn't work because of the BASE tag that zope puts in the header. It also won't work because of my use of BASE0..n tags etc. How can these problems be overcome? > -----Original Message----- > From: Brian Lloyd [mailto:Brian@digicool.com] > Sent: Thursday, 15 April 1999 23:58 > To: 'Jay, Dylan'; 'zope(a)zope.org' > Subject: RE: [Zope] Has anyone tried to make Zope invisible using IIS > > > > I basically want to make a virtual directory that points to > > everything on > > the other side of the PCGI exe file however stupid IIS seems > > to be only able > > to make a real directory a virtual directory. Has anyone > > found a way around > > that? > > Isn't IIS great? :^) > > I spent some time looking into this about a year ago, and found > that the only way to do this (at least at that time) was to > write an IIS filter dll in C. I imagine that look on your face > right now about matches the one on mine when I came to this > conclusion... :) > > I've attached a .zip file containing the msvc++ project and > sources for a _very_ minimal, hard-coded url alias filter - > it worked with IIS3, but I can make no guarantees about IIS4+. > > There's no documentation for it (though the code is quite tiny) > and it's _totally_ unsupported, so you'll have to look to MS' > IIS extension/filter documentation for details on how to get it > installed, built, what it's doing, etc. Hopefully it's a start > though. > > I'm sure that the Zope community would love to see a more > flexible version of it though, if you'd care to fix it up :^) > > Hope this helps! > > > Brian Lloyd brian(a)digicool.com > Software Engineer 540.371.6909 > Digital Creations http://www.digicool.com > > > > >

1 0

RE: [Zope] How to expire cookie in DTML
by Shaw, Howard 26 Apr '99

26 Apr '99

Howard C. Shaw III Programmer/SysAdmin St. Thomas High School > ---------- > From: Philip Aylesworth[SMTP:zopelist@regalint.com] > Sent: Monday, April 26, 1999 2:44 PM > To: zope(a)zope.org > Subject: [Zope] How to expire cookie in DTML > > How can I expire a cookie in DTML? > > I think I can figure out how to do it in an external but it would be > more convenient to do it in DTML. > > Phil A > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0