« February 2008 | May 2008 »

April 3, 2008

ColdFusion tip: Dynamic column names in ValueList()

Today I discovered that the ValueList() function in ColdFusion only works with a static argument in the form "query.column". So you can't use this function if you need to dynamically determine the column name at runtime. Luckily there is a nice little hack to work around this problem.

The ValueList() function returns a list of values from a particular query column. You can achieve the same result with the following expression:


Posted at 3:41 PM in ColdFusion | Comments (9)

April 1, 2008

ColdFusion spellchecker plugin for TinyMCE 3.0

We use TinyMCE as a WYSIWYG editor for our CMS at work. Version 3.0 of TinyMCE was recently released in which most of the application has been rewritten. Because of this rewrite, any plugins written for version 2.x have to be updated to be compatible with version 3.

The main third-party plugin that we use is a spellchecker plugin for ColdFusion servers. Since the plugin hasn't been updated, I took it upon myself to port the PHP spellchecker plugin provided with TinyMCE 3.0 to ColdFusion.

My ColdFusion spellchecker plugin is a complete port of the PHP plugin and supports both the Google spellchecker and Pspell/Aspell engines.

[Download the TinyMCE 3.0 ColdFusion spellchecker plugin]

Posted at 10:33 AM in ColdFusion | Comments (16)