Checkbox to update dropdown list with coldfusion query
Posted on 2004-10-14
What I'd like to do is add to/subtract from a dropdown list with a coldfusion query using checkboxes.
e.g - say I have 4 checkboxes whose values are car makes - ford, audi, bmw, vw. when none of them are checked the dropdown says the usual 'select' and nothing else, but when say VW is checked it queries my database (Access) gets the models associated with VW - Golf, Beetle etc etc and adds them to my dropdown list and when the checkbox is unchecked it removes them.
When more than one checkboxes are checked it just adds them and gives them a heading in the dropdown list as follows: (Audi and VW have been checked)
Any help would be much appreciated,