This returns true or false. try var_dump in result.
Cordialmente Rodrigo Régis Palmeira [email protected] www.rodrigoregis.com.br www.foxsis.com 2014/1/21 David R <[email protected]> > Hello, > > I do not understand why DBAL execute statement return 1 and not the number > of rows affected. > Any idea ? > > > $dbal = $this->get('database_connection'); > $dbal->beginTransaction(); > try { > > // Remove Pets > $sql = "delete from pet where type_id = ?"; > $stmt1 = $dbal->prepare($sql); > $stmt1->bindValue(1, $pt->getId()); > $countpet = $stmt1->execute(); > > // Remove Pet Type > $sql = "delete from pettype where id = ?"; > $stmt3 = $dbal->prepare($sql); > $stmt3->bindValue(1, $pt->getId()); > $counttype = $stmt3->execute(); > > // Commit transaction > $dbal->commit(); > ====>> $countype and $countpet =1 whereas lots of rows > affected. > > } catch (\Exception $e) { > $dbal->rollback(); > throw $e; > } > > I check in database, 26 pets have been removed and 1 pettype. > > Help appreciate. > Thanks. > David. > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
