Hi, I'm running a query in vbscript that is returning no rows, yet in phpmyadmin it works fine, anyone got any ideas?
Code:SELECT * FROM `jos_comprofiler` WHERE (((jos_comprofiler.cb_donotemail <> 1 AND jos_comprofiler.cb_donotsms <> 1) OR (jos_comprofiler.cb_donotemail IS NULL AND jos_comprofiler.cb_donotsms IS NULL)) ) AND (`cb_membershipexpires` < STR_TO_DATE('31/12/2020', '%d/%m/%Y'))


LinkBack URL
About LinkBacks
Reply With Quote
