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
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
hey thanks On Wed, Oct 3, 2012 at 6:26 PM, Walter Lee Davis <waltd-HQgmohHLjDZWk0Htik3J/w@public.gmane.org> wrote:> > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > > >-- నేను కొంచం తపన, కాస్త ఆసక్తి, కొన్ని కలలు, కాసిన్ని ఊహలు కలిపేస్తే నేను bala raju -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
On Oct 3, 2012, at 9:45 AM, BalaRaju Vankala wrote:> hey thanks > > On Wed, Oct 3, 2012 at 6:26 PM, Walter Lee Davis <waltd-HQgmohHLjDZWk0Htik3J/w@public.gmane.org> wrote: > > 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?Glad it helped, but doesn''t this solution point back to a problem with your model? If Skills are a separate model, why are their names allowed to be duplicates? Names should be enforced at the model level to be globally unique, that way a result in this picker will point unequivocally to a single object. After all, you do want the results for a search to include all the different skills that include the substring from the progressive search -- that''s how this should work. Walter> > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- > నేను > కొంచం తపన, > కాస్త ఆసక్తి, > కొన్ని కలలు, > కాసిన్ని ఊహలు కలిపేస్తే > నేను > bala raju > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.