Dynamic Drop-down inside CFGRID

[mikeap]

I've been searching for days and days trying to find an example. What I'm
looking to do is use a CFGRID to edit some basic values.

In the CFGRID though, for one of the editable items, I need to have a dynamic
drop-down. Is that possible and how?

[GeorgeWS]

Yes you can do this. But only with the appelet version NO flash.

[mikeap]

I know with the APPLET I can then use the VALUE attributes but I could not
figure out how to dynamically load the values. It would show one but not
repeat. Do I need to put the repeat code in the value tag?

[GeorgeWS]

I use the cfgridcolumn Values="#ValueList(DBNAME.FIELD1)#" I was stumped on the
ValueList part for a long time. Oh yeah I also did this...

<cfset Space = "None,">
then did this...

cfgridcolumn Values="#space##ValueList(DBNAME.FIELD1)#"

this made a selection of none.

hope this helps

[mikeap]

Now another problem ... hmm ... because I have commas in my field, it treats
that as a delimiter and it's not. So I have company names with ", .Inc" so I
have ".Inc" as items.

When I put a delimiter on the tag, it then doesn't put each item on it's own
line.

Any ideas?

[mikeap]

I tried using a REPLACE and that didn't work ..

[GeorgeWS]

Maybe try the ListChangeDelims thing., I use it in a program where I turn ,'
into '', and it works great (maybe change the comma to a space). go to the
livedocs.macromedia.com for expanation. I think you should just limit the
selection to stuff the does not have a comma; (very bad in data). I do
experience this though and chalk it up as inproper data input. I have been
building so thats not going. No commas in the data entry part.