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 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.
