Any tips on how to use Mapper with SQL IN() function?

[ethanpil]

Typical binding doesnt work with the IN() function..

$catalog->find( array('ITEM_NO IN(?)', $alternatives));

Any ideas on how to keep this query within the mapper?

[ikkez]

$catalog->find( array('ITEM_NO IN(?,?,?)', $alternatives[0],$alternatives[1],$alternatives[2]));

this should work

[ethanpil]

Ahh, very nice... but what if, of course, I have a dynamic number of parameters... :)

[Achille D'Aniello]

Hi,

in a similar case i used something like this:

$catalog->find( array('ITEM_NO IN(?)', implode(",", my_array_of_alternatives )));

Naturally, if your array of values isn't only numeric, you need to adapt the first parameter of implode.

I don't know if is the "right" mode, but i hope this can help you