Delete row without th eid field

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.

http://api.rubyonrails.org/classes/ActiveRecord/Base.html

~Ben

You may also use delete_all :smiley:

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs