coreForms Demo Site

[Demo Home]

A List of People

Requires the CFartgallery datasource

Search:

[<<] [>>]   Total: 0 (Showing 1 - 0)
Name Price Description Artist Date

 

Code:

<!--- 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"
>

query
RESULTSET
query
  ARTIST ARTNAME DESCRIPTION LISTINGDATE PRICE
CACHED false
EXECUTIONTIME 47
SQL Select ARTNAME,PRICE,DESCRIPTION,artist,listingdate From tblTestData Where 1=1 Order By artname Limit 0, 5

 

©2009 CompositeWeb.com