Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Asif Rasheed

Jeffrey Bouley

Member since Dec 11, 2008

Recent Blog Comments By Jeffrey Bouley

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

    Posted on Mar 28, 2008 at 10:49 AM

    @William, so many points I don't know where to start 8-)... I'll try quoting what you said with my replies. "I get to leverage my constant variables in the SQL I wrote within the application" Who says you can't pass these app. constants as arguments to your proc? "The whole point of defining glob... read more »

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

    Posted on Mar 27, 2008 at 9:52 PM

    @Ben, totally agree on the bad sql in stored procs statement, my point was better to be bad and in the database than bad and in ColdFusion. @Zac, I couldn't disagree with you more. What is the benefit of seeing the actual sql in the debug output when you know where it is whether in CF or in a proc... read more »

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

    Posted on Mar 27, 2008 at 5:09 PM

    Ben, I'd also like to add, always use stored procedures if possible. If you apply "separation of concerns" here, it is never a good idea to put sql in application code. Security and performance are an after thought regarding ColdFusion as well as it's integrated and forces data typing which safegu... read more »