Using CFselect with a string?? Help 1

[mattwright]

Hi - I have been looking for the answer to this for days! Please help. I have a field in an access Db that has a comma delimited list in it. (ex. Blue, Green, Yellow)

I want to be able to write my cfselect statement so that the dropdown box seperates these values and lets me pass just one.

I am I way off base (can I do this at all).

Thanks Matt

 

[xor]

Hi Matt,
I haven't been able to test it, but this should do the trick...

<cfset theList=QueryName.fieldName>
<form>
<select name=&quot;theList&quot;>
<CFLOOP INDEX=&quot;listElement&quot;
LIST=&quot;theList&quot;
DELIMITERS=&quot;,&quot;>
<option>#listElement#
</CFLOOP>
</select>
</form>

 

[xor]

OK Matt, I've gotten a chance to test it. Only a couple of changes (notice the ## marks), but this should do it:
Of course you do your query before this bit of code. And change the QueryName.FieldName to whatever it is.

<CFSET list = ValueList(QueryName.FieldName)>

<form>
<select name=&quot;theList&quot; size=&quot;1&quot;>
<CFLOOP INDEX=&quot;listElement&quot;
LIST=&quot;#list#&quot;
DELIMITERS=&quot;,&quot;>
<option><cfoutput>#listElement#</cfoutput>
</CFLOOP>
</select>
</form>