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





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 »
6,516 Comments
25,763 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
anang
Nov 22, 2009 at 1:56 AM
Learning ColdFusion 9: Using CFQuery In CFScript Can Enable SQL Injection Attacks
Why adobe would give you script equivalent of cfquery is beyond me. I love cfquery tag because it helps me wriite clean sql, and get away from the horrible jdbc queries If I wanted to write javali ... read »
anang
Nov 22, 2009 at 1:45 AM
Streaming Text Using ColdFusion's CFContent Tag And The Variable Attribute
The reason you would want to do this is to stream. Ack json/xml files to ria clients I used thus technique before because putting json in response stream causes debugging info to come thru As well a ... read »
komik
Nov 21, 2009 at 6:47 PM
Hal Helms - Real World Object Oriented Development, Sarasota - Day Five
@charlie griefer, Thank you.. ... read »
Jody Fitzpatrick
Nov 21, 2009 at 5:15 PM
Using ColdFusion Structures To Remove Duplicate List Values
@Jose Galdamez, Oh heh yeah I didn't paste the whole code. I should have defined the vars -- my bad. It's fixed thou. Thanks. ... read »
Unibands
Nov 21, 2009 at 4:49 PM
Styling The ColdFusion 8 WriteToBrowser CFImage Output
Great work yet again Ben! Whilst I didn't use this whole code, I copied some of your regex code for a similar problem with the lack of an alt attribute and unescaped ampersands in CFIMAGE for Railo 3 ... read »
Justice
Nov 21, 2009 at 1:13 PM
My First ColdFusion Builder Extension - Encrypting And Decrypting CFM / CFC Files
@Ben, Because I am pedantic, I just want to make sure that everyone knows there is absolutely no encryption going on. There is only encoding and obfuscation. The cfencode tool only obfuscates your C ... read »
Jose Galdamez
Nov 21, 2009 at 12:28 PM
Using ColdFusion Structures To Remove Duplicate List Values
@Jody I can't seem to get your code sample to work. If you are still having problems, try this code out and see if it gets you what you wanted. <!--- Comma delimited list with various duplicates ... read »
Esther Annies
Nov 21, 2009 at 11:03 AM
Groovy Operator Overloading Does Not Work In The ColdFusion Context
Hi Ben, Thanks for this informative post. Now I am reading ur old posts too ... read »