Drill-Down Query on one page

[slamb0513]

I want to build a drill-down query on one page and then submit the form to
another page once the drill-down is complete. Here are the specifics.

I have a form that askes users how many vehicles they have in their household.
Based on this answer, they would then select the Year, Make, Model and Option
for those vehicles. Currently, When they select the year, the form submits to
a second page that queries the database for makes made in that year. Theyn
they select the make and the form submits to a third page that queries the
database again for models made in that selected year and make.....and so on.

I would like to be able to have the user select the year, make, model and
option on one page and then have the form submit to its processing page once
that is all done.

Can anyone explain how this might be done without using any complex
Javascripting?

[Iceborer]

I guess it depends on what you mean by "complex javascript." I have used this
method in the past.


[url]http://depressedpress.com/DepressedPress/Content/Development/JavaScript/Articles[/url]
/GIFAsPipe/Index.cfm

[dempster]

The primary way to make a page interactive without going back to the server is
through JavaScript. The server can pass information into JavaScript arrays, and
then your page can update form elements such as select boxes using event
handlers such as onchange.

Before you pursue this, you might want to ask if the functionality of your
form would be greatly improved by this strategy. JavaScript programming can be
complex and you may get bogged down with making it work. A clear, well-designed
multi-part form might be the best way to go unless you have server performance
problems. Perhaps you can combine some of the information so that year and
make, for example, are on the same page as are model and option.

Just a thought.

-Paul

[roblaw]

Slamb,

Search the coldfusion developers exchange for 'Parent Child Select'.

roblaw

[Unregistered]

Use cfbind and CFC's

I have done the numerous times and it works great