Relationships quickie

Rails
1

i have a project.

the project has a status_id.

i have a statuses table with id’s and names.

the project model includes “has_one :status”

the status model includes “has_many :projects”

in my projects index page instead of project.status_id displaying 1, 2
or 3 i want to have the statuses.name accosiated with that id.

i tied putting <%= project.status.name %> but i get the error,

SQLite3::SQLException: no such column: statuses.project_id: SELECT *
FROM “statuses” WHERE (“statuses”.project_id = 6) LIMIT 1

it appears to be looking in statuses table for project_id not the other
way around.

can anyone clear this up for me?

cheers,

dave

2

Yeah, that is the way that the associations work.

if a model ‘has_one’ of something, then the something has the foreign
key
relationship back.

It is described fairly nicely here:

Simon

On Wed, 07 Jan 2009 20:13:41 +0900, Dave S.

3

On Wed, Jan 7, 2009 at 12:13 PM, Dave S.
[email protected] wrote:

i have a project.

the project has a status_id.

i have a statuses table with id’s and names.

the project model includes “has_one :status”

try belongs_to :status

4

Franz S. wrote:

On Wed, Jan 7, 2009 at 12:13 PM, Dave S.
[email protected] wrote:

i have a project.

the project has a status_id.

i have a statuses table with id’s and names.

the project model includes “has_one :status”

try belongs_to :status

i understand now! cheers guys