and just because if i don't say it, somebody else will...
it's generally not a good idea to store lists (delimited data) in
relational databases. you've got a one-to-many relationship and would
probably run into fewer issues in the future if you were to break it
out as such.
On 10/20/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
> why not just:
>
> <cfloop list="#option1#" index="i">
> <option value="#i#">#i#</option>
> </cfloop>
>
> On 10/20/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > I've got a database field called option1 that contains two colors seperated
> > by a comma: "red,yellow".
> >
> > What I'm trying to do is create a drop down form box that takes each color
> > (delineated by the comma) and puts it into it's own
> > option value like this:
> >
> > <select name="option1">
> > <optionvalue="red"> red </option>
> > <optionvalue="yellow"> yellow </option>
> > </select>
> >
> > My first attempts have been with the replace function:
> >
> > <cfset color="#Replace("#option1#", ",", "</option>","ALL")#">
> > <selectname="option1"class="formbox">
> > <optionvalue="#option1#">#size#
> > </select>
> >
> > However, it appears to be more complicated than that, that getting em only
> > part of the option value line.
> >
> > Any suggestions or alternatives I'm not seeing here would be most
> > appreciated.
> >
> > -jeff
> >
> >
> >
> >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:257614
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
