[CDBI] Performing a search on many IDs

Joss Shaw jossblowing at yahoo.co.uk
Tue Aug 1 11:12:26 BST 2006


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 ?

Any help greatly appreciated.

The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. http://uk.docs.yahoo.com/nowyoucan.html

More information about the ClassDBI mailing list