Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@ language="Javascript" %>
- <script language="javascript" runat="server" src='json2.js'></script>
- <script language="javascript" runat="server">
- if (typeof String.prototype.trim != 'function') {
- String.prototype.trim = function() {
- return this.replace(/^\s\s*/, '').replace(/\s\s*$/, '');
- };
- }
- (function() {
- // http://msdn.microsoft.com/en-us/library/windows/desktop/ms675318(v=vs.85).aspx
- // http://msdn.microsoft.com/en-us/library/windows/desktop/ms678273(v=vs.85).aspx
- // http://msdn.microsoft.com/en-us/library/windows/desktop/ms675946(v=vs.85).aspx
- ado = {
- // data types
- variant : 12,
- char : 129,
- varChar : 200,
- single : 4, // DBTYPE_R4
- date : 133, // DBTYPE_DBDATE
- time : 134, // DBTYPE_DBTIME
- // parameter directions
- input : 1,
- output : 2,
- inputOutput : 3,
- returnVal : 4,
- directionUnknown : 0,
- // command types
- cmdUnspecified : -1,
- cmdText : 1,
- cmdTable : 2,
- cmdStoredProc : 4,
- cmdUnknown : 8,
- cmdFile : 256,
- cmdTableDirect : 512
- };
- queryDb = function(like) {
- var rs, result = [], cmd, query, param,
- conn = new ActiveXObject("ADODB.Connection");
- conn.ConnectionString =
- 'Provider=SQLOLEDB.1;' +
- 'Integrated Security=SSPI;' +
- 'Persist Security Info=False;' +
- 'Initial Catalog=AVWKS2008LT;' +
- 'Data Source=.\\SQLEXPRESS';
- conn.Open();
- cmd = new ActiveXObject("ADODB.Command");
- cmd.ActiveConnection = conn;
- cmd.CommandType = ado.cmdText;
- query = 'SELECT distinct Lastname as lname ' +
- 'FROM SalesLT.Customer ';
- if (like !== null) {
- query += 'WHERE LastName like ? ';
- like += '%';
- param = cmd.CreateParameter("", ado.varChar, ado.input, like.length, like);
- cmd.Parameters.Append(param);
- }
- query += 'ORDER BY lname ';
- cmd.CommandText = query;
- rs = cmd.Execute(); // typeof ADODB.Recordset
- while(!rs.EOF) {
- // retrieve the 0th field
- result.push(rs.Fields(0).Value.trim());
- rs.MoveNext();
- }
- conn.Close();
- return result;
- };
- }());
- try {
- // jquery UI autocomplete requires the search term to be 'term'
- var t = Request.QueryString('term') + '',
- token = (t == 'undefined') ? null:t,
- r = queryDb(token);
- Response.Write(JSON.stringify(r));
- }
- catch(e) {
- var error = {error: e.message};
- Response.Write(JSON.stringify(error));
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement