similar to: acts_as_list with 2 fields in the scope

Hi, If I have a db table categories - id - name - parent_id - position is it alright to have the Category model act_as_tree and for each level act_as_list? class Category < ActiveRecord::Base acts_as_tree :order => :position acts_as_list :scope => :parent_id end Thanks, Peter

Hello all, I''m having trouble using acts_as_list with acts_as_tree to order the "children". I''ve found a few old posts on the web that seem to indicate that this once worked. class Whatever < ActiveRecord::Base acts_as_tree :order => :position acts_as_list :scope => :parent_id Although the ''position'' field is being populated, it appears

I have a model "Childmodel" that belongs_to two other models "Parent1" and "Parent2". "Parent1" "has_many :childmodels, :order => :positionp1" and "Parent2" "has_many :childmodels, :order => :positionp2". i.e. The child is independently positioned within each of its parents. This works fine and gets me the useful

I just switched from using the standard "id" column into using my own primary key and generating my own unique id for each record. But, this breaks acts_as_tree. Because my new primary key is not an integer, it breaks the SQL query as follows: StatementInvalid in PagesController#create --------------------------------------------------------------------------------------

I need an ordered (sortable tree) and I just was thinking if somehting like this is possible: class Item< ActiveRecord::Base acts_as_tree :order => "position" acts_as_list :scope => ''parent_id = #{self.id}'' end For my understanding mixing of two acts_as should be p?ssible, at least in this case, right? Unfortunatly the :scope is not working, I am not

I am creating forum application which needs usage of acts_as_list or acts_as_tree or acts_as_nested_set. I am unable to decide among these. please could some one recommend from their experience? -- Posted via http://www.ruby-forum.com/.

Hello Rails experts, Need your help in following issue with the acts_as_list and single table inheritence Code details : http://pastie.org/1214846 Hello Rails experts, Need your help in following issue with the acts_as_list and single table inheritence Code details : http://pastie.org/1214846 But here I need create those entries with the scope on Relater only and not on RelaterFeed or

So I have the following model class Topic < ActiveRecord::Base belongs_to :topic has_many :topics, :order => :position acts_as_tree :order => :position acts_as_list :scope => :topic_id end that I use for a site''s navigation. Everything (list, create, edit, even the drag&drop sort) works fine, except the destroy function, which the vanilla version def destroy

It looks like I am missing something obvious. ActiveRecord is generating _really_ bad SQL for this configuration, and I can''t quite figure it out. I''ve instrumented ActiveRecord enough to localize the problem somewhat, and generally by this time I would have a good idea of what I was missing because it''s all in the source. It appears that something in

Hello, I''ve tried to set up a class with acts_as_list with a scope argument that restricts a list to records with the same foreign key. For example : database : CREATE TABLE `families` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '''', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; INSERT INTO

For some reason, rails is generating this SQL: SELECT FIRST 1 * FROM questions WHERE (parent_id IS NULL) ORDER BY position DESC 1. There is no column named position referenced in my code. 2. POSITION is a reserved word in SQL92. It is the name of a string function that returns the offset of one string within another. I believe that this is a bug in Rails. Either position should be

I am creating a database for movies (films) and television shows (shows) that will have has_and_belongs_to_many relationships with the pictures table. CREATE TABLE screenshots ( id serial NOT NULL, filename character varying NOT NULL, content_type character varying NOT NULL, primary key (id) ); CREATE TABLE films ( id serial NOT NULL, name character varying NOT NULL,

Hi there, the acts_as_tree API says that I can set a counter cache and that it will automatically increment the "children_count" column. I did that but when I create a new page it asks for a "pages_count" column instead. Here is the relevant part of page.rb model: class Page < ActiveRecord::Base acts_as_tree :order => :position, :counter_cache => true

Hi, I have a link table with a location field, here is the code I wrote to reorder the rows # move_up action in links controller def move_up current_link = Link.find(params[:id]) current_link.location -= 1 current_link.save same_link = Link.find_by_location(current_link.location) same_link.location += 1 same_link.save redirect_to :action =>

I''m using UUIDs as keys into my database (stored as CHAR(36)), and additionally have a model that is set to act as a list. In this scenario, I believe that the queries that Acts::List generate are invalid, caused by IDs being strings rather than integers. System info: Rails: 1.1.4 MySQL: 4.0.26 This is the failing query: mysql> SELECT * FROM children WHERE (parent_id =

Hi, I have the following data imported from a csv file user_id site_id name 1 1 11 februari 2 1 11 redbook 3 1 11 tips 7 3 6 sleep 8 3 6 monitoring 9 3 6 alarm Which I would like to merge/combine into user_id site_id name 1 1 11 februari,

I know R has a steep learning curve, but from where I stand the slope looks like a sheer cliff. I'm pawing through the available docs and have come across examples which come close to what I want but are proving difficult for me to modify for my use. Calculating simple group means is fairly straight forward: data(PlantGrowth) attach(PlantGrowth) stack(mean(unstack(PlantGrowth)))

I was up late last night trying to find the cause of this, but I''m stumped. I have this relatively simple controller to load up a bio. It''s basicly id, name, desc, type (I use STI). class BioController < ApplicationController layout ''layouts/singlepanel'' def index @bio = Bio.find(:all, :conditions => [''site_id = ?'',

Check it out y''all: http://rafb.net/p/NJg5U147.html (pastie was down) I''m trying to make a tree which belongs_to another model, where you can have sections or items as children, and sections can have sections or items as well. Moreover, any siblings should be sortable. For instance: Root - Section 1 - - Item A - - Item B - Item C - Section 2 - - Item D - - Section 3 - - - Item

So I seem to be having an issue with trying to install acts_as_list in rails 2.2.2? I have downloaded the files from: http://github.com/rails/acts_as_list/tree/master I have put the files in the vendor/plugins folder the files are as follows: vendor/plugins/acts_as_list/init.rb vendor/plugins/acts_as_list/lib/active_record/acts/list.rb vendor/plugins/acts_as_list/test/list_test.rb