[Zope-dev] Re: [Zope] present data from db (multiple tables) using zpt
Create your sql statement to return the data from the 2 tables in one row joining the 2 tables on a uniquekey that is common to both tables. select table1.col1, table1.col2, table2.col3, table2.col6 from table1 join table2 on table1.uniquekey = table2.uniquekey hth, Mike On Fri, 2003-07-04 at 10:57, Exteam wrote: Hi, we are having a problem while presentation of values retreived from multi tables(from mysql) in ZPT we use zsql to retreive from each individual table. But while presentation part comes, we are unable to position the values from multi table in a single row . As it is apparant that a tr can repeat only a single table at a time by the tal functions. what we had tried is tr repeat='item python:container.zsqlmethodname() We want the Zpt to repeat more than one table in a single row. So that we could retreive the requisite values from the tables and present it. How can it be resolved. Thanks exteam Yahoo! India Mobile SMS using the Yahoo! Messenger; Download latest version. ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] Zope 2.7.0-b2 startup error on windows
I have recently installed Zope 2.7.0-b2 on windows XP and am getting the same error message as 2.7.0-b1 when starting zope. Is this truly an error message or just informational? 2003-09-05T11:37:23 BLATHER(-100) ZODB Commiting subtransaction of size 5382 Traceback (most recent call last): File C:\Program Files\Zope-2.7.0-b2\lib\python\Zope\App\startup.py, line 52, in startup m=imp.find_module('custom_zodb',[getConfiguration().instancehome]) ImportError: No module named custom_zodb Traceback (most recent call last): File C:\Program Files\Zope-2.7.0-b2\lib\python\Zope\App\startup.py, line 52, in startup m=imp.find_module('custom_zodb',[getConfiguration().instancehome]) ImportError: No module named custom_zodb -- 2003-09-05T11:37:23 INFO(0) Zope Ready to handle requests Thanks, Mike ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Zope 2.7.0-b2 startup error on windows
Try adding objects to your Zope, if that works and they stick around even after you restart Zope, then this isn't so much of a problem. However, it's nasty, and I suspect you find you may not be able to store objects to disk, so this does need fixing :-( Please file on http://collector.zope.org I love the ease of adding zope instances in 2.7!! After some further investigation I have found that a product that I am developing is causing the error to appear. The product appears to work fine in zope. I can add it, create objects with it and the objects are persistent. Can someone give me some advice on how to go about debugging my product to identify the offending code? The error appears in the following environments: SuSE 8.2 -- Zope 2.6.1 WinXP Pro -- Zope 2.7.x Thanks, Mike ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Zope 2.7.0-b2 startup error on windows -- SOLVED
I have found the offending code...he said sheepishly. In the __init__.py file I had the following: def initialize(context): ... import traceback; traceback.print_exc() instead of: def initialize(context): try: ... except: import traceback; traceback.print_exc() My thanks goes out to all who helped. Later, Mike After some further investigation I have found that a product that I am developing is causing the error to appear. The product appears to work fine in zope. I can add it, create objects with it and the objects are persistent. Can someone give me some advice on how to go about debugging my product to identify the offending code? The error appears in the following environments: SuSE 8.2 -- Zope 2.6.1 WinXP Pro -- Zope 2.7.x Thanks, Mike ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope ) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] datetime.pyd missing
Hi, If this is not the place to report this type of issue I apologize and would ask to be directed to the correct place. I downloaded and installed Zope-2.7.0-b3 for windows. It appears that datetime.pyd is missing from the DLLs directory. I was able to copy this file to this directory from a python 2.3.2 installation and all worked well Was this an oversight when packaging this release? Cheers, Mike ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] datetime.pyd missing
The correct place to report such bugs would be the Zope collector, http://collector.zope.org/Zope. Note that there is an existing bug report about this: http://collector.zope.org/Zope/1128 Thanks ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Zope 2.7 broken on Windows
Has there been any progress on this? Or is there a sensible work-around I can give to our users - other than to switch to Linux! The workaround is to install python 2.3.2 onto a windows machine and copy the datetime.pyd from the python installion to the appropriate location in your zope installation. I don't have my windows box in front of me but IIRC it goes in the Zope-2.7.0-b3/bin folder. hth, Mike ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Zope 2.7 broken on Windows
Better would be to install Python 2.3.3 and use that to run zope. This also gives the advantage of allowing easier installation of third party extensions to Python. That does make sense. I guess it is time to rtfm to learn how :) ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] Re: time exUserFolder
I have cc'd the zope list in case others may find this answer helpful. Hi, i read your question (seems quite recent). I've had the same problem and traced the problem to some forgotten import time in pgPropSource.py in the exUserFolder folder. If you add: import time below f.i. import cPickle Thank you. This resolves the issue. Upon further investigation I have found that that a bug report has been filed at http://sourceforge.net/tracker/index.php?func=detailaid=798772group_id=36318atid=416446 and remove the pgPropSource.pyc file after you've safed the change, restart Zope and hopefully it works than. Be careful not to test first in some remote deep folder before using it somewhere where being locked out can cause harm :-) Hope this works. Greetings Felix -- Felix Slager Shape * vorm aan informatie Spoorstraat 31 7101GR Winterswijk The Netherlands t: +31 (0)543 530099 f: + 31 (0)543 531718 e: [EMAIL PROTECTED] w: www.take-shape.nl ___ Zope-Dev maillist - [EMAIL PROTECTED] http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )