Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paging not showing records

Status
Not open for further replies.

cleanair4me

Technical User
May 16, 2008
61
I have a Cold Fusion 8 paging attempt that is not working because no records show even though I query 200 records.
It shows the Paging box only with just Page 1 label.

Please advise.

MainPage.cfm
Code:
<cfquery name="artists" datasource="cfartgallery">
SELECT artistid, lastname, firstname, email 
FROM artists
ORDER BY lastname, firstname
</cfquery>

<cfform>
   <cfgrid name="artists"
         format="html"
         striperows="yes"
         query="artists">
      <cfgridcolumn name="lastname" header="Last Name" width="100"/>
      <cfgridcolumn name="firstname" header="First Name" width="100"/>
      <cfgridcolumn name="email" header="E-Mail" width="200"/>
   </cfgrid>
</cfform>

<cfform>
   <cfgrid name="artists"
         format="html"
         pagesize="10"
         striperows="yes"
         bind="cfc:artists.getArtists({cfgridpage},
                              {cfgridpagesize},
                              {cfgridsortcolumn},
                              {cfgridsortdirection})">
      <cfgridcolumn name="lastname" header="Last Name" width="100"/>
      <cfgridcolumn name="firstname" header="First Name" width="100"/>
      <cfgridcolumn name="email" header="E-Mail" width="200"/>
   </cfgrid>
</cfform>


Artists.cfc
Code:
<cfcomponent output="false">

   <cfset THIS.dsn="cfartgallery">

   <!--- Get artists --->
   <cffunction name="getArtists" access="remote" returntype="struct">
      <cfargument name="page" type="numeric" required="yes">
      <cfargument name="pageSize" type="numeric" required="yes">
      <cfargument name="gridsortcolumn" type="string" required="no" default="">
      <cfargument name="gridsortdir" type="string" required="no" default="">

      <!--- Local variables --->
      <cfset var artists="">

      <!--- Get data --->
      <cfquery name="artists" datasource="#THIS.dsn#">
      SELECT artistid, lastname, firstname, email 
      FROM artists
      <cfif ARGUMENTS.gridsortcolumn NEQ ""
         and ARGUMENTS.gridsortdir NEQ "">
         ORDER BY #ARGUMENTS.gridsortcolumn# #ARGUMENTS.gridsortdir#
      </cfif>
      </cfquery>

      <!--- And return it as a grid structure --->
      <cfreturn QueryConvertForGrid(artists,
                     ARGUMENTS.page,
                     ARGUMENTS.pageSize)>
   </cffunction>

</cfcomponent>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top