Skip to main content
CJ83_2
CJ83_2
Known Participant
August 20, 2008
Answered

Multiple Dropdown Issue

  • August 20, 2008
  • 3 replies
  • 890 views
What I have is a form that has a dropdown with a list of letters, the alphabet, and what I want to do is when the user selects a letter, I want the a query to be run to populate the second dropdown with the list of everyone last name that starts with the letter that the user just selected With Out re-loading the page or javascript. The name table has over 10,000 rows so you can see why I do not want them in the dropdown to start with and why a javascript array will not work for this aplication. Any Ideas?
This topic has been closed for replies.
Correct answer Newsgroup_User
autosuggest. cf8 has that functionality, too.
if you are not on cf8, look into using Rob Gonda's AjaxCFC.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

3 replies

CJ83_2
CJ83_2Author
Known Participant
August 22, 2008
Thanks for the Autosuggest Idea. It works great for what I want to do. Thanks again. I also got the update from one dropdown to another working as well, but I like the autosuggest better.
D
Dan_Bracuk
Inspiring
August 20, 2008
Even if you can get it to work, you are still going to have problems in that your user is presented with a drop down of several hundred choices once they choose a letter. You may want to consider another approach.
CJ83_2
CJ83_2Author
Known Participant
August 20, 2008
Good Point. I can not think of any other better way to really do it. Maybe I am having a brain fade today. Maybe if I have them type in the first 2 or 3 letters in a text field, then to do a search that way. Not sure.
N
Newsgroup_User
Inspiring
August 20, 2008
If your requirements do not allow you to load all the data on the first
request, then your choice is to do this in multiple steps with a new
request-response cycle after the user selects the letter.

If you want to make this nicer you can hide that request-response behind
the scenes by using AJAX techniques.

This type of task is very common and well discussed with many examples
readily available through a bit of searching.
CJ83_2
CJ83_2Author
Known Participant
August 20, 2008
Well, I have done quite abit of searching and have not found anything useful. Do you have any links you could share?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices