LucaYanez
Posts: 5
|
| Posted: 09/25/2010, 1:11 AM |
|
Hello,
I am using CCS 3xx and PHP.
I have been searching the forums, but I am a newbie and I couldn´t implement the solution.
I have a listbox to select towns that show up in a grid below it.
When I open the page, with the list box in "select value" the grid is populated with all the records found in the db table.
I would like to, when opening the page, to have the listbox visible but the grid unvisible or at least not populated.
When I select an item from the listbox, I would like to have it populated with the matches and of course visible.
I cannot figure out, I have been trying "before show" actions (hide-show component) and code...no luck...
Any hint would be very appreciated...
Thanks
|
 |
 |
datadoit
|
| Posted: 09/25/2010, 7:34 AM |
|
> I am using CCS 3xx ... but I am a newbie
Upgrade. Many new features and stability enhancements. Don't be a new
dog learning old worn out tricks. :)
1. Make sure your listbox is encased in a search form.
2. Permanently hide the search form's Search button. Visible = false.
3. For the listbox, on the client's OnChange event, submit the form.
4. For the results grid, if there is no listbox search parameter, hide it.
All of the above can be done without a single line of custom coding, but
you need version 4+.
|
|
|
|
LucaYanez
Posts: 5
|
| Posted: 09/25/2010, 9:10 AM |
|
Hello,
thanks for your help!
Actually I have CCS 3.xx at home and 4.xx at work...
I was doing some "weekend at home" research...
but actually I will have to do it (if possible, given my limitations)
next monday at the office...
¿How would it be with CCS 4.xx, then?
Thanks
|
|
|
|
MichaelMcDonald
Posts: 640
|
| Posted: 09/25/2010, 8:44 PM |
|
In the visual query builder, If you have a WHERE clause based on a field in your table which has the ability to filter a result in the grid, set that WHERE fields default to 0.
This will hide the grid results until that field is given a value to perform the where argument against, say by entering something in a search field, which could be a value from a list box.
_________________
Central Coast, NSW, Australia.
|
|
|
|
LucaYanez
Posts: 5
|
| Posted: 09/27/2010, 4:27 AM |
|
Hello, and thanks to everyone.
Well, I have tried at work with what Michael told me with no luck...
I have an ABCsearch (listbox) from table1 where xxx=xxx (xxx is a table field name)
Then I have a ABCgrid from table1 and table2 (they share the xxx field) where table1.xxx LIKE %{s_xxx}%
It works ok, but I cannot make disappear the grid table when starting the page (so no value is selected).
I have been messing around with no luck....
Right now I am using CCS version 4.3.00.7676 (fully activated).
Thanks again for your help!
|
|
|
|
datadoit
|
| Posted: 09/27/2010, 6:37 AM |
|
I let you to the water. Are you not going to drink it? :)
|
|
|
|
LucaYanez
Posts: 5
|
| Posted: 09/27/2010, 6:50 AM |
|
Hello,
I managed to do domething 
I set (within the grid), table parameter, "Use default value if parameter is empty" to "Retrieve no records" and now the grid is not populated when the listbox is in "select value" "mode".
Ok, now....how do I hide the whole grid (not just showing records found= 0).
Thanks!!
|
|
|
|
|
