[Looking for Charlie's main web site?]

I'll be speaking at WebDU (Sydney) in 2 weeks, and presenting a day-long class as well

Posted At : March 5, 2007 9:41 PM | Posted By : Charlie Arehart
Related Categories:
Comments: (1)
Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.
For any who may be considering the WebDU conference in Sydney Australia on Mar 22-23, I'll point out that I'll be speaking as well as presenting a day-long class.

The presentation topic will be "Caching-In" on CF Performance, a talk which I plan to start offering in the States soon as well. I plan to explain not only the common form in query, template, and output caching, but several more as well.

The day-long classes will be an update of the "FastTrack Training for FusionReactor & FusionDebug" that I have given most recently in Europe. The price is just AU$175 for a half-day or $299 for the full (that's US$128 or 219, respectively). Details and registration are here.

The FusionDebug portion of the day will, of course, address the latest and greatest version 2, released just a couple of weeks ago. I'll have more to say on that soon.

It's been nearly 7 years since I was last in Oz (for my honeymoon), and nearly 11 years since I lived there. Several other yanks will be speaking, along with dozens of Aussies, a Kiwi, and a Nederlander. With tracks on CF, Flex/RIAs, Flash, and web techniques, there should be something for everyone. I hope any of my readers who attend will please come say hello.

Thanks to Geoff Bowers and the folks at Daemon for putting on this 2nd year of the show. I'll also be speaking at CFObjective and CFUnited, both of which I'll write about later.

Comments (1)

Did you know about the NULL attribute of CFQUERYPARAM? I didn't, until today.

Posted At : March 5, 2007 4:13 PM | Posted By : Charlie Arehart
Related Categories: cfml
Comments: (20)
Note: This blog post is from 2007. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.
Will the riches of CFML ever cease to amaze me? :-) Did you know about the NULL attribute of CFQUERYPARAM? I didn't, until today. Consider that you use CFQUERYPARAM and point its VALUE to a variable. What would happen if the value was empty, but your database required a null? How would you solve this? If you didn't know better, you might use an IF test to say "if it's null, use a null, else use the variable", but there a much more elegant solution.

Did you know that CFQUERYPARAM has a NULL attribute that is just for this purpose? It takes a boolean to indicate whether and when to use a NULL rather than the VALUE.

It's not new, having been around since 4.5 according to the CFML language history file. I've just never noticed it before. I learned about it today from a couple of folks on the great CFAUSSIE list.

Now, to be honest, the docs (CFML Reference for the tag) just don't make it as clear as it could be, I don't think (otherwise I'd like to think I'd have noticed it before). I don't see any mention of it in the Developer's Guide, for instance.

Anyway, you can read more about it in a blog entry from Michael Sharman, who I see also just happened to blog about it last month, with a lot more detail:

http://www.chapter31.com/2007/02/04/cfqueryparam-and-conditional-handling-of-nulls/

You might also want to read the comments there as well as at the CFMX 7 docs for the tag, both of which have people sharing their experiences using the tag, over time.

Comments (20)
Copyright ©2024 Charlie Arehart
Carehart Logo
BlogCFC was created by Raymond Camden. This blog is running version 5.005.
(Want to validate the html in this page?)

Managed Hosting Services provided by
Managed Dedicated Hosting