similar to: ActiveRecord::StatementInvalid in BlogController#index

Something is getting lost here. def create @home = Team.find_by_user_id(current_user.id) for player in @home.players player.update_attribute(:game_id, @game.id) end end def show @players = Player.find_all_by_game_id(params[:id]) end view <%= @players.size %> # mistakenly equals zero Played with the console and everything should be working fine...

I have a form with contingent select boxes (the state is contingent on the country selected, so when the country selected changes, the state changes -- I am using the Carmen plugin for getting my state names and country names together, but not the functionality I am interested in achieving). Everything works fine except I cannot figure out how to amend my code such that: A. When the form is first

I can''t get my view to display the most recent parameters from an associated object in a view... here is a birds-eye of my app: I have two models, Ferms and Kinetics. Ferm has_many :kinetics, Kinetic belongs_to :ferm. Kinetic has the fields ferm_id, brix and temp. In my ferms/index view I have a table listing the attributes of each ferm instance. I would like to display the most recent

Looking for suggestions on following two queries. Query 1 ------------------------------ Are the two following lines of code different in Ruby / Rails ( in a *.html.erb) file. <% if @forms.count != 0 %> <!-- first code --> Vs. <% if @forms.count %> <!--second code --> @forms is an array of objects. Coming from "C" language development background, i thought

Howdy everyone. I am using modalbox which is very nice an easy to use. I have this for an edit for a company listing: <td><%= link_to(''Manage Companies'', {}, :onclick => ''Modalbox.show(\''/ companies/edit/#{company.id}\'', {width: 600}); return false;'') %></td> The link is not putting the company.id in it puts #{

Rails documentation gives examples of using option_groups_from_collection_for_select with two tables/objects. How could it be done with one? Example that almost works: I have a form to enter address from both the United States and Canada. It has the following: ====new.html.erb==== <%= select_tag( :state, option_groups_from_collection_for_select( State.countries, :country,

Hi In my app , a user can create a set of question then a table is dynamily created , in the database,to store the answers of the questions. the name of the table is answers_x (x is the id of the questionniare). Is it possible to dynamicly create a model, to handle the answer_x tables ?? I can''t manually create a model then restart the server.

Hi I have a strange problem, I am using the below code form_remote_tag :url => ''/abc/test'',:before => "return hello();", :update=>''test_categories'' ,:complete => "Element.hide(''spinner'')", :loading => "Element.show(''spinner'')" do I am using :before=> function to validate the

[~/kallori]# rake db:migrate (in /home/gm/kallori) no such file to load -- hmac-sha1 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' /home/gm/kallori/vendor/rails/activesupport/lib/active_support/ dependencies.rb:510:in `require''

Hi Hoping someone has had experience with this or can tell me where to start investigating. I''ve got a Rails app with Devise authentication running on a server cluster behind a load balancer, so requests to the website will alternately hit one server, or the other. My problem occurs when I try to register a new user. Everything goes fine, I get the confirmation email, I click the link,

Assuming you have Person that has_many :messages, what will it happen if it has 10000 messages? Will rails attempt to initialize @person.messages with 10000 rows from database? If that is the case, is combining finder_sql and counter_sql the common practice to avoid this? Bogdan _______________________________________________ Rails mailing list

I have a issue that I can''t seen to fix.. I search all over.. and a lot about how to work with legacy *table* names but nothing about *column* names... this will not work because of the hyphen: @vcards = Vcard.find(:all, :select => "collection-owner") this below will work but give me a lot of junk..!! @vcards = Vcard.find(:all, :select =>

Hi everyone, first post here in the forum. I''m usually in #rubyonrails on freenode. I''ve been thinking about the various types of caching, and I was wondering if its possible to have the server selectively send back data, instead sending nothing ''0'' if user has the newest data. My example is a presence monitor, and it seems like the logic is: - Rails caches

Hi, In my app pictures can be uploaded. I want to do two things to the pictures: 1- Add a watermark 2- Add an effect to the picture (colorize) I can do that manually with Gimp and then upload. But how could I make the application to that automatically? Any suggestions for plugins? Regards -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You

Hello, I''ve come across an issue that I''m sure is a bug when using after_create with a has_one association, but I''m not 100% certain if I''m missing something. This is pretty much exactly the code I''m using. Two simple classes (Account and Contact) and I create the contact after I create an account (via after_create). I''m not passing in a

Hi all I am new to Rails, and obviously I''m missing something, I''ll get straight to the question: A User has many operations (granted to her), each Operation is associated with an OperationType. Each Operation may be associated with more then one User. So the model goes like this: class User < ActiveRecord::Base has_and_belongs_to_many :operations

Hi guys, hoping someone can give me a pointer with this? I have a Javascript variable that I''m updating dynamically as a user interacts with the page. I want the user to be able to save it''s value at any time along with some text data in a pop-up form, so the best way I can think of is to pass it through the params hash without writing it into the form. I''m not totally

Hi i am getting following error ActiveRecord::StatementInvalid in Blog#index Showing app/views/blog/index.rhtml where line #10 raised: Mysql::Error: #42S22Unknown column ''posts.user_id'' in ''where clause'': SELECT * FROM posts WHERE (posts.user_id = 4) Extracted source (around line #10): 7: <div class="separator">&nbsp;</div> 8:

Under Rails 2.3.2 using a completely brand new project, I have 2 models: class Author < ActiveRecord::Base # name:string end class Book < ActiveRecord::Base # title:string belongs_to :author # author_id end And a simple test where i create a Book with an Author using the belongs_to and then update the foreign key directly: require ''test_helper'' class BookTest

Hello All, I''m a RoR newbiew, trying to experiment with Autocomplete, but I''m having some difficulties. When I start typing in my input box, instead of getting a nice drop down, the styling on my page is getting all out of wack (ie my background colours change, link styling changes, etc) and I''m not seeing any autcompletion data. Here are the steps I''ve taken