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

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 »
6,515 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 »
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
Nov 20, 2009 at 5:38 PM
Learning ColdFusion 8: CFImage Part I - Reading And Writing Images
Hi Ben, Great article. I've been looking around to see if ColdFusion image engine can programatically create the following "wrap around" effect: http://www.creativepro.com/article/photoshop-s-she ... read »
Nov 20, 2009 at 5:35 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Dave: I talked to Gert he suggested: <cfhttp method="get" url="http://{some cf website}" result="stuff" addtoken="yes" /> Note the addition of cfhttp attribute addtoken. That should persist y ... read »
Nov 20, 2009 at 5:23 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Todd, Ahh, gotcha, yeah that makes sense. ... read »
Nov 20, 2009 at 5:17 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
Ben, sorry if I didn't make this clear. You can make it work like that if you want, just put <cfset session.foo = 1> (and <cfset application.foo = 1>) in your OnRequestStart() and it reve ... read »
Nov 20, 2009 at 5:07 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Todd, I have seen tidbits about the way Railo handles session. I can understand that it lazy-loads sessions, but I also think that I might make some things more complicated. For example, often tim ... read »
Nov 20, 2009 at 4:53 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
Ben, you can ramp up the security by turning on J2EE session which gives you a third set of numbers other than CFID/CFTOKEN. There's a reason why ACF put this in place (other than just session replic ... read »
Nov 20, 2009 at 4:52 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
Case in point, Ben, you may not be aware of this, but in Railo - OnApplicationStart() & OnSessionStart() act differently than in ACF. ACF does: OnApplicationStart (1st hit) OnSessionStart (1st and e ... read »
Nov 20, 2009 at 4:46 PM
Maintaining ColdFusion Sessions Across SMS Text Message Requests Without Cookies
@Todd, That's understandable. I am not sure if this really leaves any more security holes than the fact that using old cookie-based CFID / CFTOKEN values will create a new session using the old CFI ... read »