[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:

http://search.cpan.org/~tmtm/Class-DBI/lib/Class/DBI.pm#Ima%3A%3ADBI_queries

and read the Wiki node on using joins:

http://wiki.class-dbi.com/wiki/Using_joins




More information about the ClassDBI mailing list