similar to: Finding by inclusion in nested set

For some queries it is complicated to express them directly in SQL. Even more so when they are not hand-written, but generated from something the user entered. Say, the user wants to search for person records where the name contains some string. Now, while the Rails model may have a name attribute, the database table does not. There the name is decomposed into title, firstname, lastname and

When I redefine a method like this class Klass alias_method :method_without_addition, :method def method_with_addition ... method_without_addition ... end alias_method :method, :method_with_addition end I get into trouble in the development environment. As these definitions are executed again for each request, the second time around method_without_addition is actually the

Dear All, I have imported an HTML document to R (called tables) and wish to select certain pieces of it for processing. The first few lines of the object appear as follows: > tables [[1]] <table id="fs-table" class="gf-table rgt"> <thead> <tr><th class="lm lft nwp"> In Millions of USD (except for per share items) </th> <th

Dear R-help I am wondering if somebody wrote some code to convert an adjacency list model into a nested set model. In principal I want to do the same as John Celko mentioned it here with SQL: http://groups.google.co.uk/groups?hl=en&lr=lang_en&selm=8j0n05%24n31%241 %40nnrp1.deja.com Assume you have a tree structure like this Albert / \ /

I moved from acts_as_tree to acts_as_nested_set because I need the all_children method. I''ve seen an alternative way to add this method to acts_as_tree here: http://www.chuckvose.com/articles/2006/05/24/recursive-children But I''d prefer to use the more efficient way of acts_as_nested_set (and not to have to revert to my old code). Anyway, here''s my issue: if I

I''m no friend of paging, but I have to somehow deal with lists of potentially large numbers of objects. The Rico LiveGrid[*] at first blush seems attractive, but has some major drawbacks. It doesn''t work with Safari/Konqueror, not yet anyway. It can only handle fixed-size tables and requires that widths, including column widths, are hand-crafted. I''m looking for a

Hi, I''m trying to get act_as_nested_set working, and I''m puzzled. I googled the following http://codefetch.com/cache?url=http://media.pragprog.com/titles/rails/code/r ails-code.tgz <http://codefetch.com/cache?url=http://media.pragprog.com/titles/rails/code/ rails-code.tgz&path=rails-code/ar/acts_as_nested_set.rb&lang=ruby&qy=ruby>

Hi, has anyone successfully used the acts_as_threaded plugin with postgresql? I''m using rails 1.0 and ruby 1.8.4 on linux. Following the screencast on http://www.railtie.net/articles/2006/02/05/rails-acts_as_threaded-plugin , I got to where we''re ready to create our first post, having made the changes to controllers/posts_controller.rb, views/posts/_form.rhtml,

Is it possible to put conditions relative to the current instance in has_many''s :conditions? For example, in a forum app: class Post < ActiveRecord::Base belongs_to :topic has_many :self_and_descendants, :class_name => "Post", :order => "lft", :conditions => "topic_id = #{topic_id} AND (lft BETWEEN #{lft} AND #{rgt})" end With the

Hello, I am using acts_as_nested_set. My problem is that the columns "lft" and "rgt" get the value 0 if I create a new entity. If I delete an entity I get negative values (-1, -2, -3) - but for all entities. Is there anything missing? Is there any example for "acts_as_nested_set" in the web? -- Posted via http://www.ruby-forum.com/.

I''m trying to enhance acts_as_nested_set. Well actually I already have, but I''ve done a hack up job of it. I would like to contribute these enhancements back, but I need a little help. I''m a complete newbie to this stuff. The only thing I new before coming into this project was vanilla HTML. So over the course of two weeks I''ve picked up Ruby, Rails, MySQL,

Wondering about using the acts_as_nested for a model but concerned about the performance overhead of having to rewrite the table each time and entry is added or removed(and locking it while it''s happening or risking data integrity probs). Wasn''t really familiar with the structure so did a little reading up on it, and one solution to this seems to spreading the table out, so

hello guys, I have following structure of the table, where I store items of tree: | id | int(11) | NO | PRI | NULL | auto_increment | | user_id | int(11) | YES | | NULL | | | parent_id | int(11) | YES | | NULL | | | lft | int(11) | YES | | NULL | | | rgt | int(11) | YES

Hi Guys, when i upgraded my rails 2.3.4 to 3.0 my betternestedset is not working. It was working fine in the older version. This is my controller def new cat = Category.new cat.text=''test'' cat.save cat.move_to_child_of(Category.find_by_id(1)) #26 redirect_to :action => ''index'' end It gives me this error : "You cannot move a

I''d like to run the FastCGI as a different user than the Apache2 server (www-data on Debian). I take it this is possible in some way with suExec2, but so far I haven''t figured out how to do it. Michael -- Michael Schuerig Life is just as deadly mailto:michael-q5aiKMLteq4b1SvskN2V4Q@public.gmane.org As it looks

I have several tables for enumerations. They all have the same content: id, name, position. I''d like to avoid the tedious work of defining a class for each one explicitly. Not least, in order to avoid clutter in the model directory. Here''s what I''ve come up with: class EnumRecord < ActiveRecord::Base def self.define_enums(*enums) enums.each do |spec|

Somewhere between 0.13.1 and the current SVN version the :overwrite_params option to url_for (and related methods) went missing. I can''t tell whether this was deliberate or by mistake, and I have no idea how to get the same functionality in some other way either. Michael -- Michael Schuerig Life is what happens

- introduce local variables (shortcuts for frequently used <dom>->grant_table) - adjust first parameter of mapcount() - drop lock acquisition from gnttab_get_version() - remove hard tabs and adjust formatting Signed-off-by: Jan Beulich <jbeulich@suse.com> Tested-by: Andrew Thomas <andrew.thomas@oracle.com> --- a/xen/common/grant_table.c +++ b/xen/common/grant_table.c @@

No, not a question, but a few suggestions. I take it that everyone serious about using Prototype & Co. already has Christophe''s (Porteneuve) Prototype and Script.aculo.us book. Apart from that, I''d like to point out two new, library-agnostic books: Cameron Adams and several others The Art & Science of JavaScript Sitepoint 2008 http://www.sitepoint.com/books/jsdesign1/

In prototype/scriptaculous there are currently two different approaches to munging the class attribute of HTML elements. Scriptaculous has Element.Class which recently moved from util.js into effects.js. Prototype has Element.ClassNames and several convenience functions around it. In the past I''ve grown fond of Element.Class, but I''m perfectly willing to use