First off, a note of caution - if you're storing multiple values in one
field in your database, your database is not normalized. You could end up
with some real headaches down the road.
But, as for your question. I would avoid using the cfselect in this
situation and just use a regular select box. Then, I'd do something like so:
<cfset myselectedlist = myquery.mycolumn>
<select name="myselect" size="1">
<option value="myvalue" <cfif listfind(myselectedlist, myvalue) GT
"0">selected> My Value </option>
</select>
Make sense?
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
