[CDBI] Performing a search on many IDs

Perrin Harkins perrin at elem.com
Thu Aug 3 17:33:20 BST 2006


On Tue, 2006-08-01 at 11:12 +0100, Joss Shaw wrote:
> 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.

If you already know how to get them with SQL, just use SQL.  There are
some examples of set_sql and add_constructor here:
http://wiki.class-dbi.com/wiki/Beginners_guide#set_sql

- Perrin




More information about the ClassDBI mailing list