1. Create a list of current categories assigned to the locale
2. query all the categories
3. output the query, and select the category if its in the list
<cfoutput query="GetCategories">
<cfif CurrentCategories contains GetCategories.Category_ID>
<option value="#Category_ID#" selected>#Category_Description</option>
<cfelse>
<option value="#Category_ID#">#Category_Description#</option>
</cfif>
</cfoutput>
HTH
Matt
-----Original Message-----
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 05, 2000 8:44 AM
To: Cf-Talk (E-mail)
Subject: DB normalization rules and multi-select
Hello there,
I have been wrestling with this problem with no success... I have two tables
one contains the category types (category_id and description) and another
all the categories assigned to a locale (locale_id and category_id)... on
one of the forms I list all the categories for the user to select, it is
been saved correctly (even when user selects multiple entries) the problem
is when I try to redisplay the categories with the already assigned
categories pre-selected, it is only selecting the first one, any ideas...
Bismarck Perez
*1-617-563-2896
* G10H
* [EMAIL PROTECTED]
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
