Sorry beeing in english
Hi,
I’m facing a problem:
I have a multi-select main category in field cat1 , and other multi-select category 2, that is related with cat1, that means each cat2 is related with one or more cat1, in a colum in table cat2 (like 1,2,5 ) , and Im only showing the cat2 related with the chosen cat1.
thos is the senario :
CAT1
name : id
XX : 1
YY :2
ZZ :3
CAT2
name : id : cat1_id
AAA : 1 : 2
BBB : 2 : 1,2
CCC : 3 : 2
In cat2 select, I’m using cat1 field var in the select , in order to filter cat2.
The problem is that when chossing cat1 YY (2), only shows me in cat2 : AAA and CCC.
from debug noticed that sc is creatin the select in where : where cat1_id in (‘2’) , is passing a string (that what it realy is), but that way is not showing cat2 BBB, if i run the select in mysql and use where cat1_id in (2) instead of where cat1_id in (‘2’), it get the expected result.
Is there any way to force not using the ‘’ ?
Please help on this, my application have this issues in a lot of places
Tks