Skip to main content
Y
yoman-B9oqA1
Inspiring
February 12, 2008
Question

CFSELECT with 1000 options?? Ajax??

  • February 12, 2008
  • 2 replies
  • 467 views
Can anyone tell me how to handle this situation? I want to include information about the bands in a music calendar w/o having to re-enter the band websites or descriptions for each entry. So the bands have their own table. The idea for data entry is to 1) select a location 2) list dates for a month 3) have a cfselect box with bandname associated with each date and 4) on submit loop through and insert into database.

Unfortunately, there are like hundreds and hundreds of bands. So putting 30 cfselect tags with 1000 options each on a page seems ridiculous. I've thought of doing a lookup based on the band name instead of the ID. If the name was typed incorrectly, no data, but it would work most of the time.

What about Ajax? I know zip about Ajax, but isn't that what is it for? Could it be done w/o spending six months learning Ajax?
This topic has been closed for replies.

2 replies

S
Steve Sommers
Legend
February 13, 2008
I would rethink how you're presenting the information to the user, much like what Adam said. Research similar sites. Having a select box, or multiple boxes with thousands of options each would be very cumbersome and virtually useless to the average web surfer.
D
Dan_Bracuk
Inspiring
February 12, 2008
use a series of checkboxes for the dates. that will get you started.
Y
yoman-B9oqA1Author
Inspiring
February 12, 2008
I probably didn't make myself clear. The problem isn't the date. The problem is that every date would include a cfselect box with 1000 options, one for each band. The code would look like below.



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