Tornado API Library - V12.30.08

z.dbFilterSQL Property

User defined filter query.

Product Version

All
[VisualBasic]
PublicPropertydbFilterSQLAsString
[C#]
publicstringdbFilterSQL{set;}

Property Value

X..dbFilterSQL = "Select * From products where [[Filter]]"

Note: Must include the [[Filter]] criteria tag to be stuffed by the user input data

QuickProp Keyword Abbreviation

fq

Remarks

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.

Example

<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>

See Also

z Class | Tornado Namespace | dbSQL | Special Topic - Filter