Bean Software                                            Bean  Software Search Control

        Documentation
  Intro
  Properties and methods
  Tutorial
  Get it now
Support e-mail

 


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();