User defined filter query.
X..dbFilterSQL = "Select * From products where [[Filter]]"
Note: Must include the [[Filter]] criteria tag to be stuffed by the user input data
This is a tool to have total control of the filter criteria. You can control the filtering criteria and only allow user to use the [[Filter]] part of the SQL.
<script language="VB" runat="server"> Sub Page_Load(Src As Object, E As EventArgs) Dim x As New Tornado.z x.dbQP = "u=1|D=Nwind|Ni=b5,Filter,ResetFilter|gdf=0,1,2" x.dbSQL = "Select * from Orders" x.dbFilterSQL = "Select * from Orders where OrderId > 10260 and [[Filter]]" x.dbDebug = "ActiveSQL" x.ASPdbNET() End Sub </script>