[CDBI] Performing a search on many IDs

Matt S Trout dbix-class at trout.me.uk
Tue Aug 1 15:10:04 BST 2006

Joss Shaw wrote:
> Hello,
> I've got a list of about 500 primary key IDs, which I
> want to do a search on with some other search
> criteria. In basic SQL I would do:
> SELECT * FROM x WHERE <conditions> AND ID IN (<list of
> primary key IDs>)
> I'm wondering how best to achieve this with
> Class::DBI. Is it a matter of using ::Sweet ?

Sweet or AbstractSearch are probably your best bets, unless you want to define 
a set_sql per query

(<obplug>or just switch to DBIx::Class ...</obplug>)

More information about the ClassDBI mailing list