-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Actually, when you want to switch the DB engine, it does matter. ................................... : ___ _ ___ ___ ___ _ ___ : : | \ /_\ / __| _ \ _ (_) \ : : | |) / _ \\__ \ _/ / | |) | : : |___/_/:\_\___/_| |_|_\_|___/ : :........:........................: : Web : http://www.dasprids.de : : E-mail : [email protected] : : Jabber : [email protected] : : ICQ : 105677955 : :........:........................:
Jason Webster schrieb: > Not that I'm aware of, but.... > > Why do you have to use Zend_Db_Select to do this?? > If it's a static query like that, that isn't built procedurally, there's > nothing wrong with just using the SQL statement. > > On 18/02/2009 10:31 AM, Henry Umansky wrote: >> Is there an easy way to run the following query using Zend_Db_Select >> without using joins? >> >> SELECT >> (SELECT Count(*) FROM articles WHERE status=0) AS 'Draft', >> (SELECT Count(*) FROM articles WHERE status=1) AS 'Review', >> (SELECT Count(*) FROM articles WHERE status=2) AS 'Published' >> >> I just need to get the count according to the record status. >> >> -Henry > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkmchHkACgkQ0HfT5Ws789D4jQCdHjqk0/Utv3aSpoDBASOkyb2p +GEAniYqvAORTA+KnjLcTL50e0pjUHyK =+W62 -----END PGP SIGNATURE-----
