- Zope - Zope lists

Error handling in zope/ ext method calling a sproc to insert data into sql db?
by Alisa K 18 Jan '03

18 Jan '03

I'm working on adding detailed error handling to an existing zope web application. The web application (a series of web pages served by zope) includes an html form that inserts inputted data (and data in hidden fields) into a sql database. The form currently submits the data to a dtml document that uses a Z SQL method to do the insert <dtml-in expr="zsql_nameofmethod(param1=1,param2=2, etc...). The Z SQL method, zsql_nameofmethod, is actually a simple stored procedure call (exec storedprocedurename ). Currently there is no error handling and all submissions seem to "go through," even when the sproc insert fails. Thus, I need to add custom error_handling to display an appropriate error message to the front-end user when the sproc call fails to insert. I've searched the web for any kind of help but have not found much to go on. A simple <dtml-try><dtml-except> block doesn't catch any error from the sproc. In the past I've taken the sproc call out of zope and put it into an external method (python). I've gotten more detailed error handling to work successfully from the external method by raising a RuntimeError and formatting what I get from sys.exc_info(). However, is there a better way to handle errors with zope/python/sql databases from within zope rather than in external methods? running Zope 2.5.1 (Python 2.1.3) on Win2k connecting to SQL database. External methods connected to database using win32com.client.Dispatch('ADODB.Connection')... Alisa __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

2 3

zope-announce@zope.org
by Andreas Jung 18 Jan '03

18 Jan '03

I am pleased to announce the release of CMFCollectorNG 0.20 beta1 CMFCollectorNG is a Zope/CMF-based bugtracking system (based on CMFCollector). Major features of CMFCollectorNG: * major code cleanup and complete new skins * very generic to add new ticket properties to a tracker * enhanced tracker configuration through the web * extend usage of the CMF memberdata tool to store user informations and user preferences * rewritten transcript to keep issue related informations in an abstract format to produce different output (HTML, plain text for email notifications) * tickets can have references to other tickets (also across CMFCollectorNG instances) * dedicated views for uploaded files and references to other tickets * better roles management: o TrackerAdmins manage the tracker o Supporters can file tickets, create followups, upload files, add references to other tickets o Reporters can file new tickets and upload files and references * XML export (to be used with XMLRPC) * watchlist/monitoring functionality * Plone compatibility * much more minor improvements (too much to mention them :-) ) Changes since 0.20alpha1: * completed English UI * better CMF and Plone compatiblity * lots of minor fixes Project page: http://www.zope.org/Members/ajung/CMFCollectorNG/Wiki/FrontPage Downloads: http://sourceforge.net/project/showfiles.php?group_id=68417 --------------------------------------------------------------------- - Andreas Jung http://www.andreas-jung.com - - EMail: andreas at andreas-jung.com - - "Life is too short to (re)write parsers" - ---------------------------------------------------------------------

1 1

Searching a Catalog in Zope 2.6.1b1
by Peter Bengtsson 18 Jan '03

18 Jan '03

I have started testing my product in Zope 2.6.1b1 and notice an odd behaviour My code looks something like this: catalog = self.ICatalog # an instance of ZCatalog called ICatalog I have results1 = catalog() print results1 # returns 25 as expected results2 = catalog({'email':'peter'}) # ...in Zope 2.5.0 print len(results2) # returns 2 as expected # ...in Zope 2.6.1b1 print len(results2) # returns 25, i.e. as if the 'email' index is ignored!!! Why this strange behaviour? A bug in Zope2.6.1b1 ? How do I go around it? I tried the mailinglist but failed to find the discussion. I also tried inspecting the code but didn't understand anything. Peter

3 9

re: Length of results set
by Ken 18 Jan '03

18 Jan '03

Dylan Reinhardt wrote: > Having mastered DTML, many new Zopistas are tempted to over-use it. > The best advice to offer here is: Don't. Thanks for your insightful remarks. I will use them as a guide. As an end-user, coming from the content side and with no background in computer science, it's taking a while to pick up on good programming practice. Just getting Zope to do what I want is fun and rewarding, but should be more if it can be done with style! Best, Ken

1 0

Re: No BBQ? (was Re: [Zope] News about zope magazine)
by ZopeMag 18 Jan '03

18 Jan '03

Hi Chris, and others, Chris Withers wrote: > I guess this means no BBQ this year then? Do have a lot on my plate these days debunking FUD emails and all ;-) But would be more than happy to volunteer/help organize the 3rd (Big) Zope BBQ. If the DZUG is willing to extend their meeting to be international then I might be able to help flip burgers ;-) Regards, Mark -- ZopeMag - the only magazine devoted to Zope!

2 1

DataGrids - any suggestions?
by Satheesh Babu 18 Jan '03

18 Jan '03

Hi, I was looking at ASP.Net and one thing I really liked is their DataGrid control. Quite often, there comes requirements to make small databases (or small parts of databases) web enabled. It is easy enough in Zope to write SQL methods and make page templates as UI. Anyone has any suggestions about: - quick tricks that lets user manipulate a grid on the client side - insert/update/delete - easy client side JS validation - update to database I'm thinking of unearthing some JS libraries that let you manage a grid and then using normal Zope form datatypes like records to post it to a db. I'm not looking for a table-data maintainer. More like a list maintainer, mainly for master-child tables with one master record and multiple children records being maintained. - Babu -- Vattekkat Satheesh Babu http://vsbabu.org/

1 0

24 hr. support
by optouts＠bonbon.net 18 Jan '03

18 Jan '03

1 0

ZSyncer questions??
by AM 17 Jan '03

17 Jan '03

Hi, I have a few question regarding ZSyncer operation. 1. How do I automate the stuff so that I can cron-ize it using wget, if I have to approve of and select the objects to be synced everytime. ( the approval checkbox in the zsyncer props is off - dunno if that has any bearing on this at all). 2. The moment it syncs it marks the curent stuff as out of date. I KNOW its not but why?? TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

2 1

advice
by Jon Porter 17 Jan '03

17 Jan '03

I am looking for a web development environment that is in demand. Despite being a developer and a teacher of object oriented development languages, I, and my company, are experiencing an economic down-turn. Are Zope developers and trainers in demand? The product is interesting. Thank for any information you can provide. Jon Porter

2 1

Web Links product?
by Bin Zhang 17 Jan '03

17 Jan '03

Is there a Zope product for web links (like the WebLinks module in PHPNuke/PostNuke)? Thanks!

1 0