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  |  Print Page





Reader Comments

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

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.


Ben Nadel
Mar 30, 2007 at 10:47 AM // reply »
7,572 Comments
36,838 Points

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


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

I wish great success a project.


Simon Free
Mar 30, 2007 at 5:10 PM // reply »
31 Comments
22 Points

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
Frits Offenbach
Mar 20, 2010 at 9:00 AM
Building A Fixed-Position Bottom Menu Bar (ala FaceBook)
I would like to say thx for an easy way to create a bottom bar. I do have a ?. Is it possible to center the bar if i want to resize it to ex 85%. Regards Offenbach ... read »
Gojko
Mar 19, 2010 at 7:26 PM
MySQL 3/4 - com.mysql.jdbc.Driver And allowMultiQueries=true
Thank you very much for this post. Adding allowMultiQueries="true" in context.xml didn't help until I added it to url as allowMultiQueries=true Good idea is to use prepared statements and it will he ... read »
Jim
Mar 19, 2010 at 4:49 PM
Nobody Puts Baby In The Corner!
Wow. This is like suddenly finding a support group for your secret shame. I'm not alone! I always liked this movie, even though it is extremely cheesy. I just wish Jennifer Grey hadn't gotten the ... read »
Bryan Hurley
Mar 19, 2010 at 4:47 PM
Application.cfc OnRequest() Method Affects OnError() Arguments
@Jason and @Ben, I've been doing some CF9 refactoring on our systems and noticed an odd occurrence with onError as well. Found a way to work around my problem, but what I saw was... Background: Our ... read »
Jim
Mar 19, 2010 at 4:44 PM
Shoot 'Em Up Starring Clive Owen And Paul Giamatti
I actually enjoyed this movie quite a lot. It was different, certainly, but I think they were going for more of a Quentin Tarentino-"wow, that was weird"-vibe than an actual spoof. Once I realize ... read »
Billy
Mar 19, 2010 at 4:34 PM
An Intensive Exploration Of jQuery With Ben Nadel (Video Presentation)
Hey I guess the video is down. Is there anyway you can upload to youtube or vimeo or some other service? Greatly appreciated. ... read »
Jose Galdamez
Mar 19, 2010 at 4:24 PM
ColdFusion CFPOP - My First Look
@Ben Thanks for the follow up! The root of the problem had to do with being able to trace bounced emails to specific records in a DB table. Let's say you run an email campaign and you get 1,000 bou ... read »
AmberCF
Mar 19, 2010 at 4:15 PM
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
Thank you Ben and Tony! Either of these work for the summary report I am working on and the info is much appreciated! I think I like Tony's a little better because I won't have to educate every ... read »