Guest User

Untitled

a guest
May 22nd, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. <cfset startRow = ((page-1) * pageSize) + 1 />
  2. <cfset endRow = startRow + pageSize - 1 />
  3. <cfset tmpQuery = queryNew(get_query.columnList) />
  4. <cfloop query="get_query" startRow="#startRow#" endRow="#endRow#">
  5. <cfset tmp = queryAddRow(tmpQuery) />
  6. <cfloop list="#get_query.columnList#" index="column">
  7. <cfset tmp = querySetCell(tmpQuery,column,evaluate("get_query.#column#")) />
  8. </cfloop>
  9. </cfloop>
  10. <cfset gridQuery = structNew() />
  11. <cfset gridQuery.query = tmpQuery />
  12. <cfset gridQuery.totalrowcount = get_query.recordcount />
  13. <cfreturn gridQuery />
Add Comment
Please, Sign In to add comment