<%@ LANGUAGE="VBSCRIPT" %> Rico LiveGrid Plus-Example 3 <% sqltext="select OrderID,CustomerID,ShipName,ShipCity,ShipCountry,OrderDate,ShippedDate,year(OrderDate),year(ShippedDate) from orders order by OrderID" session.contents("ex3")=sqltext %>
This LiveGrid demonstrates how filters can be applied as the user types. Filtering is performed on the server -- responsiveness will vary with the speed of the server and the speed of the network. Case-sensitivity in the text boxes will depend on database settings. Note the "saveColumnInfo" option - filter settings are saved in a cookie and restored when the user returns to the page.
  // filterUI='t' --> text box
  // filterUI='s' --> select list
  var grid_options = {
    frozenColumns:  1,
    FilterLocation: -1,     // put filter on a new header row
    saveColumnInfo: {width:true, filter:true, sort:true},
    columnSpecs:  [,,{filterUI:'t',width:150},
                   {filterUI:'t',width:100}, {filterUI:'s',width:100},
                   {type:'date',filterUI:'s',filterCol:7,width:90},
                   {type:'date',filterUI:'s',filterCol:8,width:90}]
  };

 

ID ID Shipment Date
Order Customer Name City Country Order Ship