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.