# OrderID CustomerID 1 10277 MORGK 2 10329 SPLIR 3 10337 FRANK 4 10338 OLDWO 5 10348 WANDK 6 10349 SPLIR 7 10353 PICCO 8 10356 WANDK 9 10357 LILAS 10 10358 LAMAI 11 10360 BLONP EmployeeID 2 OrderDate 9/9/1994 12:00:00 AM RequiredDate 10/7/1994 12:00:00 AM ShippedDate 9/13/1994 12:00:00 AM ShipVia 3 Freight 125.77 ShipName Morgenstern Gesundkost ShipAddress Heerstr. 22 ShipCity Leipzig ShipRegion ShipPostalCode 04179 ShipCountry Germany [1 - 11 : 710]

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?