Aside from the issues Dan has already pointed out, to get what you're looking for, drop the CFIF statement and just write your WHERE statement like this: WHERE contactid >= 1 AND (date="8/25" OR date2="8/25")
... View more
Yep, it's been that way for a long time. This page explains it: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-7a7b.html I avoid naming any of my form fields with the suffixes listed on that page. Deb
... View more