Databases
StackOverflow2013
Postsdbo
POjquery autocomplete display the output string
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POjquery autocomplete display the output string
    primarykey
    data
    text
    <p>I want to have the script display each item on a list of value from a string of comma delimited set.</p> <p>ex. "one,two,three,four"</p> <p>On the autocomplete drop down, it should show:</p> <p>one two three four</p> <p>However, the current code, show a list of only single char. There should be an easy way to split that list up and display the word instead of char. My javascript is a little limited, if someone can figure it out for me, I would appreciated. thanks. I have been search around and know that you should be able to override the parse function but it has to be easier than that. Also, I am using a webservice to return the string and can be delimited by anything but it needs to show the word. </p> <p>If anyone knows the answer, I would appreciated...thanks</p> <pre><code> $("#CustomerID").autocomplete({ source: function(request, response) { $.ajax({ type: "POST", url: "/customer/search.asmx/findvalue", dataType: "json", data: { term: request.term }, error: function(xhr, textStatus, errorThrown) { alert('Error: ' + xhr.responseText); }, success: function(data) { response($.map(data, function(item) { return { label: item, value: item } })); } }); }, minLength: 2, select: function(event, ui) { alert('Select'); } }); </code></pre> <p>EDIT----------------------</p> <p>Thank you to the previous poster for help answering.</p> <p>It seems to be the nuances of the formatting or something.</p> <p>This works:</p> <pre><code>success: function (data) { response($.map(data, function (item) { return item.split(","); })); }, </code></pre> <p>Using this seems to just error out or does nothing:</p> <pre><code> success: function(data) { response(data.split(",")); } </code></pre> <p>I even tried this, it goes through but does not result in a drop down menu:</p> <pre><code>success: function (data) { response($.map(data, function (item) { response(item.split(",")); })); }, </code></pre> <p>The above seem to work and displays what I want, not sure if it's efficient. If someone wants to explain why? Not sure why in some case you would need a response() and/or a return inorder for the autocomplete to work....</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USwirble
    1. USwirble
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POjquery autocomplete display the output string
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POjquery autocomplete display the output string
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have been testing this with chrome and the above shows a filtered drop down menu correctly; however, with IE, it seems to error out. I am now baffled as to the solution???
      singulars
      1. POjquery autocomplete display the output string
      1. USwirble
    2. COThis fix my issue if you put it on top before the ajax call: jQuery.support.cors = true; Thanks to this post: http://stackoverflow.com/questions/5241088/jquery-call-to-webservice-returns-no-transport-error
      singulars
      1. POjquery autocomplete display the output string
      1. USwirble
    3. COI really think just doing `response(data.split(","));` should work. It assumes your data is in the format `"one,two,three,four,five"`. What exactly is the error you're seeing?
      singulars
      1. POjquery autocomplete display the output string
      1. USAndrew Whitaker
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload