Using Database Side Paging With CFGrid - page 3

<cfcomponent>
      <cffunction name="calcPageRows" access="public" output="false" returntype="struct">
            <cfargument name="page" type="numeric" required="true">
            <cfargument name="pagesize" type="numeric" required="true">
      
            <cfset var rowStruct = structNew()>
            <cfset rowStruct.startRow = (arguments.page * arguments.pageSize)-(arguments.pageSize - 1)>
            <cfset rowStruct.endRow = (arguments.page * arguments.pageSize)>

            <cfreturn rowStruct />
      </cffunction>


      <cffunction name="queryToCFGrid" access="public" output="false" returntype="struct">
            <cfargument name="theQuery" required="true" type="query">
      
            <cfset var returnStruct = structNew()>      
            <cfset returnStruct.totalRowCount = theQuery.totalRows>
            <cfset returnStruct.query = theQuery>
      
            <cfreturn returnStruct />
      </cffunction>


      <cffunction name="getUsersForCFGrid" access="remote" output="false" returntype="struct">
            <cfargument name="page" type="numeric" required="true">
            <cfargument name="pagesize" type="numeric" required="true">
            <cfargument name="sortCol" type="string" required="true" default="">
            <cfargument name="sortDir" type="string" required="true" default="">
            
            <cfset var returnQuery = "">
            <cfset var rowLimits = calcPageRows(arguments.page,arguments.pagesize)>

            <cfstoredproc procedure="dbo.getUsers_paged" datasource="#request.dsn#">
                  <cfprocparam cfsqltype="cf_sql_varchar" value="#arguments.sortCol#">
                  <cfprocparam cfsqltype="cf_sql_varchar" value="#arguments.sortDir#">
                  <cfprocparam cfsqltype="cf_sql_integer" value="#rowLimits.startRow#">
                  <cfprocparam cfsqltype="cf_sql_integer" value="#rowLimits.endRow#">
                  <cfprocresult name="returnQuery">
            </cfstoredproc>
            
            <cfreturn queryToCFGrid(returnQuery)>
      </cffunction>
</cfcomponent>