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:255759
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
