关于Jquery的自动完成插件实例 AutoComplete，当数据源换成从动态的时就不起作用了

复制代码 [/code]ASP静态数据源 [code]<% str = "[{'JobName':' Group Leader, Product Management CN and APA'},{'JobName':' Manufacturing Engineer-EM, Nanjing, S&C, ACS'},{'JobName':' secured loan head'},{'JobName':'?单元负责人 - 大理'}]" response.Write str %>

ASP动态数据源

复制代码 <% sql = "select top 4 * from (select distinct(jobname) from jobs where isdeleted=0 and jobname<>'') as a" dim str str = "[" set rs = server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,1 i=1 if rs.recordcount>0 then     do while not rs.eof         if i=1 then             str = str&"{'JobName':'"&replace(rs("jobname"),"'","")&"'}"         else             str = str&",{'JobName':'"&replace(replace(replace(rs("jobname"),"'",""),"""",""),"","")&"'}"         end if         i=i+1     rs.movenext     loop end if rs.close set rs = nothing conn.close set conn = nothing str = str&"]" 'Response.CharSet = "GB2312" response.Write str %>

这两段代码的输出结果是一模一样的，可在利用jquery-autocomplete插件调用时，前者很完美，后者无反应！
jquery代码如下：

复制代码 <script type="text/javascript">         /*==========用户自定义方法==========*/         //职位数据         var jobList;         //autocomplete选项         var options = {             minChars: 1,             max: 500,             width: 250,             scroll: true,             height: 500,             matchContains: true,             formatItem: function(row, rowNum, rowCount, searchItem)             {                 return rowNum + "/" + rowCount + ": \"" + row.JobName ;             },             formatMatch: function(row, rowNum, rowCount)             {                 return row.JobName;             },             formatResult: function(row, rowNum, rowCount)             {                 return row.JobName;             }                     };         //autocomplete初始化函数         function initAutoComplete(data)         {             jobList = data;             $("#inputCityName").autocomplete(jobList, options);                                      }         /*==========加载时执行的语句==========*/         $(function()         {             //$.getJSON(url, null, initAutoComplete)               $.ajax({                    url:"test4.asp?d="+Math.random(),                    dataType:'json',                    success:initAutoComplete                    });         });             </script>

望高手们帮忙分析分析！

居然无人问津

我的问题已经解决，动态出来的数据不成功是因为编码的问题，某条记录的jobname字段的开头在数据库中显示为空格，可response出来之后确实问号，不论你在sql中replace还是在页面中trim都不管用，显示结果依然带着问号，真奇怪，无奈之下只好在数据库中将该记录的该字段UPDATE了一下，还好目前数据库中只有这一条记录这么隔路！

但是新的问题有出现了
autocomplete的效率是否欠佳，我在动态页select top 400的话，自动提示功能还没问题，但过了四百就出不来了
希望用个这个插件的人进来讨论一下，怎么改进效率？或者各位是用什么更有效率的插件的？