Eclipse Community Forums: BIRT » to jason: BIRT SP with IN parameter

Home » Archived » BIRT » to jason: BIRT SP with IN parameter

to jason: BIRT SP with IN parameter [message #252960]

Sun, 19 August 2007 21:53

Eclipse User

hi jason, i would like to pass the in parameter in an array type. Can
birt's stored procedure support the ARRAY IN parameter??

as your reference, i am using the birt2.1.1.

thanks

Re: to jason: BIRT SP with IN parameter [message #253068 is a reply to message #252960]

Mon, 20 August 2007 20:22

Eclipse User

Originally posted by: jasonweathersby.alltel.net

I am checking this, but I do not think it is currently supported.

Jason

70 wrote:
> hi jason, i would like to pass the in parameter in an array type. Can
> birt's stored procedure support the ARRAY IN parameter??
>
> as your reference, i am using the birt2.1.1.
>
> thanks
>

Re: to jason: BIRT SP with IN parameter [message #253091 is a reply to message #253068]

Tue, 21 August 2007 03:21

Eclipse User

hi jason,
you mean that birt2.1.1 do not support the ARRAY IN parameter?
how about the higher level or the actuate birt??

Re: to jason: BIRT SP with IN parameter [message #253195 is a reply to message #253091]

Wed, 22 August 2007 01:12

Eclipse User

hi jason,

from mysql to birt, is that have any escape sequence?
if i wish to pass a parameter in a long string and the long string format
is as " 'abc','abd','cc','ddd' ", can the birt recognize the ' and , ?

Re: to jason: BIRT SP with IN parameter [message #253199 is a reply to message #253195]

Wed, 22 August 2007 02:17

Eclipse User

Originally posted by: jasonweathersby.alltel.net

BIRT does not support array in parms, but you should be able to do it
with the string as you have shown.

Jason

70 wrote:
> hi jason,
>
> from mysql to birt, is that have any escape sequence?
> if i wish to pass a parameter in a long string and the long string
> format is as " 'abc','abd','cc','ddd' ", can the birt recognize the '
> and , ?
>

Re: to jason: BIRT SP with IN parameter [message #253293 is a reply to message #253199]

Wed, 22 August 2007 20:34

Eclipse User

ya, i can done it. but i when i am using the birt to pass a parameter with
single quote, and return to the mysql database, it doesn't give any
result. is that birt have something like the escape sequence like in the
uri?

Re: to jason: BIRT SP with IN parameter [message #253313 is a reply to message #253293]

Thu, 23 August 2007 11:09

Eclipse User

Originally posted by: jasonweathersby.alltel.net

If you need to use double quotes try:
"\"my string\""
instead of
"'my string'"

Jason

70 wrote:
>
> ya, i can done it. but i when i am using the birt to pass a parameter
> with single quote, and return to the mysql database, it doesn't give any
> result. is that birt have something like the escape sequence like in the
> uri?
>
>

Previous Topic:	BIRT2.1.3: NullPointerException at guessOS
Next Topic:	Need help! Report don't show with frameset

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 15 13:41:50 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter