Unique indexes

I have a unique index on Channelnote.note.
In my controller, I go to save the Channelnote.
But, if the note portion already exists, it naturally throws an error.
How can I alleviate this, so that it only saves if the note is NOT
already in the table? Thanks, RVince

        cnote = Channelnote.new
  cnote.note = params['channelnotes']
  cnote.channel_id = @channel.id
  cnote.associate_id = current_associate.id
  g=cnote.save

begin
  cnote.save!
rescue
  flash[:notice] = 'channel note failed to save'
end

or you could check to see if it exists before trying to save it.

cn = Channelnote.find_by_note( params[:channelnotes] )
cnote.save unless cn

Greg Donald wrote:

� � � �cnote.channel_id = @channel.id
� � � �cnote.associate_id = current_associate.id
� � � �g=cnote.save

begin
  cnote.save!
rescue
  flash[:notice] = 'channel note failed to save'
end

or you could check to see if it exists before trying to save it.

cn = Channelnote.find_by_note( params[:channelnotes] )
cnote.save unless cn

Or put a validates_uniqueness_of in the app.

--
Greg Donald
http://destiney.com/

Best,

You could use find_or_create_by_note, too