CF exports to Excel and filters

Just ran across this in Ray ‘Jedi’ Camdens code for Lighthouse, something I never saw before. We use the typical HTML table export to Excel. In Ray’s export I discovered the ability to add a filter header to the export. This allows the user to quickly filter based on the data in the column. To add this, in your header row simply add the attribute filter=”all” to the td tag and bamm! So it looks like this:

<td filter="all">My Header Title </td>

DK


CF/JRun server-out and server-err logs

I don’t know how I missed this one, but Adobe released a patch to finally address the issues surrounding the server-err and server-out logs. The issue being that these two logs were not covered by the JRun logging settings in jrun.xml.
http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=8698aeb8
no more 10+GB log files when you are not looking! Hopefully this is addressed in the more standard way via jrun.xml in Scorpio.

DK


ColdFusion and Flex, composite CFCs, and Arrays

I have ran across this issue before and seem to have finally come across a solution. The issue: say I have a CFC called Person which has a property addressArray that is a array of Address CFCs. In my Flex app the associated Person.as object should have
addressArray:ArrayCollection();
But this does not work.
addressArray:Array();
Will work though, but now I loose all that fancy schtuff in ArrayCollections, eh? So, in short the array does not translate into a ArrayCollection, but just a Array. Now this is expected behaviour, but how to get the ArrayCollection to work? Custom accessors and mutators! In Person.as modify the above to the below:
_addressArray:ArrayCollection();
[Bindable(event="addressArrayChanged")]
public function get addressArray():Object {
return _addressArray as ArrayCollection;
}
public function set addressArray( value:Object):void {
_addressArray = new ArrayCollection(value as Array);
var eventObj:Event = new Event("addressArrayChanged");
dispatchEvent(eventObj);
}

HTH!

DK