The following example shows how you can get the average value and sum for a database query column in ColdFusion using the valueList(), listToArray(), arraySum(), and arrayAvg() functions.
The following examples show how you can get started with using the various Array functions in ColdFusion.
Recent Posts
- Toggling the overview panel on a CFMAP tag in ColdFusion
- Listening for map errors on the CFMAP tag in ColdFusion
- Converting a database query to a WDDX packet using ColdFusion
- Toggling which columns are displayed from a database query using the CFDUMP tag in ColdFusion
- Dynamically adding columns to a database query using ColdFusion
- Adding the values in a database query column in ColdFusion
- Getting started with Arrays in ColdFusion
- Converting numbers between base 10 and base 16 using ColdFusion
- Getting started with Lists in ColdFusion
- Displaying a database query in a grid using the CFGRID tag in ColdFusion
Archives
- November 2010 (63)
- October 2010 (13)
Books
Categories
- Basics (4)
- CFAJAXIMPORT (1)
- CFAPPLICATION (1)
- CFCOMPONENT (1)
- CFDUMP (4)
- CFFEED (5)
- CFFILE (1)
- CFFORM (2)
- CFFUNCTION (1)
- CFARGUMENT (1)
- CFRETURN (1)
- CFHTTP (3)
- CFIF (1)
- CFELSE (1)
- CFIMAGE (3)
- CFINVOKE (1)
- CFINVOKEARGUMENT (1)
- CFLAYOUT (1)
- CFLAYOUTAREA (1)
- CFLOCATION (1)
- CFLOOP (6)
- CFMAP (10)
- CFMAPITEM (1)
- CFMEDIAPLAYER (11)
- CFOBJECT (1)
- CFOUTPUT (1)
- CFPARAM (1)
- CFPOD (4)
- CFQUERY (11)
- CFSCRIPT (2)
- CFTABLE (1)
- CFCOL (1)
- CFTRY (1)
- CFCATCH (1)
- CFWDDX (1)
- CFXML (1)
- CGI (2)
- jQuery (2)
- Uncategorized (6)
Tags
action arrayAppend() arrayAvg() arrayLen() arraySum() ceiling() centerAddress CGI ColdFusion.Map ColdFusion.Mediaplayer collapsible condition createDate() datasource dateAdd() dateFormat() delimters firstRowAsHeaders fix() format from hideBorder index jQuery listToArray() maxRows name onLoad onStart output pi() query querySetCell() recordCount round() setCenter() source step title to top type url valueList() xmlVarHosting
Examples hosted by
