locked
RE: Autocomplete in Webmatrix RRS feed

  • Question

  • User-371148474 posted

    Hello,

    I did effect the autocomplete script as described by mikesdotnetting... I like the script because of its ease of use. Moreso, its needed for bogus findig.

    One thing I need help with seriously is, How do I allow the autocomplete pick terms and autocompletes and returns nearest result containing the input parameter?

    For example, my label list from the SQL has Lallana, Anthem, Danger.

    Mikesdotnetting tutorial only allows autocomplete beginning from the full list result. like Lall would complete to Lallana.. But i am interested in taking it further by searching for "an" and the following results should echo out "Lallana, Anthem, Danger" because they all have "an" in them, irrespective of its point.

    How do I achieve this extentiability

    Saturday, June 7, 2014 6:47 PM

Answers

  • User-1416423428 posted

    You can use LIKE '%string%' in your SQL statement, or use SQL Full Text indexing for your search.   :) I answered this on your other thread. (but you marked your own post as the answer). 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, June 8, 2014 2:34 AM