- Zope - Zope lists

ZSQL arguments
by Stephen Harrison 30 Mar '00

30 Mar '00

Hi, ZSQL methods can have two types of string argument, string and required, where required is a non-empty string and a string is (one assumes) a potentially empty string. Although does not say in the ZSQL users guide, it would be nice if strings were also not required to exist as arguments, which to my mind is the logical progression of allowing an empty string. The reason I want to do this is that I am writing sql methods which build queries based on the existence of certain arguments. Obviously I can code the logic to test for empty strings, but it would be neater and simpler to be able to simply have <dtml-if myarg> ... The other reason this would be a neater solution is that it would avoid the need to set up lots of empty arguments in the dtml which calls the sql method. Comments? Cheers, Stephen -- Stephen Harrison - stephen(a)nipltd.com New Information Paradigms - www.nipltd.com

1 0

dtml-return'ing the result of a SQL select (does not work)
by Dr. Peer Griebel 30 Mar '00

30 Mar '00

Hi, I just tried to implement something as described in the How-To How To: Use GenericUserFolder with an SQL database It does not work. The problem boils down to the fact that I can't dtml-return the result of a SQL query. I wrote the Z SQL Method 'qryTest': select * from mytable This method can be executed without problems. It displays all rows in the table. And I wrote a DTML Method 'returnData': <dtml-return qryTest> When calling the method I get Resource not found Traceback (innermost last): File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\Programme\uZope\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File D:\Programme\uZope\lib\python\ZPublisher\Publish.py, line 167, in publish File D:\Programme\uZope\lib\python\ZPublisher\HTTPResponse.py, line 299, in setBody File D:\Programme\uZope\lib\python\ZPublisher\HTTPResponse.py, line 511, in notFoundError NotFound: (see above) I'm using Zope 2.1.4, WinNT. What's going on here? Can anybody help?! Thank you! -- connection reset by Peer _______________________________________________________________________ Dr. Peer Griebel Tel. +49 7581 4831 23 Geschäftsführer Fax. +49 7581 4831 11 Knoll Informationssysteme GmbH http://www.knoll-is.de Dreiköniggasse 17 mailto:peer@knoll-is.de 88348 Saulgau privat: mailto:peer.griebel@gmx.de

1 0

Zope Site in Japan Zope.ne.jp
by Cyrus Shaoul 30 Mar '00

30 Mar '00

http://www.zope.ne.jp/ Zope Japan is a community of Japanese speaking Zope users and developers. It is operated and sponsored by Digital Garage, a Japanese web integrator that has been using Zope for over a year. It has translations of some Zope documentation, discussion boards, mailing lists, a download area for some Japanese-specific products, and many other features. Please come and join the community, but make sure you can read and write Japanese first! :-) Cyrus Shaoul cyrus(a)garage.co.jp

1 0

(no subject)
by Bruno FAURE 30 Mar '00

30 Mar '00

Hello, I've just discovered Zope, and would like to get more information about it as it seems quite interesting . But I'm not sure I could use it for the web project I'm working on. First, I'd need to stock XML files in an object database like the one provided with Zope. What kind of requesting language may I use ? XQL ? Xpath ? XML-QC ? OQL ? XOQL ? Second question, is there a java API integrated in Zope ? If not, is it possible to interface Zope with others java products as Resine, servlet engines, EJB server...? Thanks in advance Bruno Faure

1 0

Zope and memory usage
by Tony McDonald 30 Mar '00

30 Mar '00

Hi, I just ./stop and ./start'ed two Zope servers that were taking up rather a lot of memory; PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 841 nnle 12 33 0 395M 318M sleep 177:24 0.00% python 834 nnle 9 23 0 531M 14M sleep 101:20 0.00% python Is there any way of telling what objects are taking up this memory - could it be a memory leak in Zope at all? I'm using src-2.1.3 on Solaris because I still use the /REQUEST hint to see what my variables are. cheers, Tone. ------ 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

1 0

variable SQL insert method
by Allen Wallis 30 Mar '00

30 Mar '00

Hi, I have a database with 3 tables. I would like to create a ZSQL method for inserting data into the tables. I started by creating a separate method for each table, but that seems a bit of a waste. Ideally I would like to have one method, "addEntry". The template would look something like: <dtml-if "tname=='supplier'"> INSERT INTO <dtml-var tname> VALUES (NULL, <dtml-sqlvar sup_name type=string> etc...); <dtml-elif "tname='manufacturer'"> INSERT INTO <dtml-var tname> VALUES (NULL, <dtml-sqlvar man_name type=string> etc...); </dtml-if> The problem is that I have to specify the arguments in the argument list, and the arguments are different for each if clause in the above code. Is there a way around this? thanks Allen

2 1

problem with dtml-if
by Anders Holmbech Nielsen 30 Mar '00

30 Mar '00

hi, I have this code in a dtml method called "test": <HTML><body bgcolor=#ffffff> <form action="test" method="get"> <SELECT NAME="day"> <dtml-in "(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26 ,27,28,29,30,31)"> <OPTION VALUE="<dtml-var sequence-item>"<dtml-if "_['sequence-item'] == day"> SELECTED</dtml-if>> <dtml-var sequence-item> </OPTION> </dtml-in> </SELECT> <input type="SUBMIT" name="SUBMIT" value="go"> </FORM> </BODY></HTML> It should "remember" the day selected and choose that as the default when making the select box. But for some reason the sentence: <dtml-if "_['sequence-item'] == day"> SELECTED</dtml-if> Doesn't work. I have also tried ... == _[day] ... == 'day' ...and a lot of other stuff but with no positive result. I start the page with zope:8080/test?day=1 Regards ------------------------------------------------- Anders Holmbech Nielsen | Tlf: (+45) 70 22 56 00 Software Engineer | Fax: (+45) 70 22 57 00 Integrator Uniware A/S | http:/www.integrator.dk

2 1

<dtml-var x missing> doesn't work?
by Chris Withers 30 Mar '00

30 Mar '00

Hi, I'm doing a back link to go on a page (yes, I know browsers have back buttons, but some people don't like to use them ;-) which is easy enough: <A href="<dtml-var "REQUEST.environ['HTTP_REFERER']">">Back</A> except that if there is no referer, you get a key error. So I thought I'd try the following: <A href="<dtml-var "REQUEST.environ['HTTP_REFERER']" missing='/'>">Back</A> But I still get a key error. I thought the 'missing' attribute was supposed to catch that? Chris

3 4

ISP that supports Zope
by Anders Eriksson 30 Mar '00

30 Mar '00

Hello! My current ISP has no interest in supporting Zope and will not install some kind of 'Long Running Process', so I can't install it myself... Can someone recommend an ISP that supports Zope? I found Armored Internet, but it seems like they only support Zope for Business Services (and they also charge $37.50/month for it). So if someone knows an another ISP, preferable cheaper, PLEASE let me know! // Anders -- Livet är bara en period som man ska överleva

1 0

RE: [Zope] Logout with standard basic authentification
by Marcus Collins 30 Mar '00

30 Mar '00

Thanks for pointing that out. As I understand it, this is a limitation of the HTTP Basic Auth. spec. RFC 2617 deals with this, and says that a client may preemptively send the Auth. header with requests without receipt of another challenge (section 2). The browser sends this information for every request in the zope realm (if it didn't, you'd get the login box on every page). The server also sends an authentication required header for every page that is protected, so this behaviour in fact is quite logical. The only way around it is to use a different authentication mechanism, like Generic User Folder, et al. Oh, yeah, and I meant 401 Unauthorised... what a week... -- Marcus > -----Original Message----- > From: Terry Kerr [mailto:terry@adroitnet.com.au] > Sent: 30 March 2000 13:06 > To: Marcus Collins; zope(a)zope.org > Subject: Re: [Zope] Logout with standard basic authentification > > > The problem with this is that the browser will not clear its > cache of this > valid username/password unless the user clicks 'OK' on the > login dialog box > that pops up. If the user clicks 'Cancel' then the browser > assumes that > the user doesn't want to change the username/password, and keeps the > existing one in cache, hence, a reload of the page will be > successfull. > > Does anyone know of any tricks to get around this? > > terry > > Marcus Collins wrote: > > > Hi, > > > > With basic authentication, the user's browser caches the > username and > > password, and sends them along with each request. All you can do to > > invalidate the cached values is raise an "Unauthorized" exception. > > > > <dtml-raise type="Unauthorized"> > > You have been logged out. Please log in again. > > </dtml-raise> > > > > This sends an HTTP 500 Unauthorized back to your browser, > which should > > display the basic auth. login box again. > > > > See > http://www.zope.org/Documentation/Guides/DTML-HTML/DTML.12.html for > > details. > > > > hth, > > > > -- Marcus > > > > > -----Original Message----- > > > From: ibriones [mailto:ibriones@amutis.com] > > > Sent: 30 March 2000 10:36 > > > To: zope(a)zope.org > > > Subject: [Zope] Logout with standard basic authentification > > > > > > > > > I have tried to logout with standard basic authentification, > > > but I have > > > not seen nothing in Mailing List. > > > Only I have seen log out with cookie-based > authentication, but i have > > > to use standard authentification. I don't know how i can do it. > > > What can I do to logout with standard basic authentification? > > > > > > Thanks > > > > > > -- > > > Ismael Briones Vilar Administrador de Sistemas > > > ibriones(a)amutis.com Amutis Telecomunicaciones S.A. > > > Tlf: +34 96.353.67.67 Gran Vía Marqués del Turia, 27, 1 > > > Fax: +34 96.353.53.58 46005 Valencia (Spain) > > > > > > > > > > > > > > > _______________________________________________ > > > 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 ) > > > > > > > _______________________________________________ > > 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