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.
_______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org 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 )