On 7 July 2010 21:46, RubyonRails_newbie <craigwest...@gmail.com> wrote: > ah yes... :-) > > It is in the log: > > 0mSELECT * FROM `blogcomments` ORDER BY created_at desc LIMIT 1 > > So if it is in the log, why isn't it ordering the comments?
What is it that seems to not be sorted? @blogcomment should be sorted but you have done nothing to sort blogposts.comments. Have you tried breaking in after the find to inspect the data as suggested by another post? By the way could you avoid top posting please, it is easier to follow the thread if replies are inserted into the previous mail. Colin > > On 7 July, 21:42, Colin Law <clan...@googlemail.com> wrote: >> On 7 July 2010 21:25, RubyonRails_newbie <craigwest...@gmail.com> wrote: >> >> > Hmm, >> >> > for some reason the log isn't showing the order by clause: >> >> > Rendering blogposts/show >> > [4;35;1mBlogcomment Load (0.4ms) [0m [0mSELECT * FROM >> > `blogcomments` WHERE (`blogcomments`.blogpost_id = 17) [0m >> > [4;36;1mBlogcomment Columns (1.3ms) [0m [0;1mSHOW FIELDS FROM >> > `blogcomments` [0m >> > Completed in 133ms (View: 54, DB: 8) | 200 OK [http://localhost/ >> > blogposts/17] >> >> You are looking at the wrong query. That is the one for >> Blogpost.find(params[:id]).... >> The one you have sorted is >> @blogcomment = Blogcomment.find(:all, :order => "created_at desc") >> which should appear above that one. >> You have not specified a sort in the Blogpost query. >> >> Colin >> >> >> >> >> >> > On 7 July, 21:15, Jason Michael <chewman...@gmail.com> wrote: >> >> take a gander at the development.log - find that sql query that is >> >> being generated by that find. Try that query on your DBMS and see if >> >> it returns the blogposts in the order you expect. >> >> >> On Wed, Jul 7, 2010 at 3:07 PM, RubyonRails_newbie >> >> >> <craigwest...@gmail.com> wrote: >> >> > Hi everyone, >> >> >> > I have an app in which I am attempting to add a blog to. >> >> >> > I have the blog and commenting system working. It has 2 tables: >> >> >> > 1: blogposts (stores the actual blog topics/stories) >> >> > 2: blogcomments (stores the comments for each blog created) >> >> >> > so - I've been playing around with the layout, as I think having the >> >> > most recent posts at the top would be more logical. >> >> >> > Below is the code I have which creates the comment: (and attempts to >> >> > order the comments accordingly) >> >> >> > def comment >> >> > @blogcomment = Blogcomment.find(:all, :order => "created_at >> >> > desc") >> >> >> > �...@user = User.find(session[:user_id]) >> >> >> > Blogpost.find(params[:id]).blogcomments.create(params[:comment]) >> >> > flash[:notice] = "Added your comment" >> >> > redirect_to :action => "show", :id => params[:id] >> >> >> > end >> >> >> > Any ideas? >> >> >> > Thanks for reading... >> >> >> > -- >> >> > You received this message because you are subscribed to the Google >> >> > Groups "Ruby on Rails: Talk" group. >> >> > To post to this group, send email to rubyonrails-t...@googlegroups.com. >> >> > To unsubscribe from this group, send email to >> >> > rubyonrails-talk+unsubscr...@googlegroups.com. >> >> > For more options, visit this group >> >> > athttp://groups.google.com/group/rubyonrails-talk?hl=en. >> >> > -- >> > You received this message because you are subscribed to the Google Groups >> > "Ruby on Rails: Talk" group. >> > To post to this group, send email to rubyonrails-t...@googlegroups.com. >> > To unsubscribe from this group, send email to >> > rubyonrails-talk+unsubscr...@googlegroups.com. >> > For more options, visit this group >> > athttp://groups.google.com/group/rubyonrails-talk?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-t...@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
