[thelist] Complex SQL query SOLVED

Jay Blanchard jay.blanchard at niicommunications.com
Wed May 29 14:53:01 CDT 2002


I have to give my rudy badge back,
I forgot the single quotes around the dates,
Sometimes my brain is so lax,
I screw up my own fate!

sum(if(dueDate between 2001-12-01 and 2001-12-30, ageAmt, 0)) AS "+150"

should be

sum(if(dueDate between '2001-12-01' and '2001-12-30', ageAmt, 0)) AS "+150"

Duh...

Jay

p.s. rudy, it is mysql...





More information about the thelist mailing list