>- see footer for list info -< I haven't used that one, I tend to use the ones from Matt Kruse
http://www.mattkruse.com/javascript/dynamicoptionlist/source.html Allan --- On Thu, 30/10/08, Kylie Lindstrom <[EMAIL PROTECTED]> wrote: From: Kylie Lindstrom <[EMAIL PROTECTED]> Subject: [CF-Dev] chained selects in a form... To: [email protected] Date: Thursday, 30 October, 2008, 3:02 AM >- see footer for list info -< Hi All, Attempting to use the Ryan M BeMiller example to chain two selects in a form and not having much luck... Here is my code... <cfoutput> <!--- the action goes to a page which just appends the appropriate fields in the db ---> <form action="grDocsPagesAdd_Act.cfm" method="post" enctype="multipart/form-data"> <input type="hidden" name="subHeading_required" value="Reference Heading is required!"> <input type="hidden" name="headingID_required" value="Reference Category is required!"> <table width="100%" border="0" cellpadding="4" cellspacing="1" class="back_drkr"> <tr> <td colspan="2" class="tbl_rowhdrs1">Add a new document</td> </tr> <tr> <td class="tbl_rowhdrs2">Document Heading</td> <td class="tbl_main"><input name="docName" type="text" id="docName" value=""> </td> </tr> <!--- querying the headings table which contains headingID, headingName ---> <cfquery name="qGetHeadings" datasource="groupRiskDocuments"> SELECT * FROM headings ORDER BY headingID </cfquery> <tr> <td class="tbl_rowhdrs2">Document Topic</td> <td class="tbl_main"> <!--- dynamically populate the first drop down list based on the qGetHeadings query ---> <!--- I keep getting an error which has something to do with the cfif below... Invalid CFML construct ---> <select name="headingID" required="yes" onchange="this.form.submit()"> <option value="">-- Document Topics --</option> <cfloop query="qGetHeadings"> <option value="#qGetHeadings.headingID#" <cfif isDefined('form.headingID'><cfif form.headingID eq "#headingID#">selected</cfif></cfif>>#qGetHeadings.headingName#</option> </cfloop> </select> <!--- store the selected headingID after the select submits itself ---> <cfif isDefined('form.headingID')> <cfset page.headingID = form.headingID> </cfif> </td> </tr> <!--- if the first selection has been made, display the second drop down list with appropriate subheadings ---> <cfif isDefined('page.headingID')> <!--- querying the subheadings table which contains subheadingID, subheadingName, headingID, based on selected headingID from first query ---> <cfquery name="qGetSubHeadings" datasource="groupRiskDocuments"> SELECT * FROM subheadings WHERE subheadings.headingID = #page.headingID# ORDER BY subheadingID </cfquery> <tr> <td class="tbl_rowhdrs2">Document Sub-topic</td> <td class="tbl_main"> <!--- dynamically populate the second drop down list based on the qGetSubHeadings query ---> <select name="subheadingID" required="yes"> <option value="">-- Document Sub-topics --</option> <cfloop query="qGetSubHeadings"> <option value="#qGetSubHeadings.headingID#">#qGetSubHeadings.subheadingName#</op tion> </cfloop> </select> </td> </tr> </cfif> <!--- these are other fields that need to be updated, not involved with the chained selects ---> <tr> <td class="tbl_rowhdrs2">Date <i><span class="riskdoctext">(dd/mm/yyyy)</span></i></td> <td class="tbl_main"><input name="StoryUpdateDate" type="text" id="StoryUpdateDate" value="<cfoutput>#DefaultDate#</cfoutput>"></td> </tr> <tr> <td colspan="2" class="tbl_rowhdrs2">Story Text</td> </tr> <tr> <td colspan="2" class="tbl_main"> <div id="docText"> <textarea name="docText" cols="300" rows="30" id="docText" style="width:500px; height:200px;"></textarea> </div></td> </tr> <tr> <td class="tbl_rowhdrs2">Reference Document</td> <td class="tbl_main"><input type="file" name="docFileName" class="flat"> </td> </tr> <tr> <td colspan="2" class="tbl_rowhdrs2"> <input name="Submit" type="submit" class="buttons" value="Add new doc"> <input name="reset" class="buttons" type="reset" value="Clear Form" /></td> </tr> </table> </form> </cfoutput> _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
