Ruby on Rails

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-talk@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@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-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.