getWhereClause Method
Description:
This method is used to return SQL WHERE clause string based on
search terms and control properties. Method will corect user accidentally
mistakes or attempts to SQL injection. Search terms are represented by
Text property. To find more about how to use properties, look at the Properties
and methods section.
Data type: String
Default value: empty string
Example:
//
Let say that you have some SQL query, and your web site
visitor
String SQLQuery = "SELECT * FROM MyQuery";
// Now you use getWhereClause to get
complete query and
// and receive only required table rows
SQLQuery += SearchControl1.getWhereClause();
|