Ofcourse. As I said here above:
When I create a new record, the last piece of code ($this->setRank(1))
is executed, all new records have '1' as rank value.
That makes it strange that the query is not executed, at it is in the
same if statement...
Anyone who knows a solution for this? How is it possible that it seems
like nothing is executed?
On 14 sep, 12:14, Sid Bachtiar <sid.bacht...@gmail.com> wrote:
> You realized that your update code only get executed upon saving new
> record? It's because of: "if($this->isNew())"
>
> On Mon, Sep 14, 2009 at 10:10 PM, HAUSa
>
>
>
> <jeroen_heeft_behoefte_aan_r...@hotmail.com> wrote:
>
> > 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 <sid.bacht...@gmail.com> 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
>
> >> <jeroen_heeft_behoefte_aan_r...@hotmail.com> 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 <sid.bacht...@gmail.com> wrote:
> >> >> What's the SQL query in the debug log?
>
> >> >> On Mon, Sep 14, 2009 at 10:03 AM, HAUSa
>
> >> >> <jeroen_heeft_behoefte_aan_r...@hotmail.com> wrote:
>
> >> >> > No...
>
> >> >> > On 13 sep, 23:53, Sid Bachtiar <sid.bacht...@gmail.com> wrote:
> >> >> >> Did you get any error message?
>
> >> >> >> On Mon, Sep 14, 2009 at 9:44 AM, HAUSa
>
> >> >> >> <jeroen_heeft_behoefte_aan_r...@hotmail.com> 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 <maerl...@gmail.com> 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
>
> >> >> >> >> <jeroen_heeft_behoefte_aan_r...@hotmail.com> 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
>
> --
> 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 symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
