I have a list box populated with values from a ColdFusion query, and following
each real value in the listbox, there are unselectable "null" values, or
labels, displayed on the remaining visible rows in the listbox.
For example, the listbox has 6 rows and when the first 2 are populated with
real data, employee names, the remaining 4 rows display "null" as their label
value. However, you cannot select the rows with null in them. They are like
dummy rows.
This used to work fine with Flash 6, so I believe it's when I upgraded to
Flash 7. I'm running 7.2 to be exact.
Here is the function I use to populate the listbox found in the "_Results"
function of my ColdFusion query:
DataGlue.bindFormatStrings(searchResults_lb, records, "#name#",
"#employee_ID#");
Any help to get rid of those null values, with the current design, would be
greatly appreciated.
conquerors04 - 17 Aug 2005 22:17 GMT
If you areusing a DataSet you can use the filter option to return all which is
not null, only displaying the rows that have data. If you are not using a
dataset, then run a for loop with an if statement inside of it to monitor those
fields that are empty and not to use them. Does that answer your question?
jcard10 - 19 Aug 2005 16:27 GMT
Thanks for the response conquerors04. Unfortunately, I'm not using a DataSet,
I'm using a RecordSet. I was planning on determining how many rows of data
there are and then only making the visible portion of the ListBox that size, if
there wasn't some trick to get rid of the null values. I guess I can go that
route.
Is there a row property I can dynamically modify with a Flash Component
ListBox, or would I have to modify the height in pixels?