Totally new to RoR, have done Riding on Rails Revisited and the Getting started with Rails Tutorial. Plus I have read why''s poignant guide on ruby (very helpful guide btw, helped me understand a lot. After doing the cookbook2 tutorial, I''m redoing it attempting to modify it to my needs. I made a home controller (from the getting started with ruby on rails guide) and deleted my index from public. I setup my routes correctly and the new home page comes up fine. I have a few tables in my MYSQL created and populated and my ROR app talking to them. One of the tables with sample data has 20k + records, so I want to make a list box my home page that filters it. Had trouble finding list boxes in the API but some google searching gave me some good info (http://shiningthrough.co.uk/blog/show/6). Following that mini tutorial and the API docs on collection_select I tried creating a select box, whos option values are populated by my database, on my index.html.erb page. I am missing something really obvious as the page now generates an no methoddefined error on my collection_select line. <%= collection_select( :geog, :areaname, @geogs, :area, :areaname, {:prompt => true}) %> Heres my geogs_controller.rb that was created using scaffolding. class GeogsController < ApplicationController # GET /geogs # GET /geogs.xml def index @geogs = Geog.find(:all) respond_to do |format| format.html # index.html.erb format.xml { render :xml => @geogs } end end # GET /geogs/1 # GET /geogs/1.xml def show @geog = Geog.find(params[:id]) respond_to do |format| format.html # show.html.erb format.xml { render :xml => @geog } end end # GET /geogs/new # GET /geogs/new.xml def new @geog = Geog.new respond_to do |format| format.html # new.html.erb format.xml { render :xml => @geog } end end # GET /geogs/1/edit def edit @geog = Geog.find(params[:id]) end # POST /geogs # POST /geogs.xml def create @geog = Geog.new(params[:geog]) respond_to do |format| if @geog.save flash[:notice] = ''Geog was successfully created.'' format.html { redirect_to(@geog) } format.xml { render :xml => @geog, :status => :created, :location => @geog } else format.html { render :action => "new" } format.xml { render :xml => @geog.errors, :status => :unprocessable_entity } end end end # PUT /geogs/1 # PUT /geogs/1.xml def update @geog = Geog.find(params[:id]) respond_to do |format| if @geog.update_attributes(params[:geog]) flash[:notice] = ''Geog was successfully updated.'' format.html { redirect_to(@geog) } format.xml { head :ok } else format.html { render :action => "edit" } format.xml { render :xml => @geog.errors, :status => :unprocessable_entity } end end end # DELETE /geogs/1 # DELETE /geogs/1.xml def destroy @geog = Geog.find(params[:id]) @geog.destroy respond_to do |format| format.html { redirect_to(geogs_url) } format.xml { head :ok } end end end --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---