RE: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Thomas D.
Hi, Carlton Gibson wrote: > > My problem is, that when I call $driverTable->doSth(1278), the row > > in the driver's table will be deleted, but it won't delete any rows > > in cars. > > > > Did I miss something? > > Yes. The cascading write options ONLY work via the Row object. Thank you, too.

RE: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Thomas D.
Hi, Ben Scholzen 'DASPRiD' wrote: > You should probably take a look at Foreign Keys and Cascading in your > database's manual. As I have written in a reply for Andrew, the database I am working with uses the MyISAM engine, which don't support foreign keys. Converting the engine to InnoDB is curr

Re: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Ben Scholzen 'DASPRiD'
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 You should probably take a look at Foreign Keys and Cascading in your database's manual. ... : ___ _ ___ ___ ___ _ ___: : | \ /_\ / __| _ \ _ (_) \ : : | |) / _ \\__ \ _/ / | |) | : : |___/_/:\_\___/_|

RE: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Thomas D.
Hi, Andrew Ballard wrote: > You are changing the syntax between the two examples. In the first, > you are calling finding a specific row and > Zend_Db_Table_Row_Abstract::delete() on that row, which is what is > shown in the documentation. This function scans the dependent tables > and deletes all

Re: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Andrew Ballard
On Tue, Jun 30, 2009 at 12:18 AM, Thomas D. wrote: > Hi, > > I have two tables, drivers and cars. > Each driver in drivers has his cars in cars. > > When I delete a driver, his cars should also be deleted in cars. > > I defined two classes: > > class Drivers extends Zend_Db_Table_Abstract > { >    

Re: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Carlton Gibson
On Tue, Jun 30, 2009 at 12:18 AM, Thomas D. wrote: Hi, I have two tables, drivers and cars. Each driver in drivers has his cars in cars. When I delete a driver, his cars should also be deleted in cars. I defined two classes: class Drivers extends Zend_Db_Table_Abstract { [...] protecte

RE: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Thomas D.
Hi, thank you for your reply. Andrew Ballard wrote: > Is referential integrity not an option? No, the tables I am working with are part of a MyISAM database of an existing, not fully Zend_Framework based application (I am working on the first Zend_Framework based module). Converting the whole

Re: [fw-general] Zend_DB_Table: delete() won't delete any row in dependent tables

2009-06-30 Thread Andrew Ballard
On Tue, Jun 30, 2009 at 12:18 AM, Thomas D. wrote: > Hi, > > I have two tables, drivers and cars. > Each driver in drivers has his cars in cars. > > When I delete a driver, his cars should also be deleted in cars. > > I defined two classes: > > class Drivers extends Zend_Db_Table_Abstract > { >