similar to: .find conditions when multiple objects returned

Hi Just curious if anyone can explain why using a dynamic find fails to work with << operator I have standard habtm relationship class User < ActiveRecord::Base has_and_belongs_to_many :roles Now when I assign a Role via << after saving the new User I get wierd behaviour but only when using the dynamic version of find i.e @user = User.new(p) if @user.save #

Hi Chris, Yesterday you kindly submitted an answer to my question on modelling many to many relationships. I''ve briefly tried the proposed solution but so far with no luck. Before I get too involved - I''d like to know if mapping three way :join_tables is "legal" in a Rails sense. I only ask since you put (untested) in your mail and I can''t find any docs on

Hi, I have a user model and a privilege model. They have the has_and_belongs_to_many relationship. Here are the model defs: class User < ActiveRecord::Base belongs_to :status has_and_belongs_to_many :privileges end class Privilege < ActiveRecord::Base has_and_belongs_to_many :users end Now I have a migration script to create the join table and populate a few users with some

I have two classes Person and Job defined as follows: class Person < ActiveRecord::Base :has_and_belongs_to_many jobs def add_job(job_name) job = Job.find_by_name(job_name) # See if this job exists if job.nil? # If this job doesn''t exist job = Job.new # Create a new job job.name = job_name #

Chris, Finally got time to fully play with your suggestions. Had to re-code a bit of stuff but the concept works - just like a bought one :~). Many thanks for the solution, Kind Regards, Eric. For those curious - here''s what it was about; On Monday 02 January 2006 02:10, Eric Sloane tried to type something like: > Hi, > I''m trying to figure the most efficient way to

the scenario... three tables, thusly: widgets ------- id widget_color_id widget_style_id widget_colors ------------- id color widget_style ------------ id style the data: widgets ------- 1 2 1 2 1 3 3 3 2 widget_colors ------------- 1 blue 2 red 3 green widget_styles ------------- 1 smooth 2 round 3 broken so, putting the associations together, we have in widgets: 1 red smooth 2 blue

I''ve just been bodyslammed by a problem with has_and_belongs_to_many - as far as I can tell, if it doesn''t appear at the top of other relationship definitions it doesn''t seem to work right. For example: class Artist < ActiveRecord::Base has_and_belongs_to_many :genres has_many :albums has_many :videos has_many :cds has_many :collections end ..works fine

Hi, looking to see if I''m on the right track here... we''re selling widgets to customers, but there are a number of different type of widgets and each different type of widget has a number of parameters that the customer can specify, in effect each customer orders widget''s customised in ways particular to that specific order. We use STI to store each different widget

Hi, I am trying to perform a query with ActiveRecord that I want to put into a Rails application later. For now I just wrote it within a plain old Ruby script for easier testing. I am working with an existing database so I had to map some foreign keys myself. As you can see from the models below, the database has a structure of Prospectlists <=habtm=> Contacts <=habtm=> Accounts

Hi to all, I''m needing some help here ... I want to do an extension on a has_and_belongs_to_many to build a custom add method to the association. i have a table locations that has a many-to-many association with a tags tabel using a locations_tags table. i want to add a method to the Location has_and_belongs_to_many association so that i can do something like this on the location

Good Friday Everyone :-). These are my models: Problem -> has_and_belongs_to_many :tags Tag -> has_and_belongs_to_many :problems Now if a tag does not exist and I create it and associate it to the problem it works self.tags << Tag.create(:name => tag) But if I have the tag already in the DB and just want to link it to another problem it does not really like me. I do it

Given the following.. Foo has_many :bars Bar has_many ::widgets Widget has_many :gadgets Gadget has_many :parts All of the following are now possible... @foo.bars @bar.widgets @part.gadget.widget.bar.foo However, I can''t just do the opposite of that last one... @foo.bars.widgets.gadgets.parts and get a full list of every Part associated with @foo. I know there''s several

I''d like to always add a condition to any version of "find" (e.g. Thing.find(), Thing.find_by_name(), Thing.find_by_whatever) so that in addition to whatever conditions are set, an additional condition is set :conditions=>"user_id=#{current_user.id}" I''d like to make sure that a user only sees/edits/creates entries in the database that have the user_id

Hi, I posted this message on the StatET-user board last week, but it looks like a ghost-town... I have a bad feeling that there is some code in the plug-in which doesn't work well with my environment, but if I am lucky, maybe other users have worked around this problem somehow - I am hoping that my setup is the issue. Note: very similar StatET setups on 32-bit XP Pro and Vista run

I''m working on some schema for a new project that we''ll be doing in rails (our first rails project!). A recurring structure we are seeing is the desire to define an ordering any way we wish, so ''acts_as_list'' comes to the rescue. But, the ''position'' column seems to need to belong in the join table to make sense. For example, we have

Hi, I am trying to learn to use RoR by making a simple social networking example. Given a user id, I am trying to make a query that finds all of the group that user belongs to but also rank the groups by one of the groups'' parameter like group.size. Pretend group.size is a number from 1-10 and is precalculated. Can I do this is one query? Here are the relationships I set up: class

Hi, I'm trying to use StatEt IDE for Eclipse as my R editor, but I'm completely lost. I've read all I could find online, made apparently all I had to do (installing rj, configuraing StatEt, etc.) but still cannot make R running. Below is the error log file. Thank you so much for assistance. Matteo !ENTRY de.walware.statet.r.console.ui 1 0 2011-12-05 16:21:51.355 !MESSAGE

Hi there, I''m fairly new to RSpec, and DataMapper and I''m trying to write a controller spec for an index action that will include DM query chaining. Here is a very simplified version of the Controller#index I''m working on def index @widgets = Widget.all(:order => [ :name.asc ]) if params[:alpha] @widgets = @widgets.by_alpha(params[:alpha]) elsif

Dear R-Devel list members I'm facing as problem already known and linked to the use of getGraphicsEvent(prompt = "Waiting for input", ???????????????? onMouseDown = NULL, onMouseMove = NULL, ???????????????? onMouseUp = NULL, onKeybd = NULL, ???????????????? onIdle = NULL, ???????????????? consolePrompt = prompt) setGraphicsEventHandlers(which = dev.cur(), ...)

I was able to create a has_and_belongs_to_many relationship for my app, but now I''m not too sure how to write queries for it. Basically, I have a table ''courses'' that has_and_belongs_to_many ''categories'' and vice versa So I''m trying to figure out how I would find only the courses that belong to a category that I specify. Let''s