How to populate drop down list from one field withdelimiters

[Anj01]

Hello

How can we populate a drop down dynamically from the database by splitting one
row of data .
I have data in a field which is seperated by delimiters
example Shirt, TShirt, Pants as one field data in the DB
I need to display them individually in a drop down list
How can this be done

Thanks

[TA-Selene]

You just loop over the list to create the options:

<select name="MyField">
<cfloop list="#DataField#" index="ItemField">
<cfoutput><option value="#ItemField#">#ItemField#</option></cfoutput>
</cfloop>
<select>

[Anj01]

thanks

but the datafield has data in 1 cell itself seperated by ,
how do i populate that into the drop down. The method you have specified will
put the data in drop down list if it in different rows

thanks

[TA-Selene]

Not really. If you replace DataField with the name of your column, this code will loop over the contents (which is really a list) and create an option for each element of that list.

[Anj01]

Thanks a lot Selene it works gr8