Hi all,
I have a table structure with me not having an id column. When I try to
delete the row i get an error ‘Unknown column “table.id”’. Can i do the
action with any other method than destroy/delete? Or with the same
method and any other conditions?
Thanks.
Sainaba.
sainaba sainu wrote:
Hi all,
I have a table structure with me not having an id column. When I try to
delete the row i get an error ‘Unknown column “table.id”’. Can i do the
action with any other method than destroy/delete? Or with the same
method and any other conditions?
Thanks.
Sainaba.
Check out the destroy_all method. It may well suit your needs.
~Ben
sainaba sainu wrote:
Hi all,
I have a table structure with me not having an id column. When I try to
delete the row i get an error ‘Unknown column “table.id”’. Can i do the
action with any other method than destroy/delete? Or with the same
method and any other conditions?
Thanks.
Sainaba.
Change the line that looks up your record in the delete function to use
your own primary key.
instead of something like
@item = Item.find(params[:id])
it will be something like
@item = Item.find(params[:name])
or
@item = Item.find_by_name(paranms[:name])
Depends on how you have your table set up.
_Kevin
Hi
it worked with
Customer.delete_all " customer_id = " + @company_id.to_s
Thanks to all ,
Sainaba.
Check out the destroy_all method. It may well suit your needs.
ActiveRecord::Base
~Ben
You may also use delete_all