# OrderID CustomerID 12 10420 WELLI 13 10421 QUEDE 14 10422 FRANS 15 10423 GOURL 16 10424 MEREP 17 10425 LAMAI 18 10426 GALED 19 10429 HUNGO 20 10430 ERNSH 21 10431 BOTTM 22 10433 PRINI EmployeeID 3 OrderDate 2/21/1995 12:00:00 AM RequiredDate 3/21/1995 12:00:00 AM ShippedDate 2/27/1995 12:00:00 AM ShipVia 1 Freight 44.12 ShipName Wellington Importadora ShipAddress Rua do Mercado, 12 ShipCity Resende ShipRegion SP ShipPostalCode 08737-363 ShipCountry Brazil [12 - 22 : 633]

Basic but not so simple search

<script language="VB" runat="server"> Sub Page_Load(Src As Object, E As EventArgs) Dim Se As New Tornado.z Dim Qp As String = "U=2| M=ty=dh!sys=t| PS=11| S=plain| D=Nwind| Q=Orders|" Qp &= "Gdf=0,1| Fmhf=0,1| TH=Ti=Search Filter| ni=b5,search| ff=0,1" Se.dbQP = Qp Se.dbDebug = "FilterAction" Se.ASPdbNET() End Sub </script>

This is ASP-db's the most primitive search setup but this is not trivial at all. Try to search for records with OrderID between 10300 and 10400 or search for CustomerID containing a 'T' or 'R' ? Try input '>10300 and <10400' and also try 'T or R'. This is the built-in compound search capabilities of ASP-db. Can you do this with your development tool?