Hi Marnen, the idea was having a selreferential table via parent_id or lft/rgt to haev children etc.. now my point of doubts was whether to make "each"top-level record (aka a category) root r to move it into a different table and mark there the type of that category..eg
categories: babysitting yard electrics category_types: service contractor job hope that makes it clearer. tom On Mon, Jan 11, 2010 at 12:33 PM, Marnen Laibow-Koser <li...@ruby-forum.com> wrote: > Tom Tom wrote: >> hi, i have a category and a category_type model, where category is >> selfreferential with parent_id. now, im not 100% sure whats the best >> way for later purposes in terms of search etc., > > awesome_nested_set, of course. :) > >> but my initial >> intention was the store the category_types_id only in the root (where >> parent_id == 0), but like i said, > > No, you didn't say. > >> how would i search through all >> children with a specific type of category_type? i mean i could read >> them into an array, but thats just wrong. >> should i store the category_type_id in each category? >> >> i hope that was not to unclear... ;-) > > It was. What exactly are you trying to do? > >> >> thx tom > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > mar...@marnen.org > -- > Posted via http://www.ruby-forum.com/. > > -- > 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.