And I will log a vote, that once you get it figured out by looking at
test cases, you add the required samples to the book (using the 'edit'
feature) :)
On Oct 6, 2:00 pm, "Ryan McKillen" <[EMAIL PROTECTED]> wrote:
> Martin, thanks. That was a big help. I was working inside a foreach loop, so
> I imagine you saved me a big headache with the create() tip. This helped out
> on updating an individual record, but what about changing that field value
> to 0 for all records?
>
> teknoid, thanks as well for the link. I'll spend some time in there, but
> will still log a vote for a set of examples in the Cookbook.
>
> On Mon, Oct 6, 2008 at 1:33 PM, [EMAIL PROTECTED] <
>
> [EMAIL PROTECTED]> wrote:
>
> > Hi Ryan,
>
> > 1: Not that I am aware of. It is a very good idea for a page in the
> > cookbook, though.
>
> > 2: This is usually very simple. Sometimes you have to watch out
> > though.
> > Usually this is totally automatic.
>
> > $one = $this->ExampleModel->findById($id);
> > $one['ExampleModel']['example_field'] = 0;
> > $this->ExampleModel->save($one);
>
> > Cake will know to use update in most cases like in the example above.
> > Sometimes, though you will have to help out a little. Like when you
> > are looping a number of records and saving each in turn, you must call
> > create before each save to avoid saving over the same record each
> > time.
>
> > There is also sometimes call for these drastic measuers.
> > You may not always be sure wether insert of create should be used:
>
> > $one = $this->ExampleModel->findById($id);
>
> > if ( empty($one) ) {
> > $one = array('ExampleModel'=>array());
> > }
>
> > $one['ExampleModel']['example_field'] = 0;
>
> > $this->ExampleModel->create();
> > $this->ExampleModel->set($one);
> > $this->ExampleModel->save($one);
>
> > That is, I think, it. Some people prefer setting the id of a Model
> > before using set(). I have seen tests in the core using both methods
> > so I guess both work fine. When I have done similar saves I have not
> > found it necessary setting Model->id before using set(). It may depend
> > on circumstances I am not fully aware of.
>
> > /Martin
>
> > On Oct 6, 6:51 pm, Ryan <[EMAIL PROTECTED]> wrote:
> > > As a new Cake user, I am having a bit of trouble transitioning from
> > > writing my own MySQL queries, to letting Cake do the heavy lifting for
> > > me. I think I have SELECT and INSERT down, but am still struggling
> > > with UPDATE. Two questions:
>
> > > 1.) Is there a good resource I can refer to that shows examples of raw
> > > SQL with the cake equivalent? This would really help my learning.
>
> > > 2.) The specific issue I am having that prompted this thread... I've
> > > got a primary key id number for a record in a table, and for that
> > > record, I want to update change the value of a given field from 1 to
> > > 0. How can I perform that simple operation with a Cake query?
>
> > > Thanks
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
