On Oct 3, 2012, at 6:33 AM, BalaRaju Vankala wrote: > Hello everyone, > > I am having a doubt regarding sql in rails .. i kept the autocomplete feature > in my application .. but the problem is there should not be repitition in the > term in the text field... This is what i done .... > > > class SkillsController < ApplicationController > > def index > term = (params[:term].split(",").last || "").strip > > @skills = Skill.order(:name).where('name LIKE?', "%#{term}%") > > render :json => @skills.map(&:name) > end > > Can anyone please help.... ASAP >
I'm usually against answering ASAP questions, but have you tried adding .uniq at the end of your @skills query? Walter -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.