My thought as well, but however it should be executed! When I create a new record, the last piece of code ($this->setRank(1)) is executed, all new records have '1' as rank value.
On 14 sep, 01:00, Sid Bachtiar <[email protected]> wrote: > If it doesn't show up and there's no error, it is possible that the > piece of code isn't executed at all. > > On Mon, Sep 14, 2009 at 10:19 AM, HAUSa > > > > <[email protected]> wrote: > > > Hmm... that query is not found in the controlpanel_dev.log... > > > sep 14 00:13:20 symfony [info] {estateActions} Call "estateActions- > >>executeCreate()" > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} exec: SET NAMES > > 'utf8' > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} prepare: INSERT INTO > > estate > > (`ID`,`TITLE`,`SLUG`,`TYPE`,`SURFACE`,`PRICE`,`INTRODUCTION`,`DESCRIPTION`,`AVAILABLE`,`ATTENTION`,`RANK`) > > VALUES (:p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10,:p11) > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding NULL at > > position :p1 w/ PDO type PDO::PARAM_NULL > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 'Test 6' at > > position :p2 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 'test-6' at > > position :p3 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 'buy' at > > position :p4 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 105 at > > position :p5 w/ PDO type PDO::PARAM_INT > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 1200.5 at > > position :p6 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 'fadsf adg' > > at position :p7 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding '' at > > position :p8 w/ PDO type PDO::PARAM_STR > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 1 at > > position :p9 w/ PDO type PDO::PARAM_INT > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 0 at > > position :p10 w/ PDO type PDO::PARAM_INT > > sep 14 00:13:20 symfony [debug] {sfPropelLogger} Binding 1 at > > position :p11 w/ PDO type PDO::PARAM_INT > > sep 14 00:13:21 symfony [info] {sfFrontWebController} Redirect to > > "http://controlpanel.dev.benvermeergroep.nl/index.php/estate/new"; > > > This query should be executed on save: > > public function save(PropelPDO $oCon = null){ > > > if($this->isNew()){ > > $oConnection = Propel::getConnection(); > > > $oSelectCriteria = new Criteria(); > > > $oUpdateCriteria = new Criteria(); > > $oUpdateCriteria->add(EstatePeer::RANK, '5'); > > > BasePeer::doUpdate($oSelectCriteria, $oUpdateCriteria, > > $oConnection); > > > $this->setRank(1); > > } > > > return parent::save($oCon); > > > } > > > On 14 sep, 00:07, Sid Bachtiar <[email protected]> wrote: > >> What's the SQL query in the debug log? > > >> On Mon, Sep 14, 2009 at 10:03 AM, HAUSa > > >> <[email protected]> wrote: > > >> > No... > > >> > On 13 sep, 23:53, Sid Bachtiar <[email protected]> wrote: > >> >> Did you get any error message? > > >> >> On Mon, Sep 14, 2009 at 9:44 AM, HAUSa > > >> >> <[email protected]> wrote: > > >> >> > I tried that, that was my "helas no difference" answer. > >> >> > But besides that, I also tried the '5' instead of 'rank=rank+1' > >> >> > update, but also that didn't work. > > >> >> > My code now: > >> >> > $oConnection = Propel::getConnection(); > > >> >> > $oSelectCriteria = new Criteria(); > > >> >> > $oUpdateCriteria = new Criteria(); > >> >> > $oUpdateCriteria->add(EstatePeer::RANK, '5'); > > >> >> > BasePeer::doUpdate($oSelectCriteria, $oUpdateCriteria, $oConnection); > > >> >> > On 13 sep, 23:35, Gábor Fási <[email protected]> wrote: > >> >> >> This criteria means: all records, that have a star as their ID. Try > >> >> >> Sid's modification, so an empty criteria, that means all records. > > >> >> >> On Sun, Sep 13, 2009 at 23:14, HAUSa > > >> >> >> <[email protected]> wrote: > >> >> >> > $oSelectCriteria->add(EstatePeer::ID, '*'); //all records > > >> >> -- > >> >> Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz > > >> -- > >> Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz > > -- > Blue Horn Ltd - System Developmenthttp://bluehorn.co.nz --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
