[Zope-dev] EuroPython2002
Hi all,, Only four days left to take advantage of the early bird registration fee for the EuroPython 2002 26.6 - 28.6.2002 in Charleroi Belgium. The EuroPython congress contains dedicated Zope Tracks! We've several really interesting Zope talks, including about Zope3! And there is more for people interested in Zope3: There is a 180 min Zope3 Tutorial given by Jim Fulton himself. THE european Python and Zope event. Meet Guido v. Rossum, the inventor of Python, and Jim Fulton, the chief architect of Zope. REGISTER NOW at http://www.europython.org Best Regards, Tom. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Re: [Zope] zope t-shirts available!
It would be great if someone going to the ZopeConference in Berlin, working at DC or living close to DC, could take a few t-shirts with him/her. If this would be possible, I would order a Zope and Python t-shirt directly. I'd pay the person in Berlin. This is much easier then sending a check across the ocean. Tom. - Original Message - From: Jens Vagelpohl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, June 15, 2001 5:15 PM Subject: [Zope] zope t-shirts available! for those who haven't noticed the little link on zope.org... digital creations is now selling a very stylish zope t-shirt! details and a picture are at: http://www.zope.org/Resources/Store melissa light ([EMAIL PROTECTED]) is available to answer any questions and take shirt orders. jens ___ Zope maillist - [EMAIL PROTECTED] 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-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] python scripts
Hi, This weekend I did some work on python scripts and found some things which suprised me, can someone enlighten me on this why these 'strange' things are needed? : 1. When calling a method from a python script you've to do this : (assume x is the value to pass and name is a parameter of mymethod) context.mymethod(name=x) The following doesn't works : context.mymethod(x) (this gives an error) Why 2. Assume you've an sqlmethod which expects 2 parametes, but one is optional : eg select * from invoice dtml-sqlgroup where required dtml-sqlgroup dtml-sqltest customersid column=customers_id op=eq type=int dtml-and dtml-sqltest productsid column=products_id op=eq type=int optional /dtml-sqlgroup /dtml-sqlgroup So, you could run this sql with or without the productsid No, calling from python script doesn't works since it expects: context.mymethod(customerid=..., productsid=...) while context.mymethod(customerid=...) doesn't work.. Now, this implies that I've to write 2 sqlmethods (one with 2 parameters and one with 1), which is pretty stupid, since sqlmethods perfect allow to ignore a parameter when not passed... Can somebody tell me more on this? Why this is the case and perhaps a solution for (2) Thanks in advance, Tom Deprez ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] ZClass - Python Product
Hi, Is there a way to convert a running application with ZClass to Python Products without loosing data? Even better : Is there a tool which converts a ZClass in a rough Python Product Code? So that we've already the python source code and only have to make to code cleaner? Thanks in advance, Tom. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope-dev] Python products
Hi, I'm wondering, is there somewhere a simple example on how to create a python product which behaves like the following ZClasses : A simple zclass which contains some data (this is easy with the existing examples) A folder-like zclass which only allows to contain the simple zclass. (easy?) A folder-like zclass which allows to contain the 2 above classes (probably easy if I've an example of the 2de class) Thanks in advance, Tom. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope] Problem of performance
Hi, It's strange, I thought I was rid of it, but it seems to pop-up now and then. I'm talking of a slow performance of Zope2.2.x Here is the problem: When I'm working in Zope, the following happens sometimes : eg. I copy an object and then try to paste it. The pasting can take minutes, or the interface just keeps trying to load the page. Now, when I stop the loading of the page (when it seems to be hanging) and reload the page, I see the copied object. So, it looks like Zope has problems to display the page. I've Zope installed on Mandrake and the problem occures on Netscape (Linux) as IE5.0 windows. Somebody an idea what may be the cause of this? Did something changed in the code related to this? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Editors [OT]
Hi, What about http://freshmeat.net/projects/boa-constructor/?highlight=boa ? I heard about this yesterday from Godefroid. With some changes we perhaps could add a Zope interface? Tom. - Original Message - From: "Dario Lopez-Ksten" [EMAIL PROTECTED] To: "Chris Withers" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 11:56 AM Subject: Re: [Zope] Editors [OT] Textpad www.textpad.com EditPluswww.editplus.com I am using TextPad mostly now. Of course, given the choice, I'd much rather use BBEdit or Alpha on a Mac /dario - Original Message - From: "Chris Withers" [EMAIL PROTECTED] To: "Tres Seaver" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 11:08 AM Subject: [Zope] Editors [OT] Tres Seaver wrote: I'm liking it a lot -- the last reason to even consider using emacs is gone :) Hmmm... interesting, maybe it's time to find a new editor... My wishlist would be: - Runs nicely on NT4 - Syntax highlighting for Python, C, XML, HTML (and, although this is dreamworld stuff, DTML ;-) - FTP or WebDAV editing built in as standard (or alternative solution, like cadaver making it work ;-) - Regular Expression search replace - search replace of multiple files and my dream list would be: - can run multiple copies of the editor at once - class browser for python, with expand/collapse of code (like the editor for Python 2) Any ideas? cheers, Chris ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Object DB versus Relational DB
ZODB with Data.fs is optimized to fetch data. Inserts or updates have a lot of overhead. It's the price we pay for the excellent versioning features. Therefore, when the are many we have been avoinding ZODB even when the problem domain calls for an OODB Thanks for the link. However, the information in the database will not change much. Once the data is nin their, only sometimes data will be updated, inserted or deleted. So, the versioning system won't be a problem. ___ Zope maillist - [EMAIL PROTECTED] 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] Object DB versus Relational DB
Hi, Can somebody provide me informational links of documents which present the benefits and non-benefits of both DB? eg. When to use one and when not to use one? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Creating PDF's
Hi, I read in Itamar's 'A Developers Guide to learning Zope' about 'Reportlab'. It is a python library to create pdf files. Is there somebody among here who already used this library with zope? And is it possible to give a little example in how we can use it with zope? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Zope 2.3
To all who feels him/herself addressed : Congrats to the new look of zope! And to the new implemented products! All I can say is ... keep up the good work! Regards, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Unexplained Slowdown
Hi all, Thanks for this file! Yesterday I thought I'd lost it, altough I heard more rumours of 'slowdown' I couldn't find a solution for my problem since I gave that demo and zope was so slow... you should have seen my face at that moment (completely red!). I tried everything, reinstallation of zope and interbase drivers, etc... My last resort was going to an earlier version of zope, or trying to use pcgi, but this morning I found this patch in my mailbox. I tried it and.. nice! All problems were gone. So, now I can give the demo again and zope will be fast again :-)! Regards, Tom ps. Can you give more information on this? ie something more than the lines below. It seems an interesting case. - Original Message - From: "Brian Lloyd" [EMAIL PROTECTED] To: "Ian Thomas" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 17, 2001 10:10 PM Subject: RE: [Zope] Unexplained Slowdown This is due to an ill-fated attempt to make 'domain-based authentication' less expensive (but that backfired to some extent because it can make non domain-based auth more expensive, especially if reverse DNS lookups are slow for you). This is fixed for 2.3 b2 - in the meantime you should be able to copy the attached User.py to fix the problem for now. Brian Lloyd[EMAIL PROTECTED] Software Engineer 540.371.6909 Digital Creations http://www.digicool.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ian Thomas Sent: Wednesday, January 17, 2001 3:41 PM To: [EMAIL PROTECTED] Subject: [Zope] Unexplained Slowdown When I upgraded to Zope 2.2.5 access to my Zope over the web slowed down dramatically and I haven't been able to figure out why. I am interested in ideas I can try to track it down the problem or at least quantify/benchmark the slowness. Some background. 1) I am a computer teacher teaching Zope to my second year web development students who have already learned HTML and been introduced to JavaScript. 2) The server is a my test machine that my students and I use for learning. 3) The "production" server still running 2.2.4 continues to preform normally. 4) The machine is Celeron 500 mhz 64 meg ram running Windows 2000 Server 5) I run Medusa server that comes with Zope to server the web pages. 6) There is no gateway set up on this machine so that it is only visible from within the school. Notes. 1) It is much faster if I access via localhost on the server. What I have tried. 1) Installing 2.2.4 on another port. It ran just as slow. 2) Today I removed the 2.2.4 installation and installed 2.3beta, again it seems just as slow. What Next? The next thing I was thinking was to serve the webpages from IIS using PCGI. I am interested in other ideas. I. Thomas ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] Unexplained Slowdown
Forgive my enthousiastic comment in my previous message! Some more news: The overall response is better than before, but sometimes Zope (or ZServer) is very slow. This slowdown is at my Linux Server and at my Win Clients (NT 4 sp5) It takes 1-2 minutes before I even get the log-on screen (on my server!) to enter zope. I don't know where this is comming from, but it is strange. Overall, the response is better than before, but some strange slow-responses are still there. If I only knew how to find the cause of this. Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] exporting zope
Hi, I'm looking for the products who can make plain html-files from zope folders. Unfortunately, I can't find them anymore on the zope.org site. Probably I missed them, but are there people who know the names of these products/tools, for easier finding. Are there people who have experience with some of them. (good, bad). Yes, I know, this isn't the normal way to do it, but I'm stuck here. People force me to use a certain tool to create a html-page. But, the data can change a lot and I don't want to rewrite these pages over and over. So, I want to use zope objects and add object now and then. Then I produce some html-pages from my zope db... This way everybody is happy and hopefully one day I can convince them that they better use Zope than the other tool. Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Flat-style
Not really zope specific, but I hope nobody minds me asking. How do you implement flat-looking input boxes? Does somebody knows this? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] ZServer
Hi, Can anybody tell me what the following warning means, or where I can find documentation on this warning? ZServer warning : server accept() threw EWOULDBLOCK Thanks in advance Tom Deprez ___ Zope maillist - [EMAIL PROTECTED] 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] Memory problems
Hi, Since a few days I'm experiencing some response problems on my zope site. At some moments calling a page goes very fast a few seconds later, recalling this page takes very long! At the end, every page takes long time, if they ever appear If I use a simple memory checker program, then I see that memory leaks away (memory goes from 48Mfree to 41M in 15min!! and eventially it ends at a few thousands K) However, I've no idea if it is comming from Zope 2.2.5 or from my database adapter in zope, or from somewhere else Is there a good way to check memory leaks and to pinpoint them? If I ask to show me the processes on my Linux box, I see the following related ones : /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (root) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) gds_inet_server # Interbase Database Remote Server (root) gds_inet_server # Interbase Database Remote Server (root) Is it normal that zope opens so much processes? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] finding by which object uses which methods
I think you misunderstood me here I don't want to find the standard_html_footer itself I want to find the objects which USE standard_html_footer. as in dtml-var standard_html_footer eg. if index_html contains the line above. The find should return index_html and not standard_html_footer. I'm looking which objects depend on certain objects. Regards, Tom. - Original Message - From: "Andy McKay" [EMAIL PROTECTED] To: "Tom Deprez" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 8:18 PM Subject: Re: [Zope] finding by which object uses which methods Its called "Find", a tab in the top right hand corner. Type in standard_html_footer in the containing field. -- Andy McKay, Developer. ActiveState. - Original Message - From: "Tom Deprez" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 21, 2000 10:08 AM Subject: [Zope] finding by which object uses which methods Hi, Has somebody created a tool which can tell all the objects which uses a specified object? eg. ask zope to return a list of objects which use standard_html_footer. This tool would come handy to me... perhaps to others also. So if you've created it for yourself, perhaps you want to share it to us? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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] finding by which object uses which methods
Hi, Has somebody created a tool which can tell all the objects which uses a specified object? eg. ask zope to return a list of objects which use standard_html_footer. This tool would come handy to me... perhaps to others also. So if you've created it for yourself, perhaps you want to share it to us? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] data.fs
Hi, I'm experiencing a strange problem here. I followed the how-to of 4am : Make your life easier with INSTANCE_HOME. Now, when I start zope in debug mode, everything works fine. However! When I start zope in normal mode, I get an error : InstallError : No access file found at cd $ reldir; pwd - see INSTALL.txt Why do I get this error in normal mode? What check does normal mode more than debug mode? I checked the permissions on the access file and they seem ok to me : -rw-rw nobody root Anybody an idea what's wrong with this? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] data.fs
Arg, Forget previous message. Sometimes, you've to get away from the error to find it out. ยด ` are not the same that was the mistake I made in the start script Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Data.fs
Hi, My Zope is installed in /usr/local/zope Is it possible to tell zope to store the data.fs file on another directory? eg. /home/zope/var ie. Can you run zope from the directory /usr/local/zope and let it use the data.fs file from /home/zope/var and not /usr/local/zope/var If so, how can I do this? Thanks, Tom ___ Zope maillist - [EMAIL PROTECTED] 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] HTML - ZOPE?
Hi, I'm not sure if this is a strictly zope question, but I hope some people can give me an idea on how to solve this problem. I'm creating a form which has amonng it's input tags 2 comboboxes. Now, the content of one combobox, depends on the selection of the first combobox. How can I handle this in Zope, Html? Is this even possible in html? I assume, yes if you refresh the page each time the user makes a selection in the first combobox, but how? Thanks, Tom.
[Zope] ZSQLMethods
Hi, I'm wondering how the following can be done. I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] ZSQLMethods
Hi Chris, Thanks, is this code still efficient if the tables relate to 1:1 and you need to show a list of all records in a tabulare table? eg key, NAME, ALIAS, where NAME is from database1 and ALIAS is from database2 The code below would impact that for every record in database1, I've to query database2 Is there another way to do this? (more efficient?, ie less database query) Tom. - Original Message - From: "Chris Gray" [EMAIL PROTECTED] To: "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:45 PM Subject: Re: [Zope] ZSQLMethods You want something along these lines: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display record /dtml-in /dtml-in This would be more efficient than pulling out the whole of two tables. Chris On Mon, 4 Dec 2000, Tom Deprez wrote: Hi, I'm wondering how the following can be done. I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 )
Re: [Zope] ZSQLMethods
Yes, that's true, but then you're doubling the amount of data. And everytime you change the table in one database, you've to copy the table in the other database. What if this has to be done daily? So, I need to find a way from which we'll benefit the most. Tom. - Original Message - From: "Phil Harris" [EMAIL PROTECTED] To: "Chris Gray" [EMAIL PROTECTED]; "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 5:06 PM Subject: Re: [Zope] ZSQLMethods Depending on the number of records in the tables this could get *very* slow *very* quickly. Surely the ideal would be to move/copy the tables into the same DB. Phil - Original Message - From: "Chris Gray" [EMAIL PROTECTED] To: "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:21 PM Subject: Re: [Zope] ZSQLMethods Try something like: dtml-in selectFromTable1 dtml-in selectFromTable2 dtml-if idFromTable1 = idFromTable2 display parts of the two records /dtml-if /dtml-in /dtml-in This keeps it to two db queries and the join work is done by Zope. Chris On Mon, 4 Dec 2000, Tom Deprez wrote: Hi Chris, Thanks, is this code still efficient if the tables relate to 1:1 and you need to show a list of all records in a tabulare table? eg key, NAME, ALIAS, where NAME is from database1 and ALIAS is from database2 The code below would impact that for every record in database1, I've to query database2 Is there another way to do this? (more efficient?, ie less database query) Tom. - Original Message - From: "Chris Gray" [EMAIL PROTECTED] To: "Tom Deprez" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:45 PM Subject: Re: [Zope] ZSQLMethods You want something along these lines: dtml-in selectFromTable1 dtml-in expr="selectFromTable2(id=_['id'])" display record /dtml-in /dtml-in This would be more efficient than pulling out the whole of two tables. Chris On Mon, 4 Dec 2000, Tom Deprez wrote: Hi, I'm wondering how the following can be done. I've 2 databases. I want to do a 'join' with 2 tables, both in a different database. Is it possible to retrieve data of both tables with a ZSQLMethod and then do a programatically join? What's the easiest python way? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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] where (required)
Hi, I've a sort of interpretation error : I want to use the following query 2 ways : 1. Provinding the variables. (will give me one record) 2. Without providing the variables. (will give me all records). I use the following query : select * from address dtml-sqlgroup where dtml-sqltest A_CENTRENO column=ADDRESS.CENTRE_NO type=int optional dtml-and dtml-sqltest A_NAMELINE1 column=ADDRESS.NAME_LINE1 op=CONTAINING type=nb optional dtml-and dtml-sqltest A_POSTALCODE column=ADDRESS.POSTAL_CODE type=nb optional dtml-and dtml-sqltest A_CITY op=CONTAINING column=ADDRESS.CITY type=nb optional dtml-and dtml-sqltest A_STATEPROVINCE column=ADDRESS.STATE_PROVINCE type=nb optional dtml-and dtml-sqltest A_AREANO column=ADDRESS.AREA_NO type=nb optional dtml-and dtml-sqltest A_PHONENO column=ADDRESS.PHONE_NO type=nb optional Although the where clause is optional, even the parameters are optional, if I just call the method without parameters, I get the following error. Is this normal? Why then is there a parameter 'required' with the Where-tag? Error Type: Bad Request Error Value: ['A_CENTRENO', 'A_NAMELINE1', 'A_POSTALCODE', 'A_CITY', 'A_STATEPROVINCE', 'A_AREANO', 'A_PHONENO'] Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] sqlgroup
Hi, Is there a reason why the attribute 'having' doesn't exists? I want to use dtml-sqlgroup having dtml-sqltest ... optional /dtml-sqlgroup this way when the sql-test tag contains nothing, also the having clause is not attached to the query. Why does 'where' exists and 'having' not? Is there another way to mimic 'having'? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] DTML source
Hi, Are there some sites which publish there DTML source(structure)? I'm particulary looking on how several navigation, menu, ... structures are implemented in Zope. On Zope.org you can see the DTML-source. Unfortunately not the implementation of the navigation (or the menu on the left). Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Objection to Python Script Name
Why not just Python Script Perl Script ? Tom. At 13:17 23/11/2000 -0400, Dany Rioux wrote: I have to agree with Chris (Gray). It is enough confusing already (for me it is that is :). I personnaly think that a name like "ZoPy Scripting" (w/ or w/o Method) should be used. My 0.02c Dany Subject: Re: [Zope] Objection to Python Script Name Chris Gray wrote: I know, I know. It's a little late to speak up, but I think there is a logical objection to this name: inconsistency with "DTML Method" and "ZSQL Method". These are old, horrible and will hopefully be re-thought and given different names ;-) ZIP Method (Zope Internal Python Method) ZoPy Method PyZo Method ZPython Method :-( All imply there is soem difference between the Python used by Zope and any other python ,which isn't, and never should be, the case... cheers, Chris Attachment Converted: "Z:\xrad002\eudora\Attachments\smime11.p7s" ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Date
Hum, but then you also have to take into account the possible year change. But a nice idea. Tom. At 23:17 21/11/2000 +0100, Dieter Maurer wrote: Tom Deprez writes: Does someone knows how to calculate the date after 6 months of a certain date? eg ZopeTime() + 6 months? Is there an easy formula for this? Or do I've to check myself for a new year, leap year When I would need it (and did not find a better method), I would use (in an external method): 1. convert to a Python time tuple 2. add 6 to the month component (creating a new tuple) 3. convert back to a DateTime object. It might be necessary to normalize the time tuple before 3. with an "time.localtime(time.mktime(tup))". Dieter ___ Zope maillist - [EMAIL PROTECTED] 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] Date
Does someone knows how to calculate the date after 6 months of a certain date? eg ZopeTime() + 6 months? Is there an easy formula for this? Or do I've to check myself for a new year, leap year Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] expr
I get an error when using following expr: dtml-in expr="address_select(ADDRESS.CENTRE_NO=CENTRENO)" This is due to the . in ADDRESS.CENTRE_NO how can I use ADDRESS.CENTRE_NO so that I don't get this error? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] normal result with acquisition?
Assume following : Folder1 sql show_abc method_showdata Folder2 show_abc method_showdata has among it the following code : dtml-with sql dtml-in selectallcentres tabletrtd dtml-var show_abc /td/tr/table /dtml-in /dtml-with 1) When you call this function from Folder1 : show_abc of folder1 is used 2) When you call this function from Folder2 : show_abc of folder1 is used -- what you wouldn't expect? However: 3) Removing the dtml-with sql tag (and moving selectallcentres to folder1), Calling method_showdata in Folder2 : show_abc of folder2 is used. -- what you would expect Am I overlooking something of the acquisition here? Why does it uses in the second case (2) not show_abc? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Zope in Windows is faster than Linux ???
Why do you test the one with ZServer and the other with Apache? If you want correct results you've to test both with ZServer or both with Zope behind Apache. Not? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Integers in ZSQLMethod
Hi, Is it possible to use following code in ZSQLMethod : !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int --, But also allow null as value for the integer? (Thus not filled in) Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Integers in ZSQLMethod
Argh, dumb me. That I didn't think of this myself. Boy, do I feel myself stupid and red. Tom. At 15:12 04/10/2000 +0200, Ralph Heinkel wrote: On Wed, 04 Oct 2000, you wrote: Hi, Is it possible to use following code in ZSQLMethod : !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int --, But also allow null as value for the integer? (Thus not filled in) use !--#sqlvar NMRSEQS.PAR_FLIPANGLE type=int optional-- or the newer syntax dtml-sqlvar MRSEQS.PAR_FLIPANGLE type=int optional Ralph -- Ralph Heinkel Cenix Bioscience GmbH Director of the IT-UnitTel : +49 6221/387 915 Meyerhofstr. 1 Fax : +49 6221/387 971 69117 Heidelberg, Germany eMail: [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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] Guidelines for showing most exciting things of Zope?
Hi, When I tell people about Zope and give a demo, at the end, I always realise that I could have told this and that and that I forgot this and that. Now, has somebody already prepared some things which could be used as a practical guideline when presenting Zope to outsiders? If not, what do you think would need to be told to convince people that it's worth looking at it by themselfs? Do people think such a practical guideline would be usefull? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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-dev] bouncing e-mail
Hi, Has somebody noticed some problems with my e-mail? It looks like my account was turned of at zope-dev. Since I didn't do it, it must be an automatic thing. So my q'n had someone of you problems with my e-mail? Tom. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope] Return an object?
Hi, Can someone tell me how I can get the object with a certain 'id'? Does getObject exists or something? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] SQL
Hi, Somebody experience with a parent code table and how to implement it in Zope (with dtml-tree)? Or is a PArent-Code table not SQL-like and is there a better solution? eg : Parent Code Description 0 0 MasterNode 0 1 Child1 of MasterNode 0 2 Child2 of MasterNode 1 3 Child of Child1 Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Important Security Concerns
I know not much about security because I don't have to worry about it, but out of your talk, it seems that your company finds apache secure. Then why don't you just run Zope behind Apache with a FASTCGI, or something else? Sorry if I'm completely missing the point of your problem. Regards, Tom. At 08:31 12/09/2000 -0400, you wrote: That would cause another whole set of problems, unless apache is inherity more secure than Medusa. I was really wondering what the risks are associated with those two options. - Bryan Patrick Coleman Questcon Technologies (336)273-2428 ext-416 [EMAIL PROTECTED] -Original Message- From:Phil Harris [SMTP:[EMAIL PROTECTED]] Sent:Tuesday, September 12, 2000 5:15 AM To: Coleman, Bryan; [EMAIL PROTECTED] Subject: Re: [Zope] Important Security Concerns Another option might be to proxy the Zope server through Apache on port 80. - Original Message - From: "Coleman, Bryan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 12, 2000 12:43 PM Subject: [Zope] Important Security Concerns I almost have my company convinced that Zope is the technology to use for our Intranet/Extranet. However they are very concerned with security. I have proposed two security schemes that I would like zope community feed back on for potential holes. Option A: Poke a hole through our firewall on the primary http port or on port 8080 to allow Zope pages through and then require authentication on the first page. Option B: Set up a DMZ off the firewall to allow the same as the above. Any feed back would be welcome. - Bryan Patrick Coleman Questcon Technologies (336)273-2428 ext-416 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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] ZSQL
Hi, I use an ZSQLMethod to query a database. In the result report I try to insert the results of another ZSQLMethod per each record of the first result report. The problem is that the first record shows the correct result of the second result, but that the following records all show the second result report of the first record. Here follow some code snippets: This query (contact_lookup) is called from the second report : select * from CONTACTPERSON dtml-sqlgroup where dtml-sqltest ADDRESS.CENTRE_NO column=CONTACTPERSON.CENTRE_NO type=int optional /dtml-sqlgroup Here is the second report (tabular_contact_report) : dtml-in contact_lookup size=50 start=query_start dtml-if sequence-start table border=0 /dtml-if sequence-start tr tddtml-var CONTACT_NO null=""/td tddtml-var CENTRE_NO null=""/td tddtml-var CONTACT_NAME/td tddtml-var CONTACT_TYPE/td tddtml-var PHONE_NO/td tddtml-var EMAIL_ADDRESS/td /tr dtml-if sequence-end /table /dtml-if sequence-end dtml-else None /dtml-in And here is a piece of the first report ( tabular_address_report): dtml-in address_lookup size=5 orphan=0 start=query_start !-- Contactpersons -- tr td colspan=2 table width="100%" tr td width="3%" /td td bgcolor="#EE" border="0" dtml-var CENTRE_NO null="" smallbContactpersons/b/smallBR /td /tr tr td width=30 /td td dtml-var tabular_contact_report /td /tr /table /td /tr /table /dtml-in It looks like the query is only done with the first request (ie record no 1) and not with the following record. Because the second query returns always the same results (although I call the query with a different where parameter). What am I doing wrong? Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] open a database connection
Hi, How can I open a database connection from dtml? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] open a database connection
Hi, sorry, found it by myself somewhere in the zope directory: for the people who are interesed: manage_open_connection manage_close_connection Regards, Tom. At 14:46 17/08/2000 +0200, Tom Deprez wrote: Hi, How can I open a database connection from dtml? Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 - [EMAIL PROTECTED] 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] Difference between 2 permissions
Hi, What is the difference between Open/Close database connection and Open/Close database connections Thanks in advance, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] problems connections to database
Hi, I get a strange error here. Suddenly the connection to my interbase db doens't works anymore. I get the following message : H2Zope Error/H2 PZope has encountered an error while publishing this resource. /P PSTRONGProducts.gvibDA.gvib.gvibExceptions.Error/STRONG/P Sorry, a Zope error occurred.p !-- Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 240, in abort File /usr/local/zope/lib/python/ZODB/Transaction.py, line 155, in abort File /usr/local/zope/lib/python/Shared/DC/ZRDB/TM.py, line 126, in abort File /usr/local/zope/lib/python/Products/gvibDA/db.py, line 178, in _abort File gvib/gvib.py, line 466, in rollback Error: - Unable to complete network request to host quot;localhostquot;. -- Error writing data to the connection. -- Broken pipe The thing is that I can access to the database with another program, but with Zope I get this error. It has worked the past days, but now it keeps returning this error. Anybody an idea? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] Connection problem with database
Hi, If somebody had the same problem as I've now, please let me know something: At certain moments, Zope encounters problems connecting to my database (Interbase, don't know if it is solely Interbase related). When I then Close and reopen the connection, everything works fine again. Somebody experienced this also? Found the error? Or what am I doing wrong? More information on my situation: The database isn't visited often at the moment (only by me). This is just a test-setup. The error happens when there is a long time between 2 requests. As if the connection closes itself, but doesn't opens itself again. Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] In-tag Batch processing
Thanks Dieter, But I'm using Zope 2.2 So what am I doing wrong? Regards, Tom At 23:02 10/08/2000 +0200, Dieter Maurer wrote: Tom Deprez writes: But how can you provide a link to the next batch of items at the start of the batch table? You need Zope 2.2 or the patch at URL:http://www.dieter.handshake.de/pyprojects/zope/dt_in.pat or you use the "next" argument of the "in" tag. Dieter ___ Zope maillist - [EMAIL PROTECTED] 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] Batch processing
Hi,
few q'ns concerning batch processing:
1. I want the user to be able to choose a batch-page. So, when a query is
done, I want to show something like :
previous page 1 - 2 - 3 - 4 - 5 next page.
The following code works partly: ie. the one thing missing is that it
doesn't shows the current page. How can I implement this?
dtml-in address_lookup previous size=5 start=query_start
dtml-in previous-batches mapping
dtml-unless sequence-startnbsp;
/dtml-unless
a href="dtml-var document_iddtml-var
sequence-queryquery_start=dtml-var batch-start-number"
dtml-var
"(_.getitem('batch-start-index',0)/_.getitem('batch-size',0))+1"/a
/dtml-in
/dtml-in
dtml-in address_lookup next size=5 start=query_start
dtml-in next-batches mapping
dtml-unless sequence-startnbsp;
/dtml-unless
a href="dtml-var document_iddtml-var
sequence-queryquery_start=dtml-var batch-start-number"
dtml-var
"(_.getitem('batch-start-index',0)/_.getitem('batch-size',0))+1"/a
/dtml-in
/dtml-in
dtml-in address_lookup size=5 start=query_start
...
/dtml-in
2. Is there an easier way to get what I want?
3. Does the above code means that it has to iterate 3 times over the list?
Isn't there a way so that it needs only one pass over the list?
Thanks in advance,
Tom Deprez.
___
Zope maillist - [EMAIL PROTECTED]
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] Batch Processing, final
Pfew, I managed to implement the thing I wanted. However I'm not satisfied.
There must be an easier solution. If somebody knows which, then please let
me know! Thanks. Here is the code I use to display something like in a
search result :
Previous 1 2 3 4 5 6 Next
dtml-in address_lookup size=5 start=query_start
dtml-if sequence-start
pSearch Result : dtml-var count-CENTRE_NOnbsp;matchesp
table width="100%"
tr
td align="left" width="60"
!-- if not first page then show previous button --
dtml-if previous-sequence
a href="dtml-var URLdtml-var
sequence-queryquery_start=dtml-var previous-sequence-start-number"
dtml-var "gif_previous.tag(border='0')"/a
/dtml-if
/td
td align="center"
!-- show previous page numbers --
dtml-in address_lookup previous size=5 start=query_start
dtml-in previous-batches mapping
a href="dtml-var document_iddtml-var
sequence-queryquery_start=dtml-var batch-start-number"
dtml-var
"(_.getitem('batch-start-index',0)/_.getitem('batch-size',0))+1"/a
/dtml-in
/dtml-in
!-- show present page number--
dtml-var
"(_.getitem('sequence-index',0)/_.getitem('sequence-step-size',0))+1"/a
!-- show next pages numbers--
dtml-in address_lookup next size=5 start=query_start
dtml-in next-batches mapping
a href="dtml-var document_iddtml-var
sequence-queryquery_start=dtml-var batch-start-number"
dtml-var
"(_.getitem('batch-start-index',0)/_.getitem('batch-size',0))+1"/a
/dtml-in
/dtml-in
/td
td align="right" width="60"
!-- if not last page then show next button --
dtml-if
"((_.getitem('sequence-index',0)+_.getitem('sequence-step-size',0))+1)
(_.getitem('count-CENTRE_NO',0))"
a href="dtml-var URLdtml-var
sequence-queryquery_start=dtml-var
"(_.getitem('sequence-index',0)+_.getitem('sequence-step-size',0))+1""
dtml-var "gif_next.tag(border='0')"/a
/dtml-if
/td
/tr
/table
/dtml-if sequence-start
show present page results ...
/dtml-in
Regards, Tom.
___
Zope maillist - [EMAIL PROTECTED]
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] Login and password
Hi, I'm wondering is it possible to implement a way that Zope asks for a password, but not for a login? eg. like you would give several people the same login password, but that the users don't have to enter the login, only the password? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] In-tag Batch processing
Perhaps a stupid question, But how can you provide a link to the next batch of items at the start of the batch table? or : assume you have a result from a query, which is shown in batches of 5 items and you want to be able to allow the users to choose a page. How can you show these possible selections, before you show a batch? I tried several things, but I can only show it a the end of a batch but not at the beginning of a batch Thanks, Tom ___ Zope maillist - [EMAIL PROTECTED] 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-dev] Permission
Hi, I have this q'n already a long time in my head and I still don't know the answer to it. It has to do with the security-view. I hope that someone can shed a light on my brains. Why is their an Acquire permission (referred to as acq_perm in following text) checkbox column? In order to change a permission for a certain role, we have to check or uncheck this permission at the roles permission checkbox. However, for this to work we have to uncheck the acq_perm column (because if this one is checked, the permission is taken from parent-folder-objects anyway, the value of the role checkbox doesn't counts at that moment). As a drawback, this means that all roles have to be checked/unchecked, because they don't acquire the permission anymore from one of its parents-folder-objects. Now, why couldn't this be implemented like the following? Isn't this easier to grasp? The Acq_perm column doesn't exists. Assume that acquisition of a permission is always Active. The checkboxes of the role show their actual value (according to the acquisition). Thus if permissionA is checked in the parent-object, permissionA is also checked. If you want, for a certain role that this permission is not given, you uncheck permissionA. The subobject will show an unchecked permissionA box (because it acquires from its parent). In order to give the subobject again the permission, we only have to check permissionA. A) In the first approach we've to uncheck the acq_perm checkbox and have to set the checkbox of every role according to how we want the permission to be handled by that role. B) In the second approach we've to uncheck the permission checkbox of the role(s). Other roles are not effected. Am I missing something here? Is my explenation somewhere wrong? Why does Zope uses the first approach? Which, sounds for me, a little bit more complicated. Thanks for any explanation! Tom Deprez. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )
[Zope] Previous Message
Hi all, Please, forget my previous message! Next question : Is there an easier way for writing the following? dtml-let position=sequence-item dtml-var expr="position+1"/dtml-var count-CENTRE_NO dtml-let This gives the sequence order of every record on the total amount of retrieved records. So far, this was the only way I could get it to work. Is there a better way (simpler) ? Thanks, Tom. ___ Zope maillist - [EMAIL PROTECTED] 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] tracebacks
Hi,
Can somebody explain me how you can use the given tracebacks to find the
possible error? For example, I get the following error and I know what
causes it, but I don't know where I must go to find the code-line where the
error starts:
I get the following error when I use a table in which a field is defined
with a default string value.
eg :
MY_NAME CHAR(20) DEFAULT 'tom'
MY_DATE TIMESTAMP DEFAULT '6/07/2000'
MY_DATE TIMESTAMP DEFAULT 'NOW'
---
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: cPickle.PicklingError
Error Value: Cannot pickle objects.
---
!--
Traceback (innermost last):
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in
publish_module
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish
File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in
zpublisher_exception_hook
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 175, in publish
File /usr/local/zope/lib/python/Zope/__init__.py, line 235, in commit
File /usr/local/zope/lib/python/ZODB/Transaction.py, line 251, in commit
File /usr/local/zope/lib/python/ZODB/Connection.py, line 348, in commit
(Info: (('Products.ZnolkSQLWizard.Wizard', 'ZnolkSQLWizard'),
'\000\000\000\000\000\000\015\025', ''))
cPickle.PicklingError: (see above)
--
Thanks for any advice.
Tom
___
Zope maillist - [EMAIL PROTECTED]
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 )
RE: [Zope] tracebacks
A) your SQL is wrong, you want a VARCHAR not a CHAR there. and i doubt
'NOW' is a valid value for a TIMESTAMP type in your DB. You'll be wanting a
SQL function like Date(), not a string. Probably. Look in your DB docs.
Not that I'm much of a SQL person - someone else will probably correct me.
I'm using an Interbase database. You can use CHAR and VARCHAR. The last one
is a variable char, while the first has a fixed length. Anyway, this was
just an example out of my head to explain what I'm experiencing. 'NOW' can
be used in Interbase as it will insert the current datetime when a value
is not given for a record. (Although, I'm not sure it will work through
Zope, I'm just curious :-) ). Anyway, '12/07/2000' should work.
B) Now why you'd get a pickling error when you've got bad SQL i don't know -
and 'cannot pickle objects' is a blantant lie. Surely that's what
pickling's all about.
MY_NAME VARCHAR(20) DEFAULT 'tom', gives the same error. And yes, it's
strange that I get an error with a default literal value. Could it be that
Zope handles the tom in 'tom' as a python expresion or something?
Anyway you read the traceback from bottom to top.
The error occured on line 348 of Connection.py, which threw an error in
Transaction.py, blah blah, which threw an error in Publish.py, which caused
Zope to exit the publisher and print the stack trace.
Thanks Seb, this is what I wanted to know about the traceback.
Tom.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom
Deprez
Sent: 01 August 2000 12:41
To: [EMAIL PROTECTED]
Subject: [Zope] tracebacks
Hi,
Can somebody explain me how you can use the given tracebacks
to find the
possible error? For example, I get the following error and I know what
causes it, but I don't know where I must go to find the
code-line where the
error starts:
I get the following error when I use a table in which a field
is defined
with a default string value.
eg :
MY_NAME CHAR(20) DEFAULT 'tom'
MY_DATE TIMESTAMP DEFAULT '6/07/2000'
MY_DATE TIMESTAMP DEFAULT 'NOW'
---
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: cPickle.PicklingError
Error Value: Cannot pickle objects.
---
!--
Traceback (innermost last):
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in
publish_module
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line
187, in publish
File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in
zpublisher_exception_hook
File /usr/local/zope/lib/python/ZPublisher/Publish.py, line
175, in publish
File /usr/local/zope/lib/python/Zope/__init__.py, line 235,
in commit
File /usr/local/zope/lib/python/ZODB/Transaction.py, line
251, in commit
File /usr/local/zope/lib/python/ZODB/Connection.py, line
348, in commit
(Info: (('Products.ZnolkSQLWizard.Wizard', 'ZnolkSQLWizard'),
'\000\000\000\000\000\000\015\025', ''))
cPickle.PicklingError: (see above)
--
Thanks for any advice.
Tom
___
Zope maillist - [EMAIL PROTECTED]
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 - [EMAIL PROTECTED]
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 )
