<cffunction name="searchTestimonials"
output="false"
access="public"
returntype="struct"
hint="Returns total count and recordset based on search criteria">
<cfargument name="SearchCrit"
required="true"
type="struct"
hint="Search criteria, usually passed in from the URL scope" />
<cfset var StartRow = "" />
<cfset var EndRow = "" />
<cfset var retStruct = StructNew() />
<cfparam name="Arguments.SearchCrit.Name" type="string" default="" />
<cfparam name="Arguments.SearchCrit.Testimony" type="string" default="" />
<cfparam name="Arguments.SearchCrit.Active" type="numeric" default="1" />
<cfparam name="Arguments.SearchCrit.pg" type="numeric" default="1" />
<cfparam name="Arguments.SearchCrit.RecordsPerPage" type="numeric" default="30" />
<cfparam name="Arguments.SearchCrit.OrderBy" type="string" default="stamp" />
<cfparam name="Arguments.SearchCrit.OrderDirection" type="string" default="DESC" />
<!--- derive start and end rows --->
<cfset StartRow = ((Arguments.SearchCrit.pg-1)*Arguments.SearchCrit.RecordsPerPage)+1 />
<cfset EndRow = (StartRow + Arguments.SearchCrit.RecordsPerPage)-1 />
<cfset retStruct = DAO.readSearch( Arguments.SearchCrit, StartRow, EndRow ) />
<cfreturn retStruct />
</cffunction>