Ok, so I've created my position thing for every tutorial. However now I need to know how I can setup render :partial to order the tutorials using the position, and then if two (or more) tutorials have the same position, then go back and check there id, and order the ones with the same position by id.
This is how I'm currently displaying the tutorials: <%= render :partial => @category.tutorials %> Does anyone have any ideas how I can adapt this? Thanks In Advance, Joe On May 2, 9:18 pm, Joe <j...@dev-hq.co.uk> wrote: > Ok, So it seems that this whole tutorial ordering thing seems to be > the best way to go (thanks to philip anyway for giving me the code to > do it with ids if I wanted to); > The problem is I'm really a complete noob in RoR. I know how to create > migrations, however creating a "position" variable i which they were > independent to the category the tutorials were in; I have absolutely > no idea how to do that. And you talk about writing methods, I also do > not know where these methods would be created (inside a controller > perhaps?). > > Any help with this task would be kindly appriciated, > > Thanks In Advance, > > Joe > > On May 2, 7:18 pm, Philip Hallstrom <phi...@pjkh.com> wrote: > > > > > >> The tutorials are then displayed in order of there id (auto- > > >> incrementing) in their categories show method. > > >> The thing is, I want to create a link that goes from one tutorial > > >> (with an id of 10 for example) to the next tutorial in that category > > >> (which might not have an id of 11, as I create different tutorials at > > >> different times, therefore creating different ids for two tutorials > > >> seemingly next to eachother in order). > > > >> Obviously I know I will need something like this: > > >> <%= link_to 'Next lesson....', %> > > > >> but I just don't know how I can manage it.. > > > >> By the way, every tutorial has a: category_id to determain which > > >> category they are in (this is an integer). > > > > If I were you, i'd create a position column on tutorials, which > > > determines the ordering of tutorials for a category (ordering by id > > > might seem the simplest but stops you from ever reordering tutorials. > > > Given a tutorial, the next one is the first one in the same category > > > whose position is greater than the current ones (you could write a > > > next_tutorial method on tutorial). There's a plugin called > > > acts_as_list that you might find helpful maintaining the position > > > column. If you're hell bent on ordering by id then it's as if id is > > > your position column > > > > Fred > > > I agree with Fred as it allows you to easily re-order the tutorials if > > you want to, but if you don't... then... > > > next_tutorial = Tutorial.find(:conditions => ["id > ? AND category_id > > = ?", current_tutorial_id, current_category_id], :order => > > 'id', :limit => 1) > > > prev_tutorial = Tutorial.find(:conditions => ["id < ? AND category_id > > = ?", current_tutorial_id, current_category_id], :order => 'id > > DESC', :limit => 1) > > > -- > > 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.
