Nylon Technology Presentation: ColdFusion Query Object Primer

Posted March 30, 2007 at 8:52 AM by Ben Nadel

Tags: ColdFusion, Work

Here at Nylon Technology we have bi-weekly staff meetings where one of us gives a presentation on some sort of technology. I have gone a bunch of times and it is a lot of fun (although, with no projector or computer it's hard to come up with acceptable topics to talk about). This morning, I am going to give a primer on the ColdFusion query object. I am sure a lot of it will be review for these people (my co-workers), but hopefully they will learn a thing or two - doesn't that make it all worth it?

Here it is in Microsoft Word DOC format: CFQueryPresentation.doc

I have not had time to put it into a pretty HTML format. I doubt that I will, as much of what is discussed in the document has already been covered on my site previously (in better formatting with more fleshed out explanations). Enjoy!

Note: This is not a SQL presentation, but a discussion of the QUERY object itself.




Reader Comments

Mar 30, 2007 at 9:46 AM // reply »
22 Comments

Ben - thanks for posting this. I did learn something new. Didn't know you could use ArraySum to sum all the values stored in a query column. I've been doing it manually.


Mar 30, 2007 at 10:47 AM // reply »
11,247 Comments

Hey, if one person learns one thing... then it was worth it :)


Mar 30, 2007 at 11:25 AM // reply »
9 Comments

I wish great success a project.


Mar 30, 2007 at 5:10 PM // reply »
32 Comments

Hey if you guys liked the paper version of the presentation, you should have seen the live show! it was superb! I even stayed awake for it! (damn early meetings)


Jul 28, 2010 at 5:05 AM // reply »
1 Comments

Hey Ben,

Thanks for keeping this up, it helped solve a minor argument I was having.

Cheers :)


Post A Comment

Comment Etiquette: 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.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 24, 2013 at 5:39 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Adam Oops! My mistake! I hadn't gotten that far in my testing - I'm still baby stepping my way through the process. ... read »
May 24, 2013 at 5:13 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
Hi Jason, Thanks for checking up on that, but I still stand firm on my position. :) There are actually two listLast()'s in use, and you're right that the one using a space as a delimiter is fine. ... read »
May 24, 2013 at 4:45 PM
Ask Ben: Manually Enforcing Basic HTTP Authorization In ColdFusion
@Ben I have been lurking your site for quite some time, and haven't stepped up to comment until today. Thanks for all the great info - keep it up! @Adam I believe you are mistaken... as the commen ... read »
May 24, 2013 at 11:21 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@WebManWalking, Ha ha, let's us never speak of justifying "##" notation again :P ... read »
May 24, 2013 at 11:18 AM
Strange Interaction Between DeserializeJson(), ArrayContains(), And Database Values In ColdFusion
@Ben, Ah, so it was indeed how I vaguely remembered it to be: A direct assignment value = users.id[ i ] causes value to retain the sticky datatype of the query column. Although unnecessary in ... read »
May 24, 2013 at 9:11 AM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Brandon, Hi, No, I haven't been able to do that. I have just kept it as it is. ... read »
May 23, 2013 at 9:52 PM
Preventing Links In Standalone iPhone Applications From Opening In Mobile Safari
@Muhmmadibn Did you figure out a solution to launching PDFs? I am running into the same issues myself. There is no way to close the PDF or go back once you launch it. Thanks in advance! ... read »
May 23, 2013 at 6:06 PM
The Girl Who Broke My Heart, And Made Me A Better Person
Good day,ladies and gentle men, my name is Dr AMADI the great spell caster in Africa, i have help so many people for different kind of problems,who say there is no solution to problems on earth, that ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools