Re: Problem in Fetching values from the ZSQL method
"Charlie Clark" <[email protected]>
| Newsgroups | gmane.comp.web.zope.devel,gmane.comp.web.zope.database |
|---|---|
| Organization | Clark Consulting & Research |
| Message-ID | <[email protected]> |
Am 19.05.2010, 09:48 Uhr, schrieb joseph_ig <[email protected]>: > 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 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 = > GROUP BY SecID > This ZSQL method takes a single parameter "seqID" of type "int" > This ZSQL method script is called within a Python_script as follows > context.getSummaryValue(seqID = SequenceID) > the "SequenceID" is passed in as a request variable to the python > script. I > have two sites one testing and another Live. > In testing site the script does return value for the sequenceID passed > into it as a request variable. > But while running in Live environment it doesn't return any value for > the sequenceID passed into it as a request variable. > But when the sequeneceID is hardcoded into the python script it does > return > the details in LIVE. I don't see seqID being used in the statement. You can debug the call by passing in the src__=True parameter. This will allow you to see exactly what SQL is being sent to the database. > Please help to resolve the issue. All help are really appreciated. Its > really critical Please help. Charlie -- Charlie Clark Managing Director Clark Consulting & Research German Office Helmholtzstr. 20 Düsseldorf D- 40215 Tel: +49-211-600-3657 Mobile: +49-178-782-6226 _______________________________________________ Zope-Dev maillist - [email protected] https://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope )