# OrderID CustomerID 1 10348 WANDK 2 10365 ANTON 3 10367 VAFFE 4 10375 HUNGC 5 10380 HUNGO 6 10390 ERNSH 7 10394 HUNGC 8 10400 EASTC 9 10405 LINOD 10 10415 HUNGC 11 10418 QUICK EmployeeID 4 OrderDate 12/8/1995 12:00:00 AM RequiredDate 1/5/1995 12:00:00 AM ShippedDate 12/16/1994 12:00:00 AM ShipVia 2 Freight 0.9 ShipName Die Wandernde Kuh ShipAddress Adenauerallee 900 ShipCity Stuttgart ShipRegion ShipPostalCode 70563 ShipCountry Germany [1 - 11 : 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?