[CDBI] Re: Can CDBI do this?

[prev] [thread] [next] [Date index for 2006/01/19]

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

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi