- Zope - Zope lists

bug with SQL methods?
by Jordan B. Baker 09 Mar '99

09 Mar '99

Hi, I'm re-posting to this list because it probably is more suited here... thanks in advance, ------- Jordan B. Baker -- jbb(a)spyderlab.com weaving the web @ http://www.spyderlab.com ---------- Forwarded message ---------- Date: Fri, 5 Mar 1999 12:11:02 -0500 (EST) From: Jordan B. Baker <jbb(a)spyderlab.com> To: zope-dev(a)zope.org Subject: [Zope-dev] SQL methods q: Hi guys: I'm trying to write a SQL method though, and its giving me an error when I try to test it.. Error, exceptions.TypeError: keyword parameter redefined SQL used: Could not render the query template! The query I was using: SELECT searches.engineID as engine, queries.param as query, MAX(searches.timestamp) AS time, searches.position AS position, MIN(lastsearch.timestamp) AS lastupdate, lastsearch.position AS lastsearch, searches.URL as URL, 'NA' as change, engines.graphic as engine_gfx FROM searches LEFT JOIN searches as lastsearch USING (queryID,engineID), engines, queries WHERE lastsearch.timestamp BETWEEN  AND  AND searches.timestamp BETWEEN  AND  AND queries.clientID =  AND queries.queryID = searches.queryID AND engines.engineID = searches.engineID AND searches.timestamp != lastsearch.timestamp GROUP BY searches.engineID, searches.queryID ORDER BY searches.engineID ASC, searches.queryID ASC, searches.timestamp ASC, lastsearch.timestamp DESC ; Any ideas what I could be doing wrong? BTW, Zope is great! I've been kinda messing around with it for a while, also checking out PHP3 and other UNIX-based scripting languages and I've very impressed. As soon as I figure out what is causing this I plan to write something 'cool' with Zope :) TIA, -jordan. _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://www.zope.org/mailman/listinfo/zope-dev

5 10

tree doesn't work 4me linux amd win32
by Andy Heath 09 Mar '99

09 Mar '99

I'm a zope newbie. I just installed on a windows 95 box and on a linux 2.0.something but I can't get anything with tree working (other stuff seems ok). Hadars' second sample app doesn't work for me (the tree part produces no output). Even the minimal   doesn't produce output (tried this with the second Habar example after creating the "sub-folders"). I get the same behaviour on windows as linux. I must be doing something wrong. Clues please ? Andy btw: Zope looks really good to me (when I can get over these glitches). --------------------------- Andy Heath, Senior Lecturer a.k.heath(a)shu.ac.uk o Sheffield Hallam University. Phone: +44 114 2534904 /\ Sheffield, England Fax: +44 114 2533161 () ()

1 0

RE: [Zope] sqltest vx. var
by Rob Page 09 Mar '99

09 Mar '99

> I'll correct myself here. I was thinking of the >  tag. I > don't know what  does that  or >  won't do... I meant to bring this up in my earlier post -- this tag too, is used to simplify what could be a terribly complicated SQL Method given an indeterminate number and list of search criteria. With this tag you can permit an arbitrary arguments to be supplied connected with your predetermined ANDs and ORs This one tag has, in the past, reduced may SQL Methods into one -- natural maintenance savings. --Rob

1 0

Re: [Zope] sqltest vx. var
by Philip Aylesworth 09 Mar '99

09 Mar '99

>Something I'm just curious about... > >where  > >VS. > >where column_name =  > >Is the only advantage of using the first (sqltest) the type checking? I >can't find any other obvious advantages. > I haven't played with it too much but I think that Zope handles undefined variables properly if you do the sqltest. ie. where  and  will work if name2 is not defined. It also handles the quoting and SQL syntax (such as doubling single quotes). Phil A ------------------------------------------ Philip Aylesworth zopelist(a)regalint.com Regal International

1 1

RE: [Zope] sqltest vx. var
by Rob Page 09 Mar '99

09 Mar '99

> >Something I'm just curious about... > > > >where  > > > >VS. > > > >where column_name =  > > > >Is the only advantage of using the first (sqltest) the type > checking? I > >can't find any other obvious advantages. > > > > I haven't played with it too much but I think that Zope > handles undefined > variables properly if you do the sqltest. > > ie. > > where  > and  > > will work if name2 is not defined. > > It also handles the quoting and SQL syntax (such as doubling > single quotes). Absolutely... we ran into some situations where the SQL was so dynamic potential security problems arose. sqltest and sqlvar are designed to reduce that exposure. Additionally, we've found a very common rhythm where a search UI might expose all of a large percentage of the available data elements in the RDBMS. Using sqltest lets the user not specify one or more parameters without a lot of messy  stuff in the SQL Method. --Rob

1 0

RE: [Zope] ZServer as a windows NT service?
by Paul Everitt 09 Mar '99

09 Mar '99

Dick wrote: > startup. However, I am betting that this runs the > ZopeHTTPServer, not the Not quite. ZopeHTTPServer is a console app just like ZServer. The service is a PCGI-like thing that runs Zope as a service, listening for named pipe connections from something that is run as a CGI by the web server. > ZServer which I got as a separate download. I have everything > working just > lovely with the ZServer now, but it needs to be run as an NT > service (and > respond to start and stop signals, etc) at which point I > freely admit my > own inadequacies in this area. ZServer is still at alpha 2 so it's premature to focus on things like how it is packaged. I *think* we have all the issues figured out and the next release, perhaps this month, will be a beta1. Until we get into beta, we'll have to hope that someone in the community packages it up as a service. > Now my question. How can I do what I need to do. Is it simply > a case of > redirecting a python 'shell' file used by the service to the > start.py in > the ZServer module, or is there more to it? If it is this > simple, which > python 'shell' file do I use? If it is not this simple, can > someone send me > basic instructions on how to do it (why is NT like this - give me an > rc.local file any day - I know where I stand with that stuff). One issue off the top of my head is integration with the NT Event Log. --Paul

1 0

Re: Why doesn't this loop over files?
by Butch Landingin 09 Mar '99

09 Mar '99

In a previous posting, Tony McDonald <tony.mcdonald(a)ncl.ac.uk> wrote: >Hi, >I've d/led the ZopeDemos folder, installed it and started learning >more about Zope, but there's something happening that I'm not sure >about. > >The 'looping' example doesn't seem to iterate correctly over new >additions to the folder. The DTML is here: <... additional text deleted ...> There's a bug in the code, something I noticed when I was playing with the examples too. this is the fixed version: 001  002  003  004 <H3>Objects of type </H3> 005 <TABLE BORDER=1> 006 <TH>Id</TH><TH>Title</TH> 007  008 <TR><TD></TD> 009 <TD></TD></TR> 010  011 </TABLE> 012  013  014  About the bug and the fix: the bug was due to the statement  looping over the current folder, not the subFolder which it should be. By moving the "with" statement to enclose it (see line 002), the statement <!--#if "objectValues(... now loops over the objects inside the folder named "subFolder". I don't know who is maintaining the ZopeDemos product (or if it's being maintained at all), but I hope he/she takes note of this and posts an update. Hope this helps. Butch Landingin butchland(a)yahoo.com PS. I'm playing around with the Confera product (making it more slashdot-like) but I know it's not "officially supported" by Zope/DC -- so who's maintaining it? I have some detailed questions about the code (but I don't know if it's off-topic for Zope/Zope-dev). _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

4 4

RE: [Zope] ZServer as a windows NT service?
by Michel Pelletier 09 Mar '99

09 Mar '99

> -----Original Message----- > From: Dick Wall [mailto:dick.wall@mediamail.telinet.com] > Sent: Tuesday, March 09, 1999 8:47 AM > To: zope(a)zope.org > Subject: [Zope] ZServer as a windows NT service? > > > Hi all, > > <snip> > basic instructions on how to do it (why is NT like this - give me an > rc.local file any day - I know where I stand with that stuff). > Ahmen brother! Can I get a witness! -Michel > Thanks in advance. > > Dick > > > _______________________________________________ > 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

RE: [Zope] Re: Why doesn't this loop over files?
by Michel Pelletier 09 Mar '99

09 Mar '99

> -----Original Message----- > From: Butch Landingin [mailto:butchland@yahoo.com] > Sent: Monday, March 08, 1999 9:24 PM > To: tony.mcdonald(a)ncl.ac.uk > Cc: Zope(a)zope.org > Subject: [Zope] Re: Why doesn't this loop over files? > > > In a previous posting, Tony McDonald <tony.mcdonald(a)ncl.ac.uk> wrote: > > >Hi, > >I've d/led the ZopeDemos folder, installed it and started learning > >more about Zope, but there's something happening that I'm not sure > >about. > > > >The 'looping' example doesn't seem to iterate correctly over new > >additions to the folder. The DTML is here: > <... additional text deleted ...> > > There's a bug in the code, something I noticed when I was playing > with the examples too. this is the fixed version: > > 001  > 002  > 003  > 004 <H3>Objects of type </H3> > 005 <TABLE BORDER=1> > 006 <TH>Id</TH><TH>Title</TH> > 007  > 008 <TR><TD></TD> > 009 <TD></TD></TR> > 010  > 011 </TABLE> > 012  > 013  > 014  > > About the bug and the fix: > the bug was due to the statement  > looping over the current folder, not the subFolder which it should be. > By moving the "with" statement to enclose it (see line 002), the > statement <!--#if "objectValues(... now loops over the objects inside > the folder named "subFolder". > > I don't know who is maintaining the ZopeDemos product (or if it's > being maintained at all), > but I hope he/she takes note of this and posts an update. > Can you submit this problem you noted to the Collector as a documentation request? http://www.zope.org/Collector > Hope this helps. > > Butch Landingin > butchland(a)yahoo.com > > PS. I'm playing around with the Confera product (making it more > slashdot-like) but I know it's > not "officially supported" by Zope/DC -- so who's maintaining it? I > have some detailed questions about the code (but I don't know if it's > off-topic for Zope/Zope-dev). > Zope-dev is the place to ask specific questions about Zope's API and Zope Product Authoring. Go ahead and ask your questions, the unsuported just means we can't make any guarantees or commit company resources to it, but if your question happens to use Confera as it's basis all the better. Someone out there might have the answer. -Michel > > > > > > > > _________________________________________________________ > DO YOU YAHOO!? > Get your free @yahoo.com address at http://mail.yahoo.com > > > _______________________________________________ > 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

ZServer as a windows NT service?
by Dick Wall 09 Mar '99

09 Mar '99

Hi all, I have been using python for years, and zope for a few months now (lovely), ZServer for weeks, but Windows NT? Not long enough to understand the differences between services and ordinary process (give me a break, I am heavily from a Un*x background) :-). I know when I installed the binary version of Zope on the windows machine here it gave me a service in the services list which I can activate on startup. However, I am betting that this runs the ZopeHTTPServer, not the ZServer which I got as a separate download. I have everything working just lovely with the ZServer now, but it needs to be run as an NT service (and respond to start and stop signals, etc) at which point I freely admit my own inadequacies in this area. Now my question. How can I do what I need to do. Is it simply a case of redirecting a python 'shell' file used by the service to the start.py in the ZServer module, or is there more to it? If it is this simple, which python 'shell' file do I use? If it is not this simple, can someone send me basic instructions on how to do it (why is NT like this - give me an rc.local file any day - I know where I stand with that stuff). Thanks in advance. Dick

1 0