[CDBI] Performing a search on many IDs

[Joss Shaw]

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 ?

Any help greatly appreciated.
-joss


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