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 Scotch On The Rocks (SOTR) 2011 (Edinburgh) with:

Bob Silverberg

Member since Dec 11, 2008

Recent Blog Comments By Bob Silverberg

  • SQL LIKE Clause Case Sensitive in ColdFusion MX Query-of-Query

    Posted on Apr 19, 2007 at 4:03 PM

    I just encountered this issue and found a solution that allows for case-insensitive searching with QofQ's. I know this is an old blog entry, but I thought I'd share it anyway. You can use a combination of LOWER() and LCase() to address this issue. In your example, your query would change to: SEL... read more »