WADA Search error - checkbox??
Hello there - hope you can help.
I am using DataAssist 2.06 and I am getting an error when I use a checkbox field using DataAssist Search - the field is set up OK on the search page and it has a static checked value of 1.
The database is MySQL and the field is a TINYINT with a length of 1 - values 1 for true, 0 for false,
All the fields have values in them.
If the checkbox is NOT checked all is OK and all the records return on the results page.
If the checkbox IS checked then I always get the following;
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 'show = 1) ORDER BY full_item_details.category_description ASC LIMIT 0, 10' at line 1
I attached the checkbox setup.
It does not seem to make any difference as to whether I inset a value in the second field 'setup' box or not.
The code in the page header is;
//comparison list additions
$WADbSearch1->addComparisonFromEdit("UID","S_UID","AND","=",1);
$WADbSearch1->addComparisonFromEdit("toyname","S_toyname","AND","Includes",0);
$WADbSearch1->addComparisonFromEdit("category","S_category","AND","=",1);
$WADbSearch1->addComparisonFromEdit("agerange","S_agerange","AND","=",1);
$WADbSearch1->addComparisonFromCheck("show","S_show","1","","AND","=","=",1);
Can you please shed any light on this?
Many thanks
Steve