similar to: Rails MySQL query

I get this error ... NoMethodError in StoreController#index undefined method `salable_items'' for Product:Class and here is my store_controller.rb ... class StoreController < ApplicationController def index @products = Product.salable_items end def self.salable_items find(:all, :conditions => "date_available <= now()", :order => "date_available

I''m new to Ruby and to fairly new to programming. I''ve been working through the "Agile Web Development with Rails" book, and I''m stuck on page 73 of the print version. The book''s online errata directed me here with my questions. I''m running Ruby 1.8.3 with MySQL 4.1.8 on OSX 10.3.9. I''ve created the scaffolding for Admin controller

I am actually following the instructions/code snippets from "Agile Web Development with Rails" and got as far as page 73 where I did ruby script/generate controller Store index, then edited store_controller.rb to class StoreController < ApplicationController def index @products = Product.salable_items end end and product.rb to: def self.salable_items find(:all,

Hi there, I?m having difficulties reading the content of some rows in my database. Tried to use some of the code at page 221 in the pickaxe, but didn?t make it work. The SQL query works fine directly against the database. mysql> select id, count, company from users where name = "martin"; +----+-------+------------+ | id | count | company | +----+-------+------------+ | 1 |

In the agile/rails tutorial book the following construct is added to products.rb. def self.salable_items find( :all, :conditions => "date_available <= now()", :order => "date_available desc") end Now, I wish to extend :conditions => to exclude products that have a nil value for the price. I have tried different syntax

Hi, I?m adding numbers to a database from fields in a form, but I want to include some information I have in a variable not generated in this form. The variable user.company exists in the same class as create(), and I want to include the value of this variable when I add new numbers to the database. The form looks like this: <p><label

Hi I''m very keen to learn RoR and have been following the Agile Web Development with Rails book (first edition). However, I''ve come across a problem which has had me stumped for days now. After following the instructions up to page 85 I have tried testing the code thus far, as suggested, by adding an item to the cart. But I am getting the following error: --

--- "David W. Tamkin" <dattier@panix.com> wrote: > Three styles of T-shirts plus hooded sweatshirts, but no FLAC > jackets? seems like slam dunk doesn't it :) but for this run I'm trying to use the same screens on all items to keep the cost down, which rules out the logo on the front of a zippered jacket. still looking for a suitable one where logo can go on the

Hi, I am just learing Rails and I am going through the Agile Web Development with Rails book. I am receiving: NoMethodError in Store#add_to_cart undefined method `add_product'' for #<StoreController:0x3764d80> RAILS_ROOT: ./script/../config/.. Application Trace | Framework Trace | Full Trace #{RAILS_ROOT}/app/controllers/store_controller.rb:12:in `add_to_cart''

since I've been getting a lot of requests, we're planning to do a run of FLAC shirts at cost if there is enough real demand. there's also a slogan contest for what goes on the back. for details see http://flac.sourceforge.net/tshirt.html check it out! Josh __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile

Hi, I?m having some problems collecting the content of some forms. This is whats in list.rhtml: <%= form_tag :action => ''send_message'' %> From: <%= text_field ''message'', ''from''%> <br>Message: <%= text_area ''message'', ''text'', :rows => 6 %> <tr> <td></td>

Hi, I have a page where I can add new users to the database, but it only sees whats in the name and passord field. add_user.rhtml: <%= form_tag %> <%= form_tag :action => ''add_user'' %> <td>User name:</td> <td><%= text_field("user", "name") %></td> </tr> <tr> <td>Password:</td>

To make file_column work I have to copy my local variable back to an instance variables like this: <% for product in @products @product = product %> <div class="catalogentry"> <%= image_tag url_for_file_column(''product'', ''image_url'') %></p> This is needed because file_column specifically looks for the instance

In Agile Web Development with Rails, I get this error when adding a product to my cart: uninitialized constant Cart ... Application Trace: /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.2.5/lib/ active_support/dependencies.rb:200:in `const_missing'' ./public/../config/../app/controllers/store_controller.rb:21:in `find_cart''

Hi, I?m having problems building and installing the mysql gem on a Fedora Core 4 (Linux) server. # gem install mysql Attempting local installation of ''mysql'' Local gem file not found: mysql*.gem Attempting remote installation of ''mysql'' Building native extensions. This could take a while... can''t find header files for ruby. ERROR: While executing

I''m working my way through the book Agile Web Development with Rails, and I am in the section where the book has me creating a display_cart method and the associated view. When I copied the code from the book into the view, it threw this error. If anyone could give me some hints where I should be looking I''d appreciate it. NoMethodError in Store#display_cart Showing

I was successful in reaching page 184 in the book "Agile Web Development with Rails" 3rd edition and while running the website with PostGreSQL as the backend, the power went down. The PostGreSQL database contents look OK and so do the source code files I was editing. But whenever I click on any "Add To Cart" button in the catalog, I get the following information in the

Hi, I have edge frozen on vendor, and getting these errors logged: Expected ../config/../app/controllers/store_controller.rb to define StoreController ../config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/dependencies.rb:177:in `load_missing_constant'' ../config/../vendor/rails/activerecord/lib/../../activesupport/lib/active_support/dependencies.rb:275:in

I have a cisco 7940 with the following sip.conf config: [Desk1.1] type=friend secret=****** defaultip=192.168.1.14 insecure=no mailbox=102 callerid="Desk1.1" qualify=500 canreinvite=no context=extensions host=dynamic group=2 I do not get message waiting indicator (mwi) on this phone. Is the another .conf file invilved in configuring this function other than the mailbox=xxx in the

Can I use xapian for a search like: 'title' has the phrase "dinner jacket" AND 'color' == BLACK AND 'state' == MA AND 'size' == XL What about faceted search? Thanks