Eclipse Community Forums: BIRT » Executing Query with a '%' character

Help

Home

Home » Archived » BIRT » Executing Query with a '%' character

Show: Today's Messages :: Show Polls :: Message Navigator

Executing Query with a '%' character [message #499536]

Mon, 23 November 2009 10:04

Jan Kohnert

Messages: 196
Registered: July 2009

Senior Member

Hello,

I'm working with an Sybase Database and for that have to use the percent character ('%') as wildcard in querys. When ever using this charatcer within a parameter value I get a script exception. Do I have to demask the char? and yes, how?

Thanks!
Jan

Report message to a moderator

Re: Executing Query with a '%' character [message #499688 is a reply to message #499536]

Mon, 23 November 2009 17:38

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Jan,

Can you try entering the % in the beforeOpen script of the dataset?
Something like

this.queryText += " where customername like 'a%'";

This assumes you have entered something like Select * from customers in
the query builder.

Jason
Jan Kohnert wrote:
> Hello,
>
> I'm working with an Sybase Database and for that have to use the percent
> character ('%') as wildcard in querys. When ever using this charatcer
> within a parameter value I get a script exception. Do I have to demask
> the char? and yes, how?
>
> Thanks!
> Jan

Report message to a moderator

Previous Topic:	previous/next group - referring to row by position
Next Topic:	Detail columns instead of detail rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 13:00:29 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter