link_to query mysql for list

[Jerry Jones]

I have a web app that I want to make a link. I have a link_to that
will show the entire list of an inventory table, but I want another
link that will select only items of a certain name.
Here is my show all link
<%= link_to 'View Jewelry', {:controller => "inventory_item", :action
=> "list"} %>

I am unable to find a reference/example to show me how to do this. I
am new, please be gentle with me. =)

 

[Keynan Pratt]

use the rails forum for ror questions
<%= link_to 'View Jewelry', {:controller => "inventory_item", :action =>
"list"} %>

becomes

<%= link_to 'View Jewelry', {:controller => "inventory_item", :action =>
"list", :name = 'some_name'} %>

and in the controller you need to say if there is a name provided find
:all, :conditions => ['name = ?', params[:name]]

 

[Rick DeNatale]

<%= link_to 'View Jewelry', {:controller => "inventory_item", :action =>
"list", :name = 'some_name'} %>

actually

<%= link_to 'View Jewelry', {:controller => "inventory_item", :action
=> "list", :name => 'some_name'} %>

and you can drop those brackets so:

<%= link_to 'View Jewelry', :controller => "inventory_item", :action
=> "list", :name => 'some_name' %>