jlo_bidlo
|
Posted: 01/13/2003, 7:41 AM |
|
Hi,
hope someone can help. I get the following message when I try and performa search with the OR option selected i.e. one search field for all fields, all display grid data source criteria is in the form
contains (like '%...%')
Error description: The value in field urls_keyword is not valid.
has nayone come across this?, any help appreciated
Regards,
jlo
|
|
|
Sim
|
Posted: 08/05/2003, 3:37 PM |
|
I have the same error....
Does anyone have a clue ???
|
|
|
Dylan Shea
|
Posted: 10/23/2003, 12:46 PM |
|
In CCS 2.2.2.40, you should be able to create a search box, which allows you to use one textbox which takes a keyword but takes that value and attempts it against multiple fields in your SQL table by creating a select statement with an OR.
For example, you could have a search textbox which allowed you to enter a number (a User ID) or a name (a User Name), and the search would bring up grid contents which match.
However, by default CCS does not make the settings correct in the Search Builder, and you get the error message: The value in field urls_keyword is not valid
The fix I found, was to go to the Grid data source property, and change the Data Source type from Table to SQL, and that fixed my search.
|
|
|
Alice
|
Posted: 10/23/2003, 1:48 PM |
|
Dylan,
What a good response.
Identify problem, explain process, provide fix.
Bet you write good code too...
Cheers,
Alice T.
|
|
|
|