query, dump, query, dump - is this better?

I’m working on an application where I don’t (yet) have access to the database schema. It’s a complex application with lots of data and isn’t the most… how shall I say it.. well structured set of data I’ve even seen. To help me dig into the database and figure out what’s going where, I’m doing a bunch of cfquery calls followed up by a cfdump.

While working, I accidentally found myself typing something that wasn’t valid ColdFusion, but it just felt right at the time:

<cfdump query="select * from thetable" top=5 label="get test 5">

What do you think? Would that be useful? I know a large majority of my dumps are queries, but they tend to be queries I’m going to keep using. This is one of those rare times where I won’t be keeping most of my queries around once I’m done digging.

P.S. If top and label are new to you, check out my ode to a dump blog post.

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support.

Lafayette, LA https://www.raymondcamden.com

Comments