All,
I'm trying to populate a (categories) select form with element in edit mode. I'm
trying to loop through the entire list of categories while highlighting
(selected) the
categories associated within this recordset. I'm having a hard time getting
multiple selections to siaply properly in edit mode. Each category_id is comma
delimted.
SAMPLE:
<!-- FORM.pre_existing is coming from unique item submitted into edit mode -->
<cfquery name="Edit_Get_Selected_PressRel" datasource="#datasource#"
cachedWithin = "#CreateTimeSpan(0, 0, 5, 0)#">
SELECT *
FROM press_rel
WHERE press_re_id = #FORM.pre_existing#
</cfquery>
<!-- GET CATEGORIES -->
<cfquery name="GetCategoriesOutput" datasource="#Datasource#">
SELECT * FROM categories
</cfquery>
<!-- SPIT OUT CATEGORIES AND SHOW CATEGORIES IN THE DB.COLUMN AS SELECTED BY
LOOPING -->
<!-- PRSubmit_EDIT IS HIDDEN FORM WHEN IN EDIT MODE -->
<select name="pre_cat_id" size="3" multiple id="cat_id">
<CFOUTPUT query="GetCategoriesOutput">
<option value="#categorie_id#" <CFIF ISDEFINED ("PRSubmit_EDIT")><cfloop index
= "ListElement" list = "#Edit_Get_Selected_PressRel.pre_cat_id#"><CFIF
ListElement IS
GetCategoriesOutput.categorie_id>selected</CFIF></cfloop></CFIF>>#cat_name#</option>
</CFOUTPUT>
</select>
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236656
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
