RVince
October 7, 2009, 3:16pm
1
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
RVince
October 7, 2009, 3:50pm
2
On Wed, Oct 7, 2009 at 8:15 AM, RVince [email protected] 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
–
Greg D.
http://destiney.com/
RVince
October 7, 2009, 5:17pm
3
Greg D. wrote:
On Wed, Oct 7, 2009 at 8:15 AM, RVince [email protected] 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 D.
http://destiney.com/
Best,
Marnen Laibow-Koser
http://www.marnen.org
[email protected]
RVince
October 7, 2009, 6:29pm
4
You could use find_or_create_by_note, too
2009/10/7, Marnen Laibow-Koser [email protected] :
flash[:notice] = ‘channel note failed to save’
–
Posted via http://www.ruby-forum.com/ .
–
Von meinen Mobilgerät aus gesendet