Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Anthony Israel-Davis
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Anthony Israel-Davis ( @anthony_id )

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 »