[CDBI] Performing a search on many IDs
Joss Shaw <jossblowing-/[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
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