Select box determines query...

[Seth Buntin]

I have two select boxes and i want the information from what is selected in those boxes to query the database and fill a third select box (all on the same page) Is this possible?

[blewis]

Yes, it's possible, but not without refreshing the page, unless you use
something like Flash remoting. If you need to gather information before
running the query, then you need to send that info back to the server to
generate the list for the third select box.

Here is an example of a simple set of select lists that each depend on a
selection. Each time you select something, there is an onChange handler that
submits the form and refreshes the page.

[url]http://www.eddataonline.com/fitness/2004/data/data_selection.cfm[/url]

Bryan

P.S. -- If the datasets are very small, it is possible to preload everything
in javascript arrays and then access it without refreshing the page -- but this
can get ugly, and is terrible for larger sets of data.