Deleting Multiple Rows with Zend DB Table Problem

Posted by davykiash on Stack Overflow See other posts from Stack Overflow or by davykiash
Published on 2010-04-08T05:34:06Z Indexed on 2010/04/08 5:43 UTC
Read the original article Hit count: 466

Filed under:

zend-db-table

|

zend-db

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)
    {
        $this->delete('Col1 = "'.$key.'"');
    }

How can I adjust it so that I can delete multiple rows?

© Stack Overflow or respective owner

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

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