Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at the jQuery Conference 2010 (Boston, MA) with: Brandon Aaron
Ben Nadel at the jQuery Conference 2010 (Boston, MA) with: Brandon Aaron@brandonaaron )

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 »