dbix and raw sql output?

[Joshua Spoerri <jo...@yucs.org>]

Hello,
How does one do a select count(*) using dbix?
I would just use the underlying dbi,
but it would nice to keep Links and Filters.

Thanks in advance,
Josh

---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org

Re: dbix and raw sql output?

[Gerald Richter <ri...@ecos.de>]

Hello,
> How does one do a select count(*) using dbix?

$set -> Search ({'$fields' => 'count(*) as cnt'}) ;

$count = $set{'cnt'} ;

You can also use the !Fields instead of '$fields' when you give it at object
setup time

Gerald


-------------------------------------------------------------
Gerald Richter    ecos electronic communication services gmbh
Internetconnect * Webserver/-design/-datenbanken * Consulting

Post:       Tulpenstrasse 5         D-55276 Dienheim b. Mainz
E-Mail:     richter@ecos.de         Voice:    +49 6133 925131
WWW:        http://www.ecos.de      Fax:      +49 6133 925152
-------------------------------------------------------------



---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org