[Dbix-class] search for equality between columns

[Daniel McBrearty]

mea culpa ... me remember next time :-)


On 6/17/07, Matt S Trout <dbix-class at trout.me.uk> wrote:
> On Sun, Jun 17, 2007 at 07:38:00PM +0200, Daniel McBrearty wrote:
> > table has two integer columns:
> >
> > id1 INTEGER,
> > id2 INTEGER
> >
> > sql query:
> >
> > SELECT COUNT(*) FROM table WHERE id1 = id2;
> >
> > how do I do this in dbix?
>
> You can't, since DBIx is a CPAN namespace for DBI extensions, not a project.
>
> Please *please* if you can't be bothered typing DBIx::Class call it DBIC,
> DBIx is not only massively innacurate but results in me periodically getting
> support requests for random other DBIx::* modules I've never heard of before.
>
> Alternatively I can just forward those to the last person who used the wrong
> name in my earshot :P
>
> --
>       Matt S Trout       Need help with your Catalyst or DBIx::Class project?
>    Technical Director    Want a managed development or deployment platform?
>  Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
> http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>


-- 
Daniel McBrearty
email : danielmcbrearty at gmail.com
www.engoi.com
danmcb.vox.com
danmcb.blogger.com
BTW : 0873928131