Posts HABTM tags, so I have my routes for those setup as:
map.resources :tags do |tag|
tag.resources :posts
end
So that will give me a route to use, such as:
tag_posts GET /tags/:tag_id/posts(.:format)
{:action=>“index”, :controller=>“posts”}
For the view, I find posts like this from the Posts controller: @tag = Tag.find(params[:tag_id]) @posts = @tag.posts.recently_published
Everything works as expected except the created_at attribute for my
posts. When I print the created at timestamp in the view, it is
actually printing the created timestamp for the tag.
<%= post.created_at.strftime(‘%B %d, %Y’) %> gives me the created at
timestamp for the tag, not the post.
Everything works as expected except the created_at attribute for my
posts. When I print the created at timestamp in the view, it is
actually printing the created timestamp for the tag.
<%= post.created_at.strftime(‘%B %d, %Y’) %> gives me the created at
timestamp for the tag, not the post.
Can someone help me fix this issue? Thank you!
By default when you access a habtm relationship like this rails does
select * from posts
inner join post_tags on …
…
So if the join table in the middle has an attribute with the same name
as an attribute from joined table(s) they will collide. You can avoid
this by adding :select => ‘posts.*’ to your habtm declaration
Thanks for the replies. Unfortunately, neither of the solutions
worked. I tried each on their own with no luck, and then I combined
the two suggestions and still no luck. Here is what I have for the
named scope in my Post model as of now:
Processing PostsController#index (for ::1 at 2010-01-03 11:13:21)
[GET]
Parameters: {“tag_id”=>“1”, “action”=>“index”,
“controller”=>“posts”}
Tag Load (0.2ms) SELECT * FROM “tags” WHERE (“tags”.“id” = 1)
Rendering template within layouts/application
Rendering posts/index
SQL (0.2ms) SELECT count() AS count_all FROM “posts” INNER JOIN
“posts_tags” ON “posts”.id = “posts_tags”.post_id WHERE
(((“posts”.“published” = ‘t’) AND (“posts_tags”.tag_id = 1 )) AND
(“posts_tags”.tag_id = 1 ))
Post Load (0.4ms) SELECT * FROM “posts” INNER JOIN “posts_tags” ON
“posts”.id = “posts_tags”.post_id WHERE (“posts_tags”.tag_id = 1 ) AND
((“posts”.“published” = ‘t’) AND (“posts_tags”.tag_id = 1 )) ORDER BY
posts.created_at DESC
Category Load (0.2ms) SELECT * FROM “categories” WHERE
(“categories”.“id” = 2)
Tag Load (0.2ms) SELECT * FROM “tags” INNER JOIN “posts_tags” ON
“tags”.id = “posts_tags”.tag_id WHERE (“posts_tags”.post_id = 2 )
Category Load (0.2ms) SELECT * FROM “categories” WHERE
(“categories”.“id” = 1)
Tag Load (0.4ms) SELECT * FROM “tags” INNER JOIN “posts_tags” ON
“tags”.id = “posts_tags”.tag_id WHERE (“posts_tags”.post_id = 1 )
Category Load (0.5ms) SELECT * FROM “categories” ORDER BY name ASC
LIMIT 5
SQL (0.1ms) SELECT count() AS count_all FROM “categories”
Post Load (0.3ms) SELECT posts.* FROM “posts” WHERE
(“posts”.“published” = ‘t’) ORDER BY posts.created_at DESC LIMIT 5
Tag Load (0.3ms) SELECT * FROM “tags” ORDER BY name ASC LIMIT 5
SQL (0.1ms) SELECT count(*) AS count_all FROM “tags”
Rendered layouts/_side_navigation (5.8ms)
Completed in 86ms (View: 20, DB: 3) | 200 OK [http://localhost/tags/1/
posts]
Everything works as expected except the created_at attribute for my
posts. When I print the created at timestamp in the view, it is
actually printing the created timestamp for the tag.
<%= post.created_at.strftime(‘%B %d, %Y’) %> gives me the created at
timestamp for the tag, not the post.
Post Load (0.4ms) SELECT * FROM “posts” INNER JOIN “posts_tags” ON
“posts”.id = “posts_tags”.post_id WHERE (“posts_tags”.tag_id = 1 ) AND
((“posts”.“published” = ‘t’) AND (“posts_tags”.tag_id = 1 )) ORDER BY
posts.created_at DESC
This is probably the query at fault - you want to put the :select
option on the association itself, not the named scope
