Allen

Recent Blog Comments By Allen

• Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

  Posted on Mar 28, 2008 at 3:56 PM

  " One good reason I've found to support application SQL versus stored procedures is the fact that I get to leverage my constant variables in the SQL I wrote within the application, versus having to define them again in my DBMS or hard code those values. That can be very handy for transparency or th... read more »

• Code Assertively

  Posted on Mar 15, 2008 at 12:26 PM

  Ben --> I commend you for getting us to think about how we code. Too often we're in jobs that don't have code reviews, best practices and such. We get into habits and we don't even remember why we're doing them in the first place. A service I would pay for is someone who could constructively c... read more »

• ColdFusion 500 Null Error Revisited

  Posted on Feb 20, 2008 at 9:14 PM

  Actually, it looks like that wasn't it. I'm going to try to reproduce it. Maybe have been from the same process but trying to send a variable in the client scope that didn't exist...... read more »

• ColdFusion 500 Null Error Revisited

  Posted on Feb 20, 2008 at 6:25 PM

  I just ran into a 500 NULL error. It was very frustrating. Turns out I needed to duplicate the struct returned from a private method in the component and it then worked fine.... read more »

• Code Assertively

  Posted on Sep 18, 2007 at 6:29 PM

  Good point, Rob. We shouldn't loose track that the original post isn't saying it's better. I may have lost that a bit with my comments. I don't want to ever discourage these sort of discussions because, and maybe it's the cave I live in, don't have them often enough. There's not really a right /... read more »

• Code Assertively

  Posted on Sep 18, 2007 at 2:52 PM

  So the lesson here is to drop some f-bombs in the code? ;) Actually I still fail to see how isDefined("scope.varname") is any less precise. Nor do I see how it asserts less of an understanding between a variable that exists in a scope (a goofy thing on CF's part) and that you just don't think the... read more »

• Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

  Posted on Sep 4, 2007 at 2:47 PM

  Pinal --> For me it's been using them both together. I've seen some people write a lot of CF code to do something they could do in just a few SQL commands passed off via CFQuery.... read more »