Bug 353947

Summary: SQL Parameters Problem
Product: z_Archived Reporter: hennesseyj
Component: BIRTAssignee: Birt-DataAccess <Birt-DataAccess-inbox>
Status: NEW --- QA Contact: Maggie Shen <lshen>
Severity: normal    
Priority: P3 CC: bluesoldier, hennesseyj
Version: 3.7.1Keywords: usability
Target Milestone: ---   
Hardware: PC   
OS: Windows Vista   
Whiteboard:

Description hennesseyj CLA 2011-08-04 19:43:19 EDT 
Build Identifier: 3.7.0.v20110603-809u78FT0z0-TVCu7ujN7w

Hi This is doing my head in! I'm a noob. 
I have a stored proc, which I am able to run with usual parameters if I hard code them e.g {call proc('2011-08-03','b','arg1|arg2|arg3')}

Now the problem. When I try and use the variables through the parameters option the query would appear to work fine but what is happening is the third variable, which has a pipe | as a delimiter, only picks up the first word.
This is the statement used for the parameters: {call proc(?,?,?)}

I have tried various scenario's for data used in the parameters, such as using single/double quotes, no quotes and convert.. without any luck.

I'm thinking that there is some inherent problem so I was wondering if someone could show me how I would go about passing the variables through a script. Or could suggest another method.

Cheers

JAH



Reproducible: Always
Comment 1 Xiaoying Gu CLA 2011-08-24 03:42:35 EDT 
Hi there,
the data set parameter in BIRT can only accept one value. When the parameter is linked with a report parameter allowing multiple values, it will accept the first value.

May you should modify your stored procedure to parse the parameter. 

Or could you attached your report design and stored procedure that we can investigate into this case ?

Thanks.