The normal method of converting Coldfusion query column to array is to use a valuelist and list to array:
the_array=listtoarray("#valueList(the_query.the_column)#")
But this strips out any cells with empty strings in. To get around this use:
the_array=duplicate(the_query[column_name]);
ArrayPrepend(the_array,the_query[column_name][1]);
why the ArrayPrepend() call afterwards? Because CF arrays start at 1 and Java (the underlying language) starts at 0, so the duplicate function misses off the first row of the column.
nice.
