An And/Or Filter is a convenient method of providing powerful search filtering to users without writing an abundance of code. An and/or keyword filter is created with a column list and a search phrase. The filter parses the phrase using locale-specific keywords to produce a user-driven search.
<cfscript> // get the datasource ds = request.DataFaucet.getDatasource(); // create a select statement stmt = ds.getSelect("*","tblForumMessage msg"); // filter by the user's search phrase stmt.andOrFilter("subject,message,authorName",form.searchPhrase); // get the results query = stmt.execute(); </cfscript>
The statement object also provides an and/or collection filter for use in creating "advanced search" forms. These filters behave similarly to the collection filter although they don't have either the comparison or like property.
<cfset stmt.andOrCollectionFilter(form) />