# RoR Listbox help

**URL:** <https://www.ruby-forum.com/t/ror-listbox-help/154835>\
**Category:** Rails\
**Created:** [December 4, 2008, 9:58am UTC](https://www.ruby-forum.com/t/ror-listbox-help/154835 "2008-12-04T09:58:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![casper\_the\_ghost](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/58956e/32.png) [@casper\_the\_ghost](https://www.ruby-forum.com/u/casper_the_ghost)\
**Post date:** [December 4, 2008, 9:58am UTC](https://www.ruby-forum.com/t/ror-listbox-help/154835/1 "2008-12-04T09:58:55Z")

</div>

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](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