Are we to assume correct that this query returns multiple rows in query analyzer?
----- Original Message ----- From: "Seamus Campbell" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Friday, October 06, 2006 2:36 AM Subject: multiple selects problem > Hi > > I've got a field called category - which can have multiple > parent_categories. > I want to display all the parent_categories a category has in a > drop down box in a form. > I can only get it to show ONE parent_category. > Below is my current code - can anyone give a clue as to how to show > multiple parent_categories, please > +++++++++++++++++++++++++++++++++++++++++++++++ > <CFQUERY NAME="get_parent_categories" > DATASOURCE="#request.DSN_main#"> > SELECT tbl_parent_category.parent_category_id, > tbl_parent_category.parent_category > FROM tbl_parent_category; > </CFQUERY> > <cfset form_size = get_parent_categories.RECORDCOUNT> > <CFQUERY NAME="get_this_parent_categories" > DATASOURCE="#request.DSN_main#"> > SELECT tbl_parent_category.parent_category_id, > tbl_parent_category.parent_category, > tbl_category_parent_category.category_id > FROM tbl_parent_category INNER JOIN tbl_category_parent_category ON > tbl_parent_category.parent_category_id = > tbl_category_parent_category.parent_category_id > WHERE category_id = #URL.category_id#; > </CFQUERY> > > <form action="edit_category_display_names.cfm" method="post"> > <input type="hidden" name="category_id" > value="<cfoutput>#URL.category_id#</cfoutput>"> > <input type="hidden" name="stage" value="write"> > <select name="parent_category_id" > size="<cfoutput>#form_size#</cfoutput>" multiple> > <cfoutput query="get_parent_categories"> > <option value="#parent_category_id#"<CFIF > get_parent_categories.parent_category_id IS > get_this_parent_categories.parent_category_id>SELECTED</CFIF>>#get > parent_categories.parent_category#</option> > </cfoutput> > </select> > <input type="submit" name="submit2" value="change"> > </form> > +++++++++++++++++++++++++++++++++++++++++++++++ > > > Seamus Campbell Boldacious WebDesign > http://www.boldacious.com ~~~~ [EMAIL PROTECTED] > ph 0410 609 267 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
