Search Filter

#OrderIDCustomerID
1 10430 ERNSH
2 10436 BLONP
3 10438 TOMSP
4 10440 SAVEA
5 10441 OLDWO
6 10443 REGGC
7 10444 BERGS
8 10445 BERGS
9 10446 TOMSP
10 10447 RICAR
11 10448 RANCH
EmployeeID4
OrderDate3/2/1995 12:00:00 AM
RequiredDate3/16/1995 12:00:00 AM
ShippedDate3/6/1995 12:00:00 AM
ShipVia1
Freight458.78
ShipNameErnst Handel
ShipAddressKirchgasse 6
ShipCityGraz
ShipRegion
ShipPostalCode8010
ShipCountryAustria

bottom next goreload Popup Filter

[1 - 11 : 572]

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?


Send comments on this topic.
Copyright (c) 1998-2006 ASP-db