coreForms Demo Site

<!--- SET ALL THE DEFAULTS --->
<cfobject name="artgallery" component="artgallery">
<cfparam name="url.sort" default="">
<cfparam name="url.direction" default="asc">
<cfparam name="url.search" default="">

<cfparam name="url.start" default="1">
<cfset navigationrows = 5>
<cfset cfstartpointx = #url.start# - 1>

<!--- QUERY THE DATABASE --->
<cfinvoke
  component = "#artgallery#"
  method = "getArt"
  returnVariable = "getArt">
<cfinvokeargument name="sort" value="#url.sort#">
<cfinvokeargument name="direction" value="#url.direction#">
<cfinvokeargument name="search" value="#url.search#">
<cfinvokeargument name="navigationrows" value="#navigationrows#">
<cfinvokeargument name="cfstartpointx" value="#cfstartpointx#">
</cfinvoke>

<!--- GET THE TOTAL NUMBER OF RECORDS --->
<cfinvoke
  component = "#artgallery#"
  method = "getArtTotal"
  returnVariable = "totalQry" />

<h2>A List of People</h2>
<h3>Requires the CFartgallery datasource</h3>

<!--- MAKE THE TABLE --->
<cfmodule template="#coretable#"
queryname="getArt"
columnnames="Name,Price,Description,Artist,Date"
valuefield="artname,price,description,artist,listingdate"
fieldsort="Y,Y,Y,N,Y"
includesearch="Y"
addnavigation="Y"
totalrowsqueryname="totalQry"
tablewidth="600"
columnvalueformat="N,Currency,N,N,Date"
columnPercentWidths="25,20,15,20,20"
>