Sounds like you're looking for something like this.
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=CF_Two
SelectsRelated
- Michael -
----- Original Message -----
From: "David Burt" <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 9:05 AM
Subject: RE: Dynamic select box...
> Let's see if I can explain this better.
>
> Lets say you have two select boxes. 1 for the make of a car and another
for
> a model. These two being related, when a use changes the value of the
> select box for the make, the values of the select box for the car are
> populated with all models of the make that has been selected.
>
> sorry for not being specific enough.
>
> thanks...
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 15, 2001 11:33 AM
> To: Fusebox
> Subject: RE: Dynamic select box...
>
>
> I'm just going to put code in here...
>
> <cfquery name="myQuery" datasource="x">
> SELECT
> ID,NAME
> FROM
> PEOPLE_TB
> </cfquery>
>
> <cfselect name="[form field name]" query="myQuery" display="NAME [whatever
> you want the user to see]" value="ID [whatever value you want passed to
the
> action page]" selected="3 [if you want something selected, specify the
VALUE
> here]">
>
> Shan
>
> Shannon Hicks
> Senior Developer
> Allaire Certified ColdFusion Developer
> Brainbench Certified ColdFusion Developer
> [EMAIL PROTECTED]
>
> duoDesign, The eBusiness Accelerator
> 1007 Church St. Suite 510
> Evanston, IL 60201
> 847.491.3211
> 847.491.3100 fax
> http://www.duodesign.com/
> http://www.chicagoangels.org/
>
> duoDesign is a Web development firm that partners with start-ups to launch
> and maintain e-commerce enabled sites. Because we understand start-ups,
> we'll work for cash, equity or both. duoDesign blends creative and
technical
> expertise with extensive additional resources including an impressive
> advisory board, top-quality service providers and an affiliation with
> Northwestern University. If you work with start-ups that could benefit
from
> our services and experience, feel free to contact us at 847-491-3000 or
> visit us at http://www.duodesign.com
>
>
> -----Original Message-----
> From: David Burt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 15, 2001 10:03 AM
> To: Fusebox
> Subject: Dynamic select box...
>
>
>
> Does anyone have any sample code for making database driven dynamic select
> boxes? I have tried following the three powerpoint slides that were in
> Nat's presentation, but I just can't seem to get it.
>
> thanks...
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
