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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
