[Zope-dev] Problem in Fetching values from the ZSQL method
joseph_ig
gladiatorg4 at gmail.com
Wed May 19 03:48:37 EDT 2010
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
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 .
Please help to resolve the issue. All help are really appreciated. Its
really critical Please help.
--
View this message in context: http://old.nabble.com/Problem-in-Fetching-values-from-the-ZSQL-method-tp28605115p28605115.html
Sent from the Zope - Dev mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-dev/attachments/20100519/b57b9a25/attachment.html
More information about the Zope-Dev
mailing list