Ashiff
|
| Posted: 07/04/2003, 12:18 AM |
|
Hi,
The multiselect option in listbox is one really useful tool. I built a page using grid builder and added a search option with 4 listboxes which I later converted into multiselect listbox.
Now the problem is whenever I search for first time I get results OK. If i do the second time the first time query too is merged resulting in error as first query was select all where there was no definite value and second query had a definite value. The error given was like the value of the variable is not valid (,1). Now I even removed preserve HTTP requests and still I get it. I use PHP and MySQL. PLease help me in this regard
|
|
|
 |
rrodgers
|
| Posted: 07/04/2003, 7:53 PM |
|
You don't say what tool you are using CC or CCS?
With CCS2+ Yes provided quite a few examples in something called the Example Pack one of those was the multiselect search.
Look for.
Working with Multiple Selections
<snip>
Search Form with Multi-select ListBox
rob
|
|
|
|
Ashiff
|
| Posted: 07/05/2003, 9:42 AM |
|
I use CCS 2.1 and multiselect works fine with text column as sql comparator is "like" operation but fails in numeric operation because select all has no value associated and say USA might have one associated in the multi select box so when sql select is performed it gives an error.
Can you also tell me how I can get Multi select Listbox checked type like the one in VB
|
|
|
|
|
