twodave
Posts: 5
|
| Posted: 11/16/2006, 7:14 AM |
|
Hi, I'm using CCS 3.1.0.2 and php/mysql for a project. I am coming across a problem in logistics where the possible options (people) for a certain selection by the user could be much too numerous for the user to sift through. It's not fun having to go through 1000+ items in one listbox. So, I had the idea of trying to link up a search builder to the listbox to filter it. Much to my chagrin, I couldn't find a way to do this or any mention of it here.
Does anyone have an idea of how I might accomplish this? Or maybe an idea of a better way to do this?
I'm basically using an editable grid to assign members to a group. The group's id is in the query string, so the other field for the table (the person's id) is the listbox's purpose. Since anyone in the database could be a member of the group, the user needs to be able to pick anyone he/she wants to add, but I don't want the user to be overwhelmed. So, I'm trying to find a user-friendly way to present everything, but allow the user to set limits to "everything"
I suppose if there isn't a good "codecharge" way to do this I'll just put an ajax text search into the page.
_________________
-Dave |
 |
 |
Rene S
|
| Posted: 11/16/2006, 7:18 AM |
|
Hi,
You maybe could use the example pack:
http://examples.codecharge.com/ExamplePack/PopUpList/PopUpList.php
Not sure...
Rene
|
|
|
|
twodave
Posts: 5
|
| Posted: 11/16/2006, 7:25 AM |
|
hmm this looks promising! i apologize for not looking there first.
_________________
-Dave |
|
|
|
wkempees
Posts: 1679
|
| Posted: 11/16/2006, 10:15 AM |
|
Also this post might be useful
http://forums.codecharge.com/posts.php?post_id=69070&s_keyword=typeahead
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 11/24/2006, 9:33 PM |
|
YOu need to changeyour design.
Instead of a listbox, use a popup window to select the item, using a fully
searchable grid to which you can add as many search capabilities as you
want.
|
|
|
|
wkempees
|
| Posted: 11/27/2006, 10:54 AM |
|
Nice thought.
Walter
|
|
|
|
marcwolf
Posts: 361
|
| Posted: 11/27/2006, 5:07 PM |
|
Hi there.
I had exactly the same issue and found this link that works VERY well
http://www.gadgetopia.com/autosuggest/
Now - we have modified it further so that it uses httpXML to go back to the server and populate the array so that the initial array does not need to be loaded into Javascript.
In addition - we also modified this to work as a listbox so that a hidden field will contain the retruned code whilst displaying the main details.
Drop me a line atMarcwolf@marcwolf.org and I see if I can get some samples to you.
Take Care
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 01/15/2007, 5:08 PM |
|
Hi dave,
Let me jump in with my own opinion here.
If there is the remote possibility that the options in your listbox will be
anbywhere near the number you are referring to, then you are using the wrong
control.
Instead, have a popup from which you can retrieve the value. this would be
a regular grid, and you can add full seacrh capabilities.
I have one application which was using a listbox. It turns out that one
customer has about 5,000 items in the related table on which I was using the
listbox.
He did not mentio this while we were trying to figure out why his deployment
was hanging - turns out that the time it took to retrieve the data and
render the apge on his system was more than the execution timeout for the
page. I finally turned on SQL profiler and saw what was going on. It was a
minor change, but one which had huge performance impact on the application -
and being fulloy searchable on any field of the related table was an extra
bonus.
|
|
|
|
marcwolf
Posts: 361
|
| Posted: 01/16/2007, 6:25 PM |
|
Hi Ben
Yes - in some instances a grid would work well but in this case there were 4 'dropdowns' that were required, and putting grids on the pages (being serach screens) would have been very difficult.
When my app is running you care just presented with a text box and as you type you get the dropdown showing 10 items that match what you have types. Much more visually simple and intuative.
If you have used Google Suggest then that is what it looks like.
For example 4 dropdowns for cars
MAKE
MODEL
YEAR
OPTIONS
When the Make has been selected it is easy to then pass the make as part of trhe selection thus you will see only the models for that make. And so on.
The submit for the search is ONLY needed when all the dropdowns have been used.
The above can also give someone a very good grounding into AJAX and live server interaction.
Take Care
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
|
