SQL Result Dump Is Formatted

Posted August 2, 2006 at 10:07 AM by Ben Nadel

I just found out this little fact by accident. Have you ever saved the results of a SQL query using the RESULT attribute and then dumped it out only to see a jumbled, useless SQL statement? Well, if you view the source code of the page, the SQL statement IS formatted just as it was inside the CFQuery tags. Easy to read! Wicked cool!

Reader Comments

There are no comments posted for this web log entry.

Post A Comment

: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Author Name:
Author Email:
Author Website:
Comment:	Supported HTML tags for formatting: <strong>bold</strong> <em>italic</em> <code>code</code>
	Remember my information
	Subscribe to comments
	Send me a copy of this comment

InVision App - Prototyping Made Beautiful With Prototyping Tools Ben Nadel's Company - Epicenter Consulting

Bartezz

Feb 10, 2012 at 7:21 PM

jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements

Update! Instead of $(eval(options.insertAfter)).after(data['insertData']); I now use: var ajaxNode = document.createElement('span'); var parent = $(eval(options.insertAfter))[0].parentNode; ... read »

Bartezz

Feb 10, 2012 at 6:18 PM

jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements

encountered this same, what I consider, jQuery bug last week. I'm building a site in which I load some content via AJAX. This content contains Linkedin share button placeholders which Linkedin API ne ... read »

Drew Wells

Feb 10, 2012 at 11:30 AM

Cross-Origin Resource Sharing (CORS) AJAX Requests Between jQuery And Node.js

After you understand the concepts here, this is an awesome cheatsheet for enabling CORS in just about anything http://enable-cors.org/ ... read »

Feb 10, 2012 at 9:10 AM

My Safari Browser SQLite Database Hello World Example

@Amy, Here is a very good tutorial on how to use JOIN: http://www.sqltutorial.org/sqljoin-innerjoin.aspx ... read »

Stefan Richter

Feb 10, 2012 at 4:42 AM

Building A Twitter-Inspired RESTful API Architecture In ColdFusion

This is great, very useful Ben. I spotted a small typo in the api.cgm listing: <cfthrow type="Unauthroized" /> Cheers Stefan ... read »

Hugh

Feb 9, 2012 at 10:35 PM

CFDirectory Filtering Uses Pipe Character For Multiple Filters (Thanks Steve Withington)

I was wondering if there would be a filter you could apply so that you got everything but what you included in the filter. As in show me all docs that are not a .pdf. ... read »

Stephen

Feb 9, 2012 at 10:29 PM

Learning ColdFusion 9: Application-Specific Data Sources

@Ben, No offence, but if people were really wanting advanced features they would be using a platform like ASP.NET MVC. CFML is so structurally compromised as a tag-based scripting language that ... read »

Nathan

Feb 9, 2012 at 10:03 PM

Subversion - Cleanup Failed To Process The Following Paths

@Leviaguirre, do you still have problems with this? ... read »