Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I reckon the problem is that you don't add the autocompletion to the new element. You don't actually need livequery. Therefore, changing your second block of code like so:</p> <pre><code>$('#AddProduct').click(function() { var adding = $('&lt;div class="column width50"&gt;&lt;input type="text" id="PRODUCTNAME" name="PRODUCTNAME" value="" class="width98" /&gt;&lt;input type="hidden" id="PRODUCTID" name="PRODUCTID" /&gt;&lt;input type="hidden" id="UNITPRICE" name="UNITPRICE" /&gt;&lt;small&gt;Search Products&lt;/small&gt;&lt;/div&gt;&lt;div class="column width20"&gt;&lt;input type="text" id="UNITPRICE" name="UNITPRICE" value="" class="width98" /&gt;&lt;small&gt;Quantity&lt;/small&gt;&lt;/div&gt;&lt;div class="column width30"&gt;&lt;span class="prices"&gt;Unit Price:&lt;br /&gt;Total Price:&lt;/span&gt;&lt;/div&gt;'); $('#OrderProducts').append(adding); adding.find("#PRODUCTNAME").autocomplete("orders.cs.asp?Process=ListProducts", { selectFirst: false }).result(function(event, data, formatted) { if (data) { adding.find("#PRICE").val(data[1]); adding.find("#ID").val(data[2]); adding.find("#UNITPRICE").val(data[1]); adding.find("#PRODUCTID").val(data[2]); } }); return false; }); </code></pre> <p>I reckon that should do it, barring one or two small tweaks here and there.</p> <p>Just two comments on how you are handling your form elements by the way - your method results in more than one element possessing the same ID, which is invalid (although it will work) - perhaps alter it to select based on classes instead. Secondly, you used the html function to set the value of the inputs - not even sure that works, so in my proposed solution I replaced the html calls with val.</p>
    singulars
    1. This table or related slice is empty.
    1. POjquery livequery not fixing autosuggest?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKazar
    1. USKazar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POjquery livequery not fixing autosuggest?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you so much! I am just little confused with IDs. Its been always working, why do you say I should change them to classes?
      singulars
      1. PO
      1. USEfe
    2. COIt will work (as in the DOM will still behave ok), however, having more than one element with the same ID will cause XHTML validation to fail. The point of an ID is to identify an individual element, rather than a group. Since you are adding many elements that have the same use or 'class', it does make more sense to get elements by their class. Something else I just realised by the way is that you will end up with duplicate input names with your current method (so only the last set of inputs will be visible server side).
      singulars
      1. PO
      1. USKazar
    3. COThan I will go with class. Oh and reason I used .html, not .val is because I want to them both in input field and in span (unit price for example). That, I plan to handle by adding +(i++)+ to name fields.
      singulars
      1. PO
      1. USEfe
 

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