Alphabetic letter based search

[dakshayini]

Hi,

i have list of alphabets from A to Z .if i click on any one letter that should give me all the name starting with that corresponding letter from the database and should be displayed in the same page.

if i use each letter as a link(link_to) i cant display them in the same page.

if i use link_to_remote i am not able to get the params value of the letter i.e...Which letter i clicked.. if anyone know about this plz give me a solution.

[improvcornartist]

You could try Rails AJAX support to send the database results to a div within the same page. Or you could try using a partial.

[dakshayini]

<%= javascript_include_tag "prototype" %>
<div class="element_links">
<% for char in 'A'..'Z' %>
<%= link_to_remote( "#{char}",
                         :update => "content",
                         :char => char,
                         :url =>{:action => :alp_search }) %> </li>
                         <% end %> 
                         <div id="content"></div>
                    <p>
<ul>

This is my rhtml

and my controller is

def live_search
     puts 'live_search'
           @classifieds = Course.find(:all,:conditions => ["lower(course_name)like ?","%" + params[:search].downcase+ "%"])
           puts @classifieds
           if params['search'].to_s.size < 1
           render :nothing => true
           else
                if @classifieds.size > 0
                   render :partial => 'display', :collection => @classifieds
                   else
                   render :text => "<li>No results found</li>", :layout => false
                   end
                end
              end

So as per the code if i click 'A' i should get all the courses which starts from 'A' from the database but am not able to get the params value of search.

In the place of link_to_remote if i use link i can get the correct result in the other page..but i want to display result in the same page..
is there is any way to do this...

[improvcornartist]

Try adding content to your content div, such as

<div id="content">
  <%= @content %>
</div>
 

Then, in your controller, set the content variable with the partial, like

def live_search
  #...code...
  @content = render_to_string(:partial => 'display', :collection => @classifieds)
 
  render :update do |page|
    page.replace_html 'content', @content
  end
end

This should then update the div with your partial using your data collection.