Delete an entry from database, after user input

rubyonrails-talk
#1

Hi fellow RoR'ers,

I have a Rails app, where a user can subscribe and unsubscribe from a
mailinglist. To unsubscribe, the user can fill in their email address
in a form field.

But I have no idea how to delete the record from the database, using
the typed in data from the user. I've tried it with the following
code, but doesn't seem to work.

@email = Email.find(:all, :conditions => [ "mail = ?",
"%#{params[:mail]}%"])
@email.delete(:id)

Any ideas?

#2

@email = Email.find(:all, :conditions => [ "mail = ?",
"%#{params[:mail]}%"])
@email.delete(:id)

You don't need the % around that parameter. That's used for LIKE
queries. Try this:

@email = Email.find(:all, :conditions => [ "mail = ?", params[:mail]]

Steve

#3

Still doesn't seem to work.

The app doesn't give an error, but nothing gets deleted from the
database either.