[Zope-dev] Problem in Fetching values from the ZSQL method

2010-05-19 Thread joseph_ig
Hi all, I have written a ZSQL method named ('getSummaryValue') for fetching the summary result from a table. Please see the following query. SELECT SecID ,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos ,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos FRO

[Zope-dev] buildbot for ZTK released packages (linux 32)

2010-05-19 Thread Christophe Combelles
It's live again. This one tests only released packages: http://buildbot.afpy.org/ztk1.0/waterfall Failures : python2.4 : zope - zope.browserpage - zope.viewlet - zope.contentprovider - zope.defferedimport - zope.app.wsgi python 2.5 and 2.6 : - zope.app.wsgi python2.7b2 : - zope.testing - zope.

[Zope-dev] Zope Tests: 12 OK, 8 Failed

2010-05-19 Thread Zope Tests Summarizer
Summary of messages to the zope-tests list. Period Tue May 18 12:00:00 2010 UTC to Wed May 19 12:00:00 2010 UTC. There were 20 messages: 6 from Zope Tests, 13 from ccomb at free.fr, 1 from ct at gocept.com. Test failures - Subject: FAILED : ZTK 1.0 / Python2.6.4 Linux 32bit From: cc

Re: [Zope-dev] Problem in Fetching values from the ZSQL method

2010-05-19 Thread Charlie Clark
Am 19.05.2010, 09:48 Uhr, schrieb joseph_ig : > Hi all, Hiya Joseph, zope-db is a better list for this discussion. > I have written a ZSQL method named ('getSummaryValue') for fetching the > summary result from a table. Please see the following query. > SELECT > SecID > ,SUM(CASE WHEN txnType I

Re: [Zope-dev] buildbot for ZTK released packages (linux 32)

2010-05-19 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Christophe Combelles wrote: > It's live again. This one tests only released packages: Great! That should induce us to stay on the ball about making releases for 'fixcommitted' bugs. > http://buildbot.afpy.org/ztk1.0/waterfall > > Failures : > > p

Re: [Zope-dev] Problem in Fetching values from the ZSQL method

2010-05-19 Thread joseph_ig
Hi Charlie, Let me thank you first for the help. SELECT SecID ,SUM(CASE WHEN txnType IN('pi') THEN quantity ELSE 0 END) AS InitPos ,SUM(CASE WHEN txnType IN('pe') THEN quantity ELSE 0 END) AS EndPos FROM Txntemp WHERE Txntemp.fileImportID = < dtml-sqlvar seqID type="int" > GROUP BY SecID Cou

Re: [Zope-dev] buildbot for ZTK released packages (linux 32)

2010-05-19 Thread Martijn Faassen
Tres Seaver wrote: >> python 2.5 and 2.6 : >> - zope.app.wsgi > > I plan to work on fixing this failure, which is due to moving the > zope.testbrowser pin from 3.8.2 to 3,9.1. How are you going to fix it? I'm asking because we depend on zope.app.wsgi for the browser testing of Grok now, at leas

Re: [Zope-dev] buildbot for ZTK released packages (linux 32)

2010-05-19 Thread Tres Seaver
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Martijn Faassen wrote: > Tres Seaver wrote: > >>> python 2.5 and 2.6 : >>> - zope.app.wsgi >> I plan to work on fixing this failure, which is due to moving the >> zope.testbrowser pin from 3.8.2 to 3,9.1. > > How are you going to fix it? I'm asking b

Re: [Zope-dev] buildbot for ZTK released packages (linux 32)

2010-05-19 Thread Martijn Faassen
Tres Seaver wrote: > I don't know yet -- I planned to look at the failure more closely, and > figure out something that would work with the newer mechanize. Just for your information, what we're doing is using wsgi_intercept, which hooks into zope.testbrowser, which uses mechanize. But I think w