My apologies if this has already been posted. I'm at my wits end and can't find
anything in the forums to solve my problem.
I've created a cfform which has multiple modes (add, edit, view). In this form
is a cfselect box where users can enter multiple communities which their
project spans. In the edit mode, this box should still show the whole list,
and it should highlight (pre-select) all communities currently in the database
for that project. I've got the code working so that the first community from
the table is selected, but not the rest. I've tried looping and a few other
things but I'm stuck and my deadline is fast approaching... any advice would be
appreciated. Thanks in advance!
Here's the relevant code...
<cfquery name="qdMcd">
SELECT mcd, tip_id
FROM tip_mcd
WHERE tip_id = #tip#
</cfquery>
<cfquery name="mcds">
SELECT semmcd, mcd_name, county, 'Counties' AS cnty_name
FROM lu_semmcd
WHERE semmcd IN (1998, 1999, 2999, 3999, 4999, 5999, 6999, 7999)
UNION
SELECT semmcd, mcd_name, county, 'Communities' AS cnty_name
FROM lu_semmcd
WHERE semmcd NOT IN (1998, 2073, 2172, 2252, 6142) AND semmcd < 8025 AND
semmcd NOT LIKE '%999'
ORDER BY cnty_name DESC, mcd_name
</cfquery>
<cfselect name="mcd" id="mcd" size="3" query="mcds" group="cnty_name"
display="mcd_name" value="semmcd" selected="#qdMcd.mcd#" queryPosition="below"
required="yes" multiple="yes" message="You must select at least one location."
onChange="" style="width:230px;">
<option value="8999" >Southeast Michigan</option>
</cfselect>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4042
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
