2 Replies Latest reply on Dec 17, 2012 7:46 AM by newcf

    cfgrid in Cf7

    newcf Level 1



      I have the search page for user to search the purNO and display resutls in the list.  I am tring to do the paging but keep got an error for cf 7 not supported the PAGESIZE,BIND.  Please advice with the code below to have it works in colfusion 7.




      <cfparam name="variables.row_per_page_default" default="15">

      <cfform name="tableform">
      <cfgrid format="html"
      bind="cfc:cfc.query.pur{purNO},{cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsor tdirection})">
      <cfgridcolumn name="purNO" display="Purchase No"/>
      <cfgridcolumn name="date_modified" header="Date Modified" >


      <cffunction name="purNo" returntype="query" access="public">
      <cfargument name="purNO" required="yes" type="numeric" />
      <cfargument name="page" required="yes">
      <cfargument name="pageSize" required="yes">
      <cfargument name="gridsortcolumn" required="yes">
      <cfargument name="gridsortdirection" required="yes">


      <cfquery name="qPur" datasource="#variables.dsn#">
           SELECT *
          FROM tbl_pur
          WHERE purNO = <cfqueryparam  value="#arguments.purNO#" cfsqltype="cf_sql_integer" />
      <cfreturn queryconvertforgrid(qPur, page, pagesize) />