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

Reply via email to