Nat didn't you utilize frames for something like this? That way the whole
page doesn't have to be reposted to change the second query. There must be a
nice clean js way to run this. What about dates? When you pick a month from
the first select box, then day from the next. There must be a way to tell
the second box to only have 1-28 if "Feb" was picked in the first. Anyone
crossed that bridge?
Greg
----- Original Message -----
From: "Nat Papovich" <[EMAIL PROTECTED]>
To: "Fusebox" <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 2:21 PM
Subject: RE: Dynamic select box...
> This custom tag that everyone loves does not work if you want the selects
to
> be powered from different queries. It will only data from the same query.
>
> Jeff Peter's post below looks great, as does Erik's example with wddx,
which
> I did not have the luxury of using when I wrote that presentation.
>
> NAT
>
> > -----Original Message-----
> > From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, February 15, 2001 9:21 AM
> > To: Fusebox
> > Subject: Re: Dynamic select box...
> >
> >
> > Sounds like you're looking for something like this.
> >
> > http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywo
> > rds=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
