Perfect, good video link, thanks radhames! On Sep 9, 1:52 pm, radhames brito <rbri...@gmail.com> wrote: > use the requirement attribute in the routes and use friendly_id gem, > > http://railscasts.com/episodes/70-custom-routes > > this shows how the use requirement in routes , remember to put specific > routes on top and more generic routes below > > with frienly_id gem you just have to config.gem and add > > has_friendly_id :url in your model , the gem will take care of finding > the record and will put the given field in the url query string > > On Thu, Sep 9, 2010 at 6:14 AM, Creative Technologist < > > rich...@creativetechnologist.co.uk> wrote: > > Hi, > > > Could anyone help with this one. > > > I want to have two routes into my news stories for the show view, one > > by ID and the other by the URL of the story which is stored in the db. > > > I have two routes setup ... > > > map.connect 'itcontractormortgagenews/:id', :controller => > > 'posts', :action => 'show' > > map.connect 'itcontractormortgagenews/:url', :controller => > > 'posts', :action => 'show' > > > and I have edited my show method in the controller to ... > > > if params[:id].to_i > 0 > > �...@post = Post.find(params[:id]) > > else > > �...@post = Post.find_by_sql("select * from posts where URL = '" + > > params[:url] + "'").first > > end > > > The mapping by URL works fine but by ID not. I'm sure there is a > > better way to do this. > > > Thanks > > > Richard. > > > -- > > 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<rubyonrails-talk%2bunsubscr...@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.