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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
