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

    cfgrid in Cf7

    newcf Level 1

      Hi,

       

      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.

      Thanks

       

       


      <!---form--->
      <cfparam name="variables.row_per_page_default" default="15">

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

       

      <!---cfc--->
      <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" />
          </cfquery>
         
      <cfreturn queryconvertforgrid(qPur, page, pagesize) />
      </cffunction>