March 2000 - Zope - Zope lists

call stored procedure from sql method object
by Chien-pin Wang 08 Mar '00

08 Mar '00

I have installed ZOracleDA to bridge Zope and Oracle 8.0.5 on Linux. How do I call the stored procedures written in Oracle from "Add a SQL Method" interface, especially when there are OUT parameters returned from stored procedures? I have read the DCOracle mini how-to but there seems to be a missing step ahead. Assume the scenario: Oracle Procedure: myProc(para1 IN VARCHAR2, para2 OUT INTEGER, para3 OUT REFCURSOR%TYPE) What should I put in the "Arguments" box and "Query template" box? And how do I retrieve the returned arguments in the following dtml document/methods? Thanks a lot! Chien-pin

1 0

Get author name from zope
by Sin Hang Kin 08 Mar '00

08 Mar '00

Can I retrieve the author's name from Zope? Is it always available? I am writing a module to put into the header to generate dublin core rdf record. I would like to retrieve this information automatically. BTW, does anybody have "open source" legal notices and privacy policies (a few samples for web masters to choose) can freely distributable with zope? Rgs, Kent Sin

1 0

concatenating lists via dtml
by Ingo Assenmacher 08 Mar '00

08 Mar '00

Hello! How do you concatenate lists (or add a new listelement) to list-properties? Regards, Ingo.

3 2

Old style to newstyle dtml tag converter?
by Alexander Schonfeld 08 Mar '00

08 Mar '00

Just wondering if anyone had written a nice recursive tag converter script? We have some older zope sites and it might be nice to move to the new style <dtml- from <--# tags. I'm also waiting for someone to write the "dtml-method beautifier". :) Thanks in advance for any tips/pointers/source. Regards, Alex. 1010011010 0 Digital Garage 1 Alex Schonfeld 0 alex(a)garage.co.jp - pear 1 090-4429-2323

2 1

Re: [Zope] POLL: Preferred browser?
by John Goerzen 08 Mar '00

08 Mar '00

Well, as a note to the Zope folks, I would really prefer to use Lynx... but the zope management screens are not at all lynx-friendly (FRAMES!). Sigh. Curtis Maloney <curtis(a)umd.com.au> writes: > Greetings, > > > Look, I don't want to start any holy wars, just to get a head count, more or > less. But what are peoples preferred browsers for ZOPE development? > > Until now, I've been using Netscape, whilst desperately searching for some > replacement that didn't haemorhage memory. I think I've even managed to narrow > down which part of NS is losing the memory (it's the edit box, which is why it > seems to happen quicker when working with ZOPE). > > However, in my searches I've yet to find ANYTHING under Linux that comes close > to the functionality of NS. > > As I said... I don't want advocacy here, simply name and version, and perhaps > a quick rundown of the reason(s) you chose it over others. > > -- > Have a better one, > Curtis. > > <dtml-var standard_work_disclaimer> > > _______________________________________________ > 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 ) > -- John Goerzen Linux, Unix consulting & programming jgoerzen(a)complete.org | Developer, Debian GNU/Linux (Free powerful OS upgrade) www.debian.org | ----------------------------------------------------------------------------+ The 71,187,032nd prime number is 1,425,319,969.

4 3

Use of HTTP_ACCEPT_LANGUAGE in Zope
by Sin Hang Kin 08 Mar '00

08 Mar '00

I am making a new head zope index_html file, I think it is now about time to make use of the HTTP_ACCEPT_LANGUAGE which is sent by the browser to indicate the perferred language. The variable is a string like: lang1, lang2;q=p1,lang3;q=p2.... while lang1, lang2, lang3 is the perferenced languages. I have think of the following ways to make such brenches in zope: 1. by setting the lang variable in the REQUEST 2. by transfer to the brench of lang/ 3. brench calls of index_lang What will be the perferred way to make such a brench? I want to hear from all. In building the brench code : I have come up with the code: <dtml-in "_.string.split(HTTP_ACCEPT_LANGUAGE, ',')"> .....do thing according to sequence-item </dtml-in> but on the second argument, the sequence-item may contain ;q=0.5 which need to be trancated. How can I trancated that in dtml? Rgs, Kent Sin

1 0

AUTHENTICATED_USER.getUserName()
by John Williams 08 Mar '00

08 Mar '00

>Is there a HOW-TO or other documentation that shows how to set up a login >page so that you can use AUTHENTICATED_USER.getUserName()? Thanks in >advance for any help/pointers provided. I don't know if there is a how-to but the way I do this is very simple. I have a simple form with only a submit button with name login (it appears on a sidebar of the web site). When it is clicked it posts to the current URL. <dtml-if isRegistered> You are <dtml-in "AUTHENTICATED_USER.getRoles()"> <dtml-var sequence-item> </dtml-in> <b><dtml-var "AUTHENTICATED_USER.getUserName()"></b> <dtml-else> <FORM ACTION="<dtml-var baseURL>" METHOD="POST"> <INPUT NAME="logon" TYPE="SUBMIT" VALUE="Logon"> </form> </dtml-if> In the start of every page I call a method to check for 'login' in the REQUEST variable. If it exists I calls or references an empty method which anonymous users have no rights to but which authenticated users do have access to (with ID login in this example. <dtml-if "REQUEST.has_key('logon')"><dtml-var logon></dtml-if> <dtml-call "REQUEST.set('isRegistered',AUTHENTICATED_USER.has_role(['Staff','Student','Manager']))"> Zope will therefore invoke the authentication mechanism which means the browser will ask for a login a password as usual. From there on the user will have been authenticated and you can check their name and what role(s) they have in the current context. As you can see once with the code given here the user has logged in instead of a login button they will see a message giving their username and global role(s). Hope this helps. -- Dr. John A.R. Williams Photonics Research Group Telecommunications Technology Programme Director Aston University

1 0

SiteAccess and the medusa monitor
by Chui Tey 08 Mar '00

08 Mar '00

Has anyone else experienced difficulty connection to the server through the monitor when SiteAccess is installed? I didn't add any SiteAccess instance, just it was in the product folder. Platform Win98 Zope 2.1.3 I deleted the SiteAccess Product directory and I was able to get in again. Chui

1 0

[newbe] MySQLDA Installation error at MySQLdb build.
by Eric L. Walstad 08 Mar '00

08 Mar '00

Hi David and the rest of the group, Can you believe I am still battling this MySQLDA installation!? ARGH! I hope you can help me out here: According to the HOWTO by alanpog, I've 1. Downloaded MySQLDA 1.1.3 2. Expanded it into my top level Zope Directory (/usr/local/Zope) Note that I did not do any installation here, just expanded it into this directory. 3. Downloaded MySQLdb v0.1.2 4. Expanded MySQLdb into /usr/local/Zope/lib/python/Products 4a. Modified the Setup.in file so that the one uncommented line is: _mysql _mysqlmodule.c -L/usr/local/lib/mysql -I/usr/local/include/mysql -lmysqlclie nt As you mentioned, these point to where my MySQL libraries are. 4b. According to the README file, ran 'python build.py' This is where I am stuck. The build.py script crunches along then bombs with the following error: Traceback (innermost last): File "build.py", line 14, in ? import MySQLdb File "MySQLdb.py", line 19, in ? from _mysql inport * ImportError: libmysqlclient.so.6: cannot open shared object file: no such file or directory" I checked and this file is in my /usr/local/lib/mysql directory. It is a link to libmysqlclient.so.6.0.0. Both files are there; owner=root, group=root. I'm hoping this is a simple fix ;^) Any idea's would be greatly appreciated! Eric. // -----Original Message----- // From: CURTIS David [mailto:David.Curtis@state.or.us] // Sent: Monday, March 06, 2000 8:11 PM // To: IPM Return requested (Receipt notification requested) // Subject: Zope success finally. // Sensitivity: Personal // // // Hi, // // Dump the MySQL 3.23.32 version I could never get it to work. // The Db version 2.3 that I was using was a pre-release and it // was a bomb. // // Ok, I was able to get the thing working using 3.22.27 version // of MySQL and the oMySQLdb 0.1.2. Don't forget to get the Zope // part ZMySQLDA so you can use MySQL in Zope. // // You set the paths where the MySQL libraries are. Basically if // you installed via the RPM method they are in the \usr directory. // If you installed via the source method (BEST) they are where // you specificed when you installed them. Also installing via the // source method gives you all the libraries. Note that you need // python development package if you used the RPM method to // install zope. Best to use source for all installation-I learned // the hard way. // // How can you find out what the paths are? If you have installed // locate on your linux box type // # locate mysql // See where the path is and make the adjustment. // // I hope this helps. // Dave // // David, did you manage to get past the Install MySQLdb step? // // Thanks, // // Eric. // // // _______________________________________________ // 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

index_html for root
by Sin Hang Kin 08 Mar '00

08 Mar '00

The attached file is intended to replace the current architecture of header body footer of current zope default index_html. Together there will be some attributes which can be used to modify its behaviors : wap - when defined, set the content-type in RESPONSE accordingly according to Ducan's WAP howto. and sent out the <wml></wml> tag. xml - when defined, set the content-type to xml/plaintext and the xml header frame - when defined, prevent sent out the body tag Only one of the above can be set. I still got problem with acquisition: if one of these is set in a higher lever, then all lowerlevel see it. Are there any easy way to set them off? doctype - when defined, should contain the correct doctype string: currently the following doctype is available: html4.0 htmlstrict4.0 htmltransistional4.0 htmlstrict4.01 htmltransitional4.01 htmlframe4.0 htmlframe4.01 xml1.0 xhtml1.0 The following is defined inside the index_html: dtml-head - the content of the <head></head> section dtml-headers - the content of contructs before the main body: This should not left any tag open. dtml-footers - the closing contents of the main body. There should not assume any opening tags. index_htm - the main content. a frameset statement if frame is defined. If the main content contains a table, then the main table is defined here, the parts in the table can then be dtml-var. A index1 index2 .... or indexr1c1 index r1c2 .... naming convention is suggested. I strongly suggest convert the current zope sites to adapt to this style through much works shall be needed. Further work would be in the dtm-head: Recently I will suggest to adapt the W3C core styles : http://www.w3.org/StyleSheets/Core/Overview All suggestion and comments are welcome. The index_html is below: ---------------------------------------------------------------------------- ------------------ <dtml-if wap> <dtml-if "HTTP_USER_AGENT[:7]!='Mozilla'"> <?xml version="1.0"?> <!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">  <wml> <dtml-var index_htm missing> </wml> <dtml-call "RESPONSE.setHeader('Content-Type', 'text/vnd.wap.wml')"> <dtml-else> <?xml version="1.0"?> <!DOCTYPE HTML SYSTEM "html40-mobile.dtd"> <html> <head> <dtml-var dtml-head missing> </head> <body> <dtml-var dtml-headers missing> <dtml-var index_htm missing> <dtml-var dtml-footers missing> </body> <dtml-call "RESPONSE.setHeader('Content-Type', 'text/plain')"> </html> </dtml-if> <dtml-elif xml> <dtml-call "RESPONSE.setHeader('Content-Type', 'text/xml')"> <dtml-if doctype> <dtml-var doctype> <dtml-else> <?xml version="1.0" encoding="utf-8"?> </dtml-if> <dtml-var index_htm missing="<xmlstring>Document Not Found</xmlstring>"> <dtml-elif frame> <dtml-if doctype> <dtml-var doctype> <dtml-else> <!DOCTYPE HTML> </dtml-if> <dtml-var index_htm missing> <dtml-else> <dtml-if doctype> <dtml-var doctype> <dtml-else> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> </dtml-if> <html> <head> <dtml-var dtml-head missing> </head> <body> <dtml-var dtml-headers missing> <dtml-var index_htm missing> <dtml-var dtml-footers missing> </body> </html> </dtml-if>

1 0