Problem with input parameters like ? [message #669842] |
Wed, 11 May 2011 18:59 |
gin1975 Messages: 30 Registered: April 2011 |
Member |
|
|
Hello,
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?
Thanks.
|
|
|
Powered by
FUDForum. Page generated in 0.02637 seconds