Join and Refer In Tables

Rails
1

OK: I’ve read through this a million times and am still not getting it
right. I have two tables (posts and authors), with a one(author) to
many(posts) relationship, and the keys are not named id but user_name in
one and screen_name in the other. I’m trying to join the tables in the
model, then pull all fields from posts and one additional field from
author, bio. Here is my stuff:

in models/post.rb

class Post < ActiveRecord::Base
has_one :authors, :primary_key => :user_name, :foreign_key =>
:screen_name
end

in controllers/posts.rb

@postswithauthors = Post.find(:all, :limit => 20, :conditions =>“posted
between '”+@starthour+"’ and ‘"+@endhour+"’ and
searchterm=’"+searchterm+"’", :order => “posted DESC”, :include =>
:authors )

in the view/posts.rb

for x in @postswithauthors
puts x.user_name
puts x.posted
puts x.post
puts x.authors.bio
end

Every time I run this I get something like invalid method “bio”. Been
over and over all of the association docs and can’t find my error.
Please help.

Thanks…Chris

2

“has_one” should only be used in one-to-one relationships.
This is a one-to-many relationship, so use “belongs_to :author,
:foreign_key => :screen_name” in the model, “:include => :author” in the
controller, and “x.author.bio” in the view.