Jason,
That gives me a similar error.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ANDStatus=0 ORDER BY status ASC LIMIT 0, 100' at line 1
when using
$WADbSearch1_DefaultWhere = "WHERE Status=0";
Does it matter how I have the Search Parameter set? Maybe that's my problem.
*Note-the column 'status' is an integer.
This is what I have:
Separator: AND
Column: status
Column Type: -I tried both Number/Boolean and Text as the column type. That didn't seem to matter.-
Filter Type: Keyword
Value: <?php echo $_GET['Status']; ?>
Keyword AND: ,
Keyword OR: -empty-
Thanks,
TroyD