Use the CF_twoselectsrelated tag.
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347197-2830-11D4-AA
9700508B94F380&method=Full
-----Original Message-----
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 27, 2000 9:42 PM
To: CF-Talk
Subject: Populating SELECT from other SELECTs?
I am working on car model database and when creating a drop-down <select>
for models, I would like to <cfoutput> a query depending on a selection in
another select box:
First box:
<cfoutput query="make">
<select name="make">
<option value="#makeID#">#makeName#</option>
</select>
</cfoutput>
If, say, "Acura" is selected in the first box, I want the secon box only
display Acura models:
Second Box:
<cfoutput query="acura">
<select name="model">
<optioin value="#modelID#">#modelName#</option>
</select>
</cfoutput>
Is there a way to do that without reloading the page?
On a side note, (as a potential solution) is it possible to make CFTREE to
allow multiple selections?
Cyrill
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists