Sql Script Doubt

Rails
1

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

2

On Oct 3, 2012, at 6:33 AM, BalaRaju V. wrote:

@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

3

hey thanks

On Wed, Oct 3, 2012 at 6:26 PM, Walter Lee D. [email protected]
wrote:

class SkillsController < ApplicationController

To unsubscribe from this group, send email to
[email protected].
For more options, visit https://groups.google.com/groups/opt_out.

–
నేను
కొంచం తపన,
కాస్త ఆసక్తి,
కొన్ని కలలు,
కాసిన్ని ఊహలు కలిపేస్తే
నేను
bala raju

4

On Oct 3, 2012, at 9:45 AM, BalaRaju V. wrote:

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