Nylon Technology Presentation: ColdFusion Query Object Primer

Posted March 30, 2007 at 8:52 AM

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.

Post Comment  |  Ask Ben  |  Permalink  |  Print Page




Learning ColdFusion 9 - ColdFusion 9 tutorials, samples, examples, demos

Reader Comments

Brucd
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 »
5,406 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.


Simon Free
Mar 30, 2007 at 5:10 PM // reply »
31 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)


Post Comment  |  Ask Ben

Recent Blog Comments
Secret Admirer
Jul 4, 2009 at 12:23 PM
Project HUGE: Huge In A Hurry - Get Big - Phase 2 / Week 3
My Poor Dreamboat :( I feel so sad when I know you are hurting. I hope you feel better soon. ... read »
Jul 4, 2009 at 9:42 AM
FLV 404 Error On Windows 2003 Server
I bookmarked this page. Thanks for given this great post.... ... read »
Jul 4, 2009 at 4:00 AM
Terms Of Service / Privacy Policy Document Generator
thanks ben, I'm not a big fan of contracts so to find your no no-nesense ToS generator has helped me no end. all the best matt ... read »
Justice
Jul 3, 2009 at 11:10 PM
Create A Running Average Without Storing Individual Values
@Ben, I think you're going about this the wrong way. You're trying to use complicated techniques when there is a simple and beautiful technique readily available (a la Gary Funk's comment). Instead ... read »
Bob
Jul 3, 2009 at 9:19 PM
Project HUGE: Huge In A Hurry - Get Big - Phase 3 / Week 1
a good technical explanation http://crossfitphoenix.typepad.com/crossfit_phoenix_forging_/the-overhead-squat.html ... read »
Jul 3, 2009 at 9:03 PM
Create A Running Average Without Storing Individual Values
If I wanted to do this and only carry two numbers, I'd keep track of the sum and N. Then you are pretty much accurate all the time. average = (sum + new_number) / (N + 1) But all this was in a for ... read »
Roland Collins
Jul 3, 2009 at 8:58 PM
Create A Running Average Without Storing Individual Values
@Martin - not just floating point though. Depending on what langauge you're working in, decimals can cause just as many headaches if they're not precise enough. But again, for most applications, th ... read »
Isnogood
Jul 3, 2009 at 7:16 PM
Project HUGE: Huge In A Hurry - Get Big - Phase 3 / Week 1
Watch this http://www.nsca-lift.org/videos/default.shtml ... read »