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/