Re: Problem in Fetching values from the ZSQL method

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

Could you please explain how to make use of the src__=True parameter and
where can we view exactly what SQL is being sent to the database.
Please clarify in details.





Charlie Clark-6 wrote:
> 
> 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 )
> 
> 

-- 
View this message in context: http://old.nabble.com/Problem-in-Fetching-values-from-the-ZSQL-method-tp28605115p28609879.html
Sent from the Zope - Dev mailing list archive at Nabble.com.

_______________________________________________
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 )