Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at dev.Objective() 2015 (Bloomington, MN) with: Justine Arreche
Ben Nadel at dev.Objective() 2015 (Bloomington, MN) with: Justine Arreche@saltinejustine )

Dim St Thomas

Member since May 15, 2009

Recent Blog Comments By Dim St Thomas

  • MySQL Does Not Support IF / ELSE Statements In General SQL Work Flow

    Posted on May 15, 2009 at 11:28 AM

    If I understand it correctly you want to do this without using procedures or functions but don't mind using multiple sql statements. I'm not sure what a CFQuery is, but I think the code below does what you want. Note the use of the special mySQL DUAL table. If you replace this with the contact table... read more »