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

[Charlie Clark]

Am 19.05.2010, 09:48 Uhr, schrieb joseph_ig <gladiatorg4 at gmail.com>:

> 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