You have the answer since 5 days !

Have a look at that : http://snippets.symfony-project.org/snippet/50

Looks like you have two criterias : 1 to specify how to find records to
update, and 2 to define what you change.

Alexandre


In your case :

$selectCriteria = new Criteria();
$updateCriteria = new Criteria();

$selectCriteria->add(QuestionsPeer::ID,$questionId);

$updateCriteria->add(QuestionsPeer::QUESTION,$updatedQuestion);
$updateCriteria->add(QuestionsPeer::OPTION1,$updatedOption1);
$updateCriteria->add(QuestionsPeer::OPTION2,$updatedOption2);
$updateCriteria->add(QuestionsPeer::OPTION3,$updatedOption3);
$updateCriteria->add(QuestionsPeer::OPTION4,$updatedOption4);

QuestionsPeer::doUpdate($selectCriteria, $updateCriteria);


It's not obsolete, as you said before, I've checked in Propel 1.2, 1.3 and
1.4, it's always the same way !



2009/12/12 Parijat Kalia <kaliapari...@gmail.com>

>
>
> Guys, I have an update query in criteria, which is not working, I am not
> sure why, all the data that is being fed has been cross checked and is
> present, the fields are correct as well, so here is the query:
>  $d = new Criteria();
>       $d->add(QuestionsPeer::ID,$questionId);
>       $d->add(QuestionsPeer::QUESTION,$updatedQuestion);
>       $d->add(QuestionsPeer::OPTION1,$updatedOption1);
>       $d->add(QuestionsPeer::OPTION2,$updatedOption2);
>       $d->add(QuestionsPeer::OPTION3,$updatedOption3);
>       $d->add(QuestionsPeer::OPTION4,$updatedOption4);
>       QuestionsPeer::doUpdate($d);
>
>
> The above is in a loop (if method is post then) and it does get inside the
> loop, so not sure why the above query is not being updated.
> the first statement is to basically retrieve the object by the primary key!
> Thanks
>
>  --
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to symfony-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en.
>



-- 
Alexandre Salomé
http://alexandre-salome.fr

--

You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-us...@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.


Reply via email to