It has been a long time since I wrote a ColdFusion Builder extension, but as I’m using it more and more (with the new 3.0 release), I came across a need to write one today. One of the older features that I’ve used quite a bit is the table view in the RDS panel. This lets you select a table, right click, and dump the data into a new tab. Sure I can do this with other tools, but having it in my IDE is nice.
Unfortunately, this feature has been plagued by a bug (now four years old) that prevents it from working sometimes. Screw that. CFB’s extension API lets you integrate with the RDS tables. I wrote an extension that simply lets you right click on a table and select dump:
It then fires up a view with a simple dump of the top 200 rows.
And that’s it. I’m considering making it more intelligent so that you can right click on a particular field and it shows just that field. That will take about five minutes but I’m not in the mood to do it right now.
The extension is attached to this blog entry. Enjoy.
P.S. I fixed it so you can select a field and see just that one.