Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problem with input parameters like ?(Report parameter)
Problem with input parameters like ? [message #669842] Wed, 11 May 2011 18:59
gin1975  is currently offline gin1975 Friend
Messages: 30
Registered: April 2011

I have a problem when filtering reports from a user-entered parameter. I put a simple example for you to try to pinpoint the problem:

- The user must enter a parameter from a listbox with a number of values ​​of relating to clients. Example: customer1, customer2, customer3, etc.
- Looking for that parameter input, I'm trying to work the following Dataset from a DB that contains the list of customers and their associated information (ID, email, etc.). Data Set Query:

select id, email
from customers
WHERE email.customers like "%?%"

The problem is that this query gives me the following error: SQL error # 1: Parameter index out of range (1> number of parameters Which is 0).

Using other sentences such as like ? or =? works, but in this case, I need to make the condition which I have indicated above.

Can you tell me where is the problem?

Previous Topic:Table has inconsistent column count error
Next Topic:Problem with input parameters like ?
Goto Forum:

Current Time: Thu Jun 21 20:28:46 GMT 2018

Powered by FUDForum. Page generated in 0.01758 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top