Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jason Dean and Simon Free and Alison Huselid and Josh Adams and John Mason
Ben Nadel at cf.Objective() 2010 (Minneapolis, MN) with: Jason Dean@JasonPDean ) , Simon Free@simonfree ) , Alison Huselid , Josh Adams@jladams97 ) , and John Mason@john_mason_ )

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 »