Zend DB returning NULL value

Posted by davykiash on Stack Overflow See other posts from Stack Overflow or by davykiash
Published on 2010-03-31T13:13:59Z Indexed on 2010/03/31 13:33 UTC
Read the original article Hit count: 623

Filed under:

zend-db

|

zend-db-table

|

zend-framework

I have the following query that extends from Zend_DB_Table_Abstract

$select = $this->select()
            ->from('expense_details',
             array('SUM(expense_details_amount) AS total'))
        ->where('YEAR(expense_details_date) = ?', '2010')
            ->where('MONTH(expense_details_date) = ?', '01')
            ->where('expense_details_linkemail = ?', '[email protected]');

However it returning a NULL value despite its "equivalent" returning the desired value

SELECT SUM(expense_details_amount) AS total FROM expense_details
WHERE 
YEAR(expense_details_date) = '2010'                     
AND MONTH(expense_details_date) = '01'
AND expense_details_linkemail = '[email protected]'

Is my Zend_DB_Table construct above correct?

© Stack Overflow or respective owner

Related posts about zend-db

ZF2 Zend\Db Insert/Update Using Mysql Expression (Zend\Db\Sql\Expression?)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any way to include MySQL expressions like NOW() in the current build of ZF2 (2.0.0beta4) through Zend\Db and/or TableGateway insert()/update() statements? Here is a related post on the mailing list, though it hasn't been answered: http://zend-framework-community.634137.n4.nabble.com/Zend-Db-Expr-and-Transactions-in-ZF2-Db-td4472944… >>> More
Zend DB returning NULL value

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following query that extends from Zend_DB_Table_Abstract $select = $this->select() ->from('expense_details', array('SUM(expense_details_amount) AS total')) ->where('YEAR(expense_details_date) = ?', '2010') ->where('MONTH(expense_details_date)… >>> More
Zend DB MYSQL Wrapper

as seen on Stack Overflow - Search for 'Stack Overflow'
All, I have a PHP application written in Zend Framework with MVC style. I plan to use Zend_DB to connect to the MySQL database and process queries. I am looking for a wrapper class which makes it easy to use Zend_DB class. This wrapper class will have a constructor that connects to the Mysql db using… >>> More
Deleting Multiple Rows with Zend DB Table Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this data in my db Col1 Col2 DA Data1 DA Data2 DA Data3 DA Data4 DA Data5 I would like to delete all the values WHERE col1 = DA using my Zend DB Table adapter. The code below does not seem to work for multiple rows public function delete($key) { … >>> More
Selecting arbitrary strings with Zend DB Select?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using the fluent interface to create a Zend DB Select object/query. As part of the query, I would like to select an arbitrary string, like "SELECT 'foo' AS 'type' FROM ...". foo is not a column, it's just a string literal. When I select an arbitrary number, the query works as expected. When… >>> More

Related posts about zend-db-table

Deleting Multiple Rows with Zend DB Table Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this data in my db Col1 Col2 DA Data1 DA Data2 DA Data3 DA Data4 DA Data5 I would like to delete all the values WHERE col1 = DA using my Zend DB Table adapter. The code below does not seem to work for multiple rows public function delete($key) { … >>> More
When should use doctrine ORM and when zend-db-table?

as seen on Stack Overflow - Search for 'Stack Overflow'
In terms of project scale, doctrine vs zend-db-table speed and performance, when should I use doctrine inside Zend project, and when zend-db-table? >>> More
(Zend Framework - doctrine- orm) When should use doctrine and when zend-db-table?

as seen on Stack Overflow - Search for 'Stack Overflow'
(Zend Framework - doctrine- orm) When should use doctrine inside Zend project and when zend-db-table? Thanks >>> More
Zend DB returning NULL value

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following query that extends from Zend_DB_Table_Abstract $select = $this->select() ->from('expense_details', array('SUM(expense_details_amount) AS total')) ->where('YEAR(expense_details_date) = ?', '2010') ->where('MONTH(expense_details_date)… >>> More
Zend Framework :: ORM - doctrine / propel over Zend_Db_Table

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys, do anyone suggest using an external ORM like Doctrine/Propel over the defualt Zend_Db_Table in Zend Framework ? I think your answers with reasons would be valuable across the ZF community. -DevD >>> More