For a while now a small bug has impacted RDS dataviews in ColdFusion Builder. I love the built in data views in CF Builder, but this little bug has annoyed me for too long now.
This bug, and a workaround, are discussed here, but in the meantime, I thought, why not just write a quick CFBuilder extension to get around it. So with that in mind, I wrote "My Databasie View." Once installed, you can right click on any table...
This will pop open this view...
At which point you can edit the SQL and do whatever you want. The display ain't great, but I never realized how much I used the RDS "Show Table Contents" feature until it stopped working reliably.
You can download this at the RIAForge project I just set up for it - http://mydatabaseview.riaforge.org/.
Archived Comments
Very nice Ray. That's been driving me crazy :)
Wow, the issue is still not patched yet? I posted the two workarounds back in May when I encountered it while I was playing with the newly released ColdFusion Builder 2.
Someone also mentioned that it had existed in a beta version.
It's a pumpkin month now, so it's been around for a quit while. I guess it's time for you to knock on their door for a trick or treat. I will let you wear whatever you like. ^^;