title: Using asp + ajax + json achieve autocomplete
body: <p>My table has six fields, name is:Code,Name,Model,Specif,Brand,Unit.I want at the 'Code' Input tab to enter the first letter, it can ajax request database through JSON returned 10 records,when I select one,Autofill 6 labels.
  I have not done before similar projects.I need a complete example, including background processing
  sql:</p>
  
  <pre><code>set rs =server.createobject("ADODB.RecordSet")
  sql="select * from goods where goods_stop=0"
  if request("search_code")&lt;&gt;"" then
  sql=sql&amp;" and (goods_bar='"&amp;request("search_code")&amp;"' or goods_code like '%"&amp;request("search_code")&amp;"%' or goods_name like '%"&amp;request("search_code")&amp;"%' or goods_letter like '%"&amp;request("search_code")&amp;"%' or goods_short like '%"&amp;request("search_code")&amp;"%')"
  end if
  </code></pre>
  
  <p>now I can use lacal json</p>