[CDBI] Re: Can CDBI do this?

Edward J. Sabol sabol at alderaan.gsfc.nasa.gov
Thu Jan 19 21:45:54 GMT 2006

Ben Lavender asked about the following:
>>> SELECT events.(essential) FROM events, certs WHERE ( events.duedate <
>>> "2999-01-01" AND certs.id = events.cert AND certs.type = "Some String I
>>> Input") ORDER BY dueDate LIMIT 10;

Bill Moseley replied:
>> Look at CDBI::Sweet;

Will Hawes replied:
> Or better still, switch to DBIx::Class.

Frankly, you don't need to do either one. Yes, CDBI can do this. Read the
CDBI docs on the set_sql method:


and read the Wiki node on using joins:


More information about the ClassDBI mailing list