You could try the <CF_TwoSelectsRelated> tag. you can find it on allaires
site.
Doug
----- Original Message -----
From: "PHP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, December 09, 2001 10:10 PM
Subject: Populating Options based on Option selected
> Hello,
>
> I am trying to dynamically populate the data from a table that is selected
as part of an option in a cfselect statement.
>
> So far I have:
>
> <cfquery name="view" datasource="technical">
> select id, name from category
> order by name;
> </cfquery>
>
> <cfform action="TechnicalConnection.cfm" name="category">
> <cfselect name="category" query="view" value="id" display="name">
> </cfselect>
> <input type="Submit">
> </cfform>
>
> <cfif isdefined("form.submit")>
> <cfset cid=form.category>
> <cfoutput>#cid#</cfoutput>
> </cfif>
>
>
> but this doesn't pass the id for the name selected in the option box
along, ideally it would populate without having to submit
> a form, but rather when the option is selected. Example being if a user
was going to add a value to a database and wanted to add it to a certain
table and field. First he would select the table name from the first option
and then the fields would automatically populate in a second option.
>
> Any Ideas?
>
> thanks
>
> Dan
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
