|Problem with input parameters like ? [message #669842]
||Wed, 11 May 2011 14:59
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
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?
Powered by FUDForum
. Page generated in 0.14260 seconds