Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Guust Nieuwenhuis and Damien Bruyndonckx and Steven Peeters and Cyril Hanquez
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Guust Nieuwenhuis@Lagaffe ) , Damien Bruyndonckx ( @damienbkx ) , Steven Peeters@aikisteve ) , and Cyril Hanquez@Fitzchev )

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 »