read does not work!

[ghost]

Created by Erol Elcan, 26th Oct 2012. (originally Lighthouse ticket #42):

---

Hi,

If you have a table which contains a primary key that named different than 'id' read() is not working.
I hope you will understand my bad English.

Thanks

[ghost]

29th Oct 2012, Owen Smithyman said:

---

Holy crap, it's true! Erol, thank you so much. I've been going crazy for the last two hours trying to figure out why I'm not getting anything in my view. There are no errors either. It's just as though you had an array with all the expected keys but no data for any of them. Extremely frustrating!

This doesn't work (using a primary key named 'jobnumber'):
public function view($jobnumber) {
$this->Job->jobnumber = $jobnumber;
$this->set('job', $this->Job->read());
}

This works (after changing primary key name from 'jobnumber' to 'id' in phpMyAdmin):
public function view($id) {
$this->Job->id = $id;
$this->set('job', $this->Job->read());
}

As you can see, this is the code straight from the blog example.

[ghost]

30th Oct 2012, Erol Elcan said:

---

No worrys.
Happy to know you have fixed up.

[AD7six]

Closing as this is a (rather common) misunderstanding and not related to this repo.