[solved] CDD advance WHERE help ...

[hardkiffeur]

Hi friends,
Into a ccd, I've a WHERE query I would do like this :

{thistable}.for_team IN {$my->groups} But I've a Sql Error :

1064 - 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 '10,21 ORDER BY text ASC' at line 3 SQL=SELECT DISTINCT(`pg_contacts`.`id`) AS value, `pg_contacts`.`first_last_name`AS text FROM `pg_contacts` AS `pg_contacts` WHERE type = '0' AND pg_contacts.for_team IN 10,21 ORDER BY text ASC

What I looking for it's having all entries where for_team ( a int(11) column) = 21

Thanks for help ...

 

[hardkiffeur]

OK solved by :
{thistable}.for_team IN ({$my->groups})