Dynamic Select Box

Iw wrote:

I am experiencing problems retrieving information from the related drop
downs.
I can save information in the database (i.e. state_id and city_id are
getting saved in the Address table).

However on the Address's edit/update screen, the information from the
first "State" drop down is getting retrieved
properly but nothing is getting displayed in the second drop down -
"City".

I am using observe fields to retrieve data for the second drop down.
Please advise how to prepopulate information for the second drop down
based on the "id" stored in the database on Edits screens.

Thanks in advance for your help!

I

Ramanan wrote:
> Kevin Olbrich wrote:
>>>Ramanan
>>>
>>>
>>>--
>>>Posted via http://www.ruby-forum.com/.
>>>_______________________________________________
>>>Rails mailing list
>>>Rails@lists.rubyonrails.org
>>>http://lists.rubyonrails.org/mailman/listinfo/rails
>>
>> Take a look at this...
>>
>> http://www.sciwerks.com/blog/2006/07/07/updating-select-controls-with-ajax/
>>
>> _Kevin
>> www.sciwerks.com
>
>
> I have a working code where there are only 2 select boxes i.e.
> populating city when state is selected. I am having issues with
> populating locality based on selected city. Working with 2 dynamic
> select is straight forward. Working with more than 2 dynamic/cascading
> select box is a real issue.
>
> Thx. for your help

--
Posted via http://www.ruby-forum.com/.

You'd have to give us a bit more information about how you are
populating your select in the first place.

_Kevin

Iw wrote:

Here is relevant code:
The "city" in the second dropdown is not getting selected in Edit
screen.

Thank you so much for you help!
------------------------------
_form.rhtml

  <%= collection_select(:address, "state_id", State.find(:all), :id,
:state) %>
  <p id="address_city_container"><%= render :partial => 'select_city'
%></p>

          <%= observe_field("address_state_id",
                  :frequency => 0.25,
                  :update => "address_city_container",
                  :url => {:controller => 'address', :action =>
:filtered_city_select},
                  :with => "'state_id=' + value")%>
<% --------
  - address_controller.rb

def filtered_city_select

   @cities = City.find_all_by_state_id(@params["state_id"])
    render :partial => 'select_cities'
end

def edit
   @address = Address.find(params[:id])
   @states = State.find_all
   @cities = City.find(:all, :conditions =>[ "state_id = ?",
@address.state_id])

end

%>

------
partial _select_cities.rhtml

<% if @cities %>
<select name="address[city_id]" id="address_city_id">
     <option value="">-- Select City --</option>
   <%=
     options_from_collection_for_select(@cities, "id", "city")
  %>
</select>
<% end %>

--
Posted via http://www.ruby-forum.com/.

Couple of points.
1. if you set the frequency of your observer to 0, it should fire off
whenever the value changes, and not every 0.25 seconds.

2. check your log files to see if you are getting errors thrown by the
filtered_city_select method

3. Don't use '@params', it's deprecated.

Does it work at all?

_Kevin