- Zope - Zope lists

Re: [Zope] tree-tag & SQL - works not properly with zope 2.1.6
by Andrew Williams 01 May '00

01 May '00

Try this: SQL Method: ----------- Name: itemquery Arguments: parentID Query: SELECT item.itemid FROM item WHERE <dtml-sqltest parentID type=int>; ----------- DTML Method: ------------ ...stuff <dtml-let ItemID="-1"> <dtml-tree id=ItemID branches_expr="itemquery (parentID=ItemID)"> <a><dtml-var ItemID>:  <dtml-var name></a> <br> </dtml-tree> </dtml-let> ...more stuff ------------ It looks like your SQL-Query is where the problem is: where parentID=<dtml-var parentID> when called by the dtml-method is basically going to be where parentid=parentid which is a circular reference. If you change the sql statement to the one above, then sql- method will evaluate out to: where parentid=item which is what you want. Hope this helps. Andrew -----Original Message----- From: Philipp Auersperg zope(a)philosoft.at Sent: Sat, 29 Apr 2000 04:43:42 +0200 To: zope(a)zope.org Subject: [Zope] tree-tag & SQL - works not properly with zope 2.1.6 I use a recursive table to implement a hierarchical structure in SQL and the Zope tree tag to display it. This works perfect with Zope 2.0.1 recently I upgraded to 2.1.6. Since then it does not work correct. What did I do wrong and what can I do to correct the problem? thanks in advance phil Here the exact description of what I did: 1. SQL statement: ---------------------- create table Item(ItemId int,parentID int,name varchar(30)) 2. In Zope I defined a SQL Method called 'Item' with an argument called 'parentID': ------------------------------------------------------------ ---- select * from Item where parentID=<dtml-var parentID> 3. I defined a DTML document to display the tree: ------------------------------------------------------------ ---------  <dtml-let ItemID="-1"> <dtml-tree id=ItemID branches_expr="Item(parentID=ItemID)"> <dtml-var name> </a> <br> </dtml-tree> </dtml-let>  ---------------------------------- __________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

2 1

ZSQL security restriction with Zope 2-1-6 ?
by Francois-Regis CHALAOUX 01 May '00

01 May '00

Date: 04/27/2000 05:09 pm (Thursday) From: Francois-Regis CHALAOUX To: INET:zope@zope.org Subject: ZSQL security restriction with Zope 2-1-6 ? Hi All, Since I upgrade from Zope-2.1.2 to Zope-2.1.6 I HAVE A BIG PROBLEM !!! I create a little application to manage seminars. All the methods to consult these seminars work but all the method to upgrade, create, delete return now ERRORS. My DB is Gadfly. Should I come back to 2.1.2 ? Should I change something in my code? Should I modify Zope-2.1.6? Help, please. FR =========== Environment =========== Linux Suse-6.2 Python 5.2 Zope-2.1.6 upgrade from Zope-2.1.2 with patch Zope-2.1.x-to-2.1.6-linux2-x86.tgz Gadfly =========== Bellow you can find the code of an example and the associated ERROR : ========================== DTML Document saisies.html ========================== <FORM ACTION="insert_seminar_do" METHOD="POST"> Blablabla .... </FORM> =============================== DTML Document insert_seminar_do =============================== Blablabla ...  Blablabla ... ========================= SQL Method insert_seminar ========================= Arguments : titre type jour numero mois annee heure minute nomconf prenomconf titreconf adresseconf lieu nomhote prenomhote url insert into seminar (id, titre, type, jour, numero,mois,annee,heure,minute,floatdate, nomconf, prenomconf, titreconf, adresseconf, lieu, nomhote, prenomhote, url) select max(id)+1, , , ,,, ,, , , ,, ,, , ,,  from seminar ============================= tofltdate is an external method. ============================= import string import sys from DateTime import * def tofltdate(numero,mois,annee): datum = string.join((str(annee) + "/" + str(mois) + "/" + str(numero)) + " 0:00pm US/Eastern" ,'') f = DateTime(datum) return float(f) ######################## Error type: NameError Error value: REQUEST --> </TD></TR></TABLE> </TD> </TR> <TR> <TD BGCOLOR="#6699CC" ALIGN=RIGHT VALIGN=BOTTOM COLSPAN="2" WIDTH="150"><IMG SRC="Images/bottombar.gif" ALT="Curve graphic" WIDTH="150" HEIGHT="26" BORDER="0"></TD> <TD ALIGN=CENTER> <HR NOSHADE SIZE="0"> <p class="footlink" align="center"> <A HREF="http://sbi2.strasbourg.synthelabo.fr:8080/zseminar/insert_seminar_do?pp=1">Printable Page</A>     <A HREF="mailto:fchalaou@stasbourg.synthelabo.fr">Feedback</a>     <A HREF="http://sbi2.strasbourg.synthelabo.fr:8080/zseminar/insert_seminar_do/view_s…">DTML Source</a> </p></TD> </TR> </TABLE> </BODY> </HTML> <!-- Traceback (innermost last): File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 179, in publish File /opt/zope/Zope-2.1.2/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 165, in publish File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: insert_seminar_do) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: insert_seminar(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File /opt/zope/Zope-2.1.2/lib/python/Shared/DC/ZRDB/DA.py, line 424, in __call__ (Object: insert_seminar) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: <string>) File /opt/zope/Zope-2.1.2/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: tofltdate(REQUEST['numero'],REQUEST['mois'],REQUEST['annee'])) (Info: REQUEST) File <string>, line 0, in ? NameError: (see above) -- >

6 7

Re: [Zope] Upload/Download Product
by Luis Cortes 01 May '00

01 May '00

Well, I would like to keep it web-based. Not everybody has an easy time switching between web and ftp. Plus I am experimenting with IMEM.NET which I'm not sure if they are supporting ftp? or how to access it if they are. On Sun, 30 Apr 2000, you wrote: > What about FTP'ing the files in and out? You could get an ftp client with a > progress meter!. > > The zope ftp server defaults to port 8021 in a standard installation. > > terry > > Luis Cortes wrote: > > > Hello Zope Developers, > > > > Does anybody know of a simple upload/download product I could use. All I want > > to do is upload/download files with some type of progress meter to a website. > > > > Thanks ahead of time, > > Luis. > > > > _______________________________________________ > > 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 ) > > -- > Terry Kerr (terry(a)adroit.net) > Adroit Internet Solutions Pty Ltd (www.adroit.net) > (03) 9888 8522 > 0414 938 124

1 0

Re: [Zope] Users sources for LoginManager
by Tres Seaver 01 May '00

01 May '00

<snip> > Also I'm wondered where can i get Zope 2.2 which is often mentioned in > documentation. "In documentation"? Version 2.2 has not yet been released -- any documentation (other than mailing list archives, where future relases are occasionally discussed) which mentions it (now) is broken. Can you please point to these places so we can fix them? -- ========================================================= Tres Seaver tseaver(a)digicool.com tseaver(a)palladion.com

2 1

Upload/Download Product
by Luis Cortes 01 May '00

01 May '00

Hello Zope Developers, Does anybody know of a simple upload/download product I could use. All I want to do is upload/download files with some type of progress meter to a website. Thanks ahead of time, Luis.

1 0

Re: [Zope] Speeding up Zope - Squid works GREAT
by kdie 30 Apr '00

30 Apr '00

-----Original Message----- From: Itamar Shtull-Trauring <itamars(a)ibm.net> To: kdie(a)nstp.com.my <kdie(a)nstp.com.my> Date: Sunday, April 30, 2000 5:28 PM Subject: [Zope] Speeding up Zope - Squid works GREAT >I set up Squid as an HTTP accel in front of Zope. I ran ab 100 times with a >concurreny of 10 on the same machine Zope and Squid were running on. Squid >is 10 times as fast as plain Zope. oooh.. stop teasing us. mind giving us a HOW-TO? thanks

1 0

Re: [Zope] Adding days in Zope using ZopeTime
by Jason Spisak 30 Apr '00

30 Apr '00

Stephan: > > > > <dtml-if "_.round((_.DateTime.dayOfYear(ZopeTime() - > > > > _['sequence-item'])/6.88)+1) == > > > > _.round(((ZopeTime().dayOfYear())/6.88)+1)"> > > > Perhaps to account for +/- several hours of daylight saving? > > <sarcasm> You mean the above solution isn't elegant? </sarcasm> > I followed the discussion a little bit, and I think the solutions are > crazy. Me too. But the question asked for a DTML solution without modifying DateTime. >I usually install mxDateTime, since its features are far more > advanced and use it with some external methods. Works just fine. (I really > think, Zope should use mxDateTime. Maybe I should alter mxDateTime to have > the same method names as Zope's DateTime and then replace it. That would > increase the feature set by many multiples and would get rid of some of the > annoying bugs with the current DateTime.) > I whole heartedly agree! Bravo. I'll bet DC would take the combined module and graft it. Why wouldn't they? The DateTime module has enough annoying little things in it (or/and lacks in just enough features) to give them a pretty constant ear ache. All my best, Jason Spisak CIO HireTechs.com 6151 West Century Boulevard Suite 900 Los Angeles, CA 90045 P. 310.665.3444 F. 310.665.3544 Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

2 1

Users sources for LoginManager
by Sergey Trofimov 30 Apr '00

30 Apr '00

Hello Zopistas. Does anybody use LoginManager product in Zope v.2.1.6? I was looking around a bit but still can't understand how to use Generic User or Folder Persistent User Source? What difference is between Generic and Persistent sources? Also I'm wondered where can i get Zope 2.2 which is often mentioned in documentation. Thanks in advance. -- All my best, Sergey.

1 0

Speeding up Zope - Squid works GREAT
by Itamar Shtull-Trauring 30 Apr '00

30 Apr '00

I set up Squid as an HTTP accel in front of Zope. I ran ab 100 times with a concurreny of 10 on the same machine Zope and Squid were running on. Squid is 10 times as fast as plain Zope. Zope: Concurrency Level: 10 Time taken for tests: 4.891 seconds Complete requests: 100 Failed requests: 0 Total transferred: 2807500 bytes HTML transferred: 2778800 bytes Requests per second: 20.45 Transfer rate: 574.01 kb/s received Connnection Times (ms) min avg max Connect: 0 26 239 Processing: 128 440 1183 Total: 128 466 1422 Squid: Concurrency Level: 10 Time taken for tests: 0.503 seconds Complete requests: 100 Failed requests: 0 Total transferred: 2987772 bytes HTML transferred: 2952132 bytes Requests per second: 198.81 Transfer rate: 5939.90 kb/s received Connnection Times (ms) min avg max Connect: 0 3 27 Processing: 35 42 52 Total: 35 45 79 -- Itamar S.T. itamars(a)ibm.net

3 3

Aquisition problem with Cookies?
by cs＠comlounge.net 29 Apr '00

29 Apr '00

Hi! I recently played around with SQLSession backed by a mysql database. My setup was the following: mysite/ mysite/std_header_html DTML document mysite/std_footer_html DTML document mysite/index_html DTML document mysite/Session SQL Session mysite/folder/index_html DTML document The idea is to do all the session stuff in the sql_header_html, basically doing the <dtml-call Session>. Being in mysite/index_html everything works. The Session is created and when logging in via a form the actual userid is stored in the Session_Data. Now when jumping to mysite/folder/index_html it's not working anymore. I am again using a <dtml-var std_header_html> at the beginning which aquires the dtml document in the parent folder. The problem is now that a new session is created all the time although one should be still available when accessing mysite/folder/index_html (thus the cookie should still be available in the request). When moving the <dtml-call Session> into mysite/folder/index_html everything works. So why is this? To track it down a little more I checked which cookies are stored in REQUEST.cookies. I did this in std_header_html and mysite/folder/index_html: std_header_html: <dtml-in "REQUEST.cookies.keys()"> <dtml-var sequence-item> = <dtml-var "REQUEST.cookies[_['sequence-item']]"><br> </dtml-in> and the same in mysite/folder/index_html: <dtml-in "REQUEST.cookies.keys()"> <dtml-var sequence-item> = <dtml-var "REQUEST.cookies[_['sequence-item']]"><br> </dtml-in> <dtml-call Session> <dtml-var std_header_html> I would expect that both loops would produce the same output but it isn't. In the loop in mysite/folder/index_html the cookie is there and in the loop done by std_header_html it isn't. So this seems to be the reason why always a new session is created when only doing the session work in the std_header_html. Can someone explain this to me? ;-) (Actually putting the Session call into index_html is not the problem but for modularizing things I would like it more to be in a central place.) Hope someone knows more than I do :) -- christian

1 0