March 1999 - Zope - Zope lists

Impact of Zope on hosting provider?
by Robert Wentworth 16 Mar '99

16 Mar '99

Right now my biggest obstacle to setting up a Zope-powered site could be finding a hosting provider I have confidence in who is willing to run Zope. When I asked my first-choice provider about running Zope, they replied: > Though it's true that we can install programs that need root > instlall, it only so when the program is low CPU/mem use and > non-intrusive. Zope is neither, so to run it you would need to get > your own dedicated server through us. A dedicated server is not a viable option for this site at this point in time. So, a few questions: 1) Are the provider's fears justified? What sort of memory footprint, CPU requirements (for a site that should have fairly low traffic at first), and other impact are Zope likely to have on a hosting provider? 2) Would anyone care to let me know what their experience has been with the two hosting providers (NexusWeb and CodeIt Computing) listed as known to host Zope-based sites? (I've been sufficiently badly burned in the past by bad hosting providers that I cannot justify signing up for a provider without positive recommendations or multiple alternatives for backup.) Robert Wentworth

1 0

setting variable
by Tom Jenkins 16 Mar '99

16 Mar '99

Hello folks, I'm stuck on a problem which I hope some one could help me with. I have a database entry form where the user will enter in information for two related tables. When she submits the form, I want to first post one tables information, then call another sql method to get the id generated for that post, then take that value and add it to the REQUEST object and pass it to the second sql insert for inserting to the second table (along with some other parts of the REQUEST object from the form). I'm planning on using MySQL that has a special select: select LAST_INSERT_ID() to return the last auto-generated id value to get the id. I know you can add a variable to the REQUEST object via  but how to I get the value from the sql method? The only way I know now is via #var tags but you can't nest the DTML. I hope this makes sense... -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Linux & Samba 2.0 : The best Windows file server http://www.zdnet.com/sr/stories/issue/0,4537,2196106,00.html "Do not be overcome by evil, but overcome evil with good." Romans 12:21

2 2

#sqltags
by Jordan B. Baker 16 Mar '99

16 Mar '99

Hi: Are the #sqltags documented somewhere? I couldn't find them in the DTML reference manual, etc. I found some examples of their use, but nothing definative. I have no problems reading the source and documenting what I find, I just don't want to be re-inventing the wheel. Specifically I'd like to know about #sqlgroup and friends. ------- Jordan B. Baker -- jbb(a)spyderlab.com weaving the web @ http://www.spyderlab.com

2 1

MySQL LAST_INSERT_ID...
by Tom Jenkins 16 Mar '99

16 Mar '99

To followup my last post, I'm getting an exception when trying to use MySQL's "select LAST_INSERT_ID()" function: Error, exceptions.KeyError: unhandled SQL used: select LAST_INSERT_ID() Anybody have any ideas? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Linux & Samba 2.0 : The best Windows file server http://www.zdnet.com/sr/stories/issue/0,4537,2196106,00.html "Do not be overcome by evil, but overcome evil with good." Romans 12:21

3 5

Re: [Zope] Help - need a brainless guide to getting zope running
by Robin Dunn 16 Mar '99

16 Mar '99

I posted a message last week about running ZServer as a service. You can find the message at http://www.zope.org/pipermail/zope/1999-March/005030.html I built my Zope from source, so I don't know if this works the same as the self-installer version, but it should be pretty close. 1. Install Zope 1.10.2, choosing to run standalone. 2. Untar the ZServer distribution in the root Zope directory. 3. Test that it works by running start.py in the ZServer directory. 4. Follow the directions in the message linked-to above. -- Robin Dunn robin(a)AllDunn.com http://AllDunn.com/robin/ http://AllDunn.com/wxPython/ Check it out! Try http://AllDunn.com/laughworks/ for a good laugh. -----Original Message----- From: Andrew Wooldridge <andreww(a)netscape.com> To: zope(a)zope.org <zope(a)zope.org> Date: Tuesday, March 16, 1999 11:34 AM Subject: [Zope] Help - need a brainless guide to getting zope running >Ok, I consider myself pretty technical, but not a UNIX master, and I've >used NT enough to know about services, etc. But I cannot for the life >of me figure out how to get zope running as a service without manually >starting it from start.bat. > > >Could someone please post somewhere a "zope for dummies" description of >getting zope running as a service on NT. > >Here's what I do: > >I downloaded zope 1.10.2 >I unzipped and ran the installer. >It works fine to the point where it wants me to choose between running >zope alone or as a service. >I've tried it "both ways" and although I can get zope running fine by >manually starting it from start.bat, and >I make the zope service start automatically, it will not work as a >service! > >I dont have any other web server on this machine and dont really care >which server I use. I had assumed that ZopeHTTPServer would run as the >service, but it doesnt work... > >Is there just a minimal way to get zope going on it's own? > >I know the ip address etc. of my system, but that doesnt seem to be the >issue. > >I wouldnt even mind if in the install you had an option for "install >default web server" so that zope can piggy back on it. > >Does it have something to do with setting permissions to the var >directory? > >All I'm basically looking for is sort of a recipe style instruction on >how to get it up and running. (With no handwaving like "now configure >your system to run the zope.exe". Assume I'm a total idiot... > >Which I'm not, but I'm still having problems. > > > >-- > >------------------------------------------------------------------------- > >- Andrew Wooldridge - Opinions expressed are my own - >- andreww(a)netscape.com - http://people.netscape.com/andreww/ >- ICQ: 6345881 - Find It at http://dmoz.org - >------------------------------------------------------------------------- > > > > >_______________________________________________ >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

Help - need a brainless guide to getting zope running
by andreww＠netscape.com 16 Mar '99

16 Mar '99

Ok, I consider myself pretty technical, but not a UNIX master, and I've used NT enough to know about services, etc. But I cannot for the life of me figure out how to get zope running as a service without manually starting it from start.bat. Could someone please post somewhere a "zope for dummies" description of getting zope running as a service on NT. Here's what I do: I downloaded zope 1.10.2 I unzipped and ran the installer. It works fine to the point where it wants me to choose between running zope alone or as a service. I've tried it "both ways" and although I can get zope running fine by manually starting it from start.bat, and I make the zope service start automatically, it will not work as a service! I dont have any other web server on this machine and dont really care which server I use. I had assumed that ZopeHTTPServer would run as the service, but it doesnt work... Is there just a minimal way to get zope going on it's own? I know the ip address etc. of my system, but that doesnt seem to be the issue. I wouldnt even mind if in the install you had an option for "install default web server" so that zope can piggy back on it. Does it have something to do with setting permissions to the var directory? All I'm basically looking for is sort of a recipe style instruction on how to get it up and running. (With no handwaving like "now configure your system to run the zope.exe". Assume I'm a total idiot... Which I'm not, but I'm still having problems. -- ------------------------------------------------------------------------- - Andrew Wooldridge - Opinions expressed are my own - - andreww(a)netscape.com - http://people.netscape.com/andreww/ - ICQ: 6345881 - Find It at http://dmoz.org - -------------------------------------------------------------------------

3 2

ZPublisher: How to set the mime header?
by Oliver Thuns 16 Mar '99

16 Mar '99

Hi! I'm not using zope, but I'm using ZPublisher and ZServer. I'm coding a very simple counter module (with PIL). How could I set the mime header to image/gif and return an image?

4 3

Zope modifies HTML order of tags?
by Milos Prudek 16 Mar '99

16 Mar '99

It seems to me that Zope is rendering my HTML tag attributs in different order than in the source. For instance I put <table width="100%" cellspacing="2" cellpadding="2"> into property named tabstart. Looking into source produced by Zope, I found <table CELLSPACING=2 CELLPADDING=2 WIDTH="100%" > Why is Zope doing this? Maybe there's good reason, but I'd like to know, because too smart software is sometimes more burden than a help. Also some attributes are omitted in the rendering process. Property "width=106 height=106 border=0 align=right hspace=10 vspace=0" ended up without vspace statement. -- Milos Prudek

2 2

ZDP's FAQs version 0.2.2
by Martijn Faassen 16 Mar '99

16 Mar '99

Hi there, Sorry for the cross posting, but the ZDP's Zope FAQs are online with a new version at zdp.zope.org. I hope they are useful. Please continue to contribute! Regards, Martijn (one of the two :), of the Zope Documentation Project

1 0

RE: [Zope] MySQL LAST_INSERT_ID...
by Rob Page 16 Mar '99

16 Mar '99

Tom: [Reading from my support script..] This is where I say, "Hmm, I'm no expert on MySQL...." ;^) Anyone else have any ideas? This, um, worked on Sybase!? --Rob Tom Jenkins wrote: > > > To followup my last post, I'm getting an exception when > > > trying to use > > > MySQL's "select LAST_INSERT_ID()" function: > > > > > > Error, exceptions.KeyError: unhandled > > > > > > SQL used: > > > > > > select LAST_INSERT_ID() Rob Page replied: > >Try: > > > > select LAST_INSERT_ID() as fred > > > > then grab  > > > > If this works then I know what the problem is! :^) > > > > If you use the database's command line tool and run this > SQL statement I > > bet it returns a single value (i.e., it doesn't return a > table). The DA > > wants to munge and chew on rows in tables. If think that > if you use the > > select LAST_INSERT_ID() as fred you'll get a one-row, > one-column table > > -- this is what Zope wants. Then Tom wrote back: > Hi Rob, > Made the change and tested but still got the exception. > I ran it at the command line (for mysql) and it returns a > "table" with one > row and field

1 0