ColdFusion Examples

Toggling the overview panel on a CFMAP tag in ColdFusion

Peter deHaan — Sun, 28 Nov 2010 08:30:42 +0000

The following example shows how you can toggle the overview panel on a CFMAP tag in ColdFusion by setting the Boolean overview attribute.

<html>
 
<cfajaximport params="#{googlemapkey='YourGoogleMapsAPIKeyHere'}#" />
<cfparam name="URL.overview" default="false" type="boolean" />
 
<head>
head>
<body style="padding:20px;">
 
    <cfform method="GET" action="#CGI.SCRIPT_NAME#">
        <cfinput name="overview" type="checkbox" value="1" checked="#URL.overview#" onchange="this.form.submit();" />
        <label for="overview">overviewlabel>
        <cfinput name="submitBtn" type="submit" value="Submit" />
    cfform>
 
    <cfmap name="map01"
            centerAddress="San Francisco, CA"
            overview="#URL.overview#" />
 
body>
html>

And the output of the tag is as follows:

Listening for map errors on the CFMAP tag in ColdFusion

Peter deHaan — Sun, 28 Nov 2010 08:04:27 +0000

The following example shows how you can listen for map errors on the tag in ColdFusion and JavaScript using the onError attribute.

<html>
 
<cfajaximport params="#{googlemapkey='YourGoogleMapsAPIKeyHere'}#" />
 
<head>
<script type="text/javascript">
    function cfmap_onError(mapStatusCode, errorMessage) {
        alert("Uh oh, I wasn't able to find the specified address.\ncode: " + mapStatusCode);
    }
 
    function cfmap_onLoad() {
        alert("Map is loading.");
    }
script>
head>
<body style="padding:20px;">
 
    <cfmap name="map01"
            centerAddress="Qwertyville"
            onError="cfmap_onError"
            onLoad="cfmap_onLoad" />
 
body>
html>

And the output of the tag is as follows:

Converting a database query to a WDDX packet using ColdFusion

Peter deHaan — Sun, 28 Nov 2010 06:54:09 +0000

The following example shows how you can convert a database query to a XML WDDX packet using ColdFusion and the tag.

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME, A.ADDRESS, A.CITY, A.STATE
    FROM ARTISTS A
cfquery>
 
<cfwddx action="cfml2wddx"
        input="#getArtists#"
        output="artistsWDDX" />
 
<cfoutput>#xmlFormat(artistsWDDX)#cfoutput>

And the output of the tag is as follows:

 version='1.0'>
    />
    >
         rowCount='5' fieldNames='ARTISTID,FIRSTNAME,LASTNAME,ADDRESS,CITY,STATE' type='coldfusion.sql.QueryTable'>
             name='ARTISTID'>
                >1.0>
                >2.0>
                >3.0>
                >4.0>
                >5.0>
            >
             name='FIRSTNAME'>
                >Aiden>
                >Austin>
                >Elicia>
                >Jeff>
                >Lori>
            >
             name='LASTNAME'>
                >Donolan>
                >Weber>
                >Kim>
                >Baclawski>
                >Johnson>
            >
             name='ADDRESS'>
                >352 Corporate Ave.>
                >25463 Main Street, Suite C>
                >2523 National Blvd>
                >903 Boardwalk Ave>
                >6462 Cowtown Rd>
            >
             name='CITY'>
                >Denver>
                >Berkeley>
                >Los Angeles>
                >Hollywood>
                >Pierre>
            >
             name='STATE'>
                >CO>
                >CA>
                >CA>
                >FL>
                >SD>
            >
        >
    >
>

Toggling which columns are displayed from a database query using the CFDUMP tag in ColdFusion

Peter deHaan — Sun, 28 Nov 2010 06:33:14 +0000

The following example show how you can toggle which database query columns are displayed by the tag in ColdFusion by specifying the show or hide attribute.

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME, A.ADDRESS, A.CITY, A.STATE
    FROM ARTISTS A
cfquery>
 
<cfoutput>
<p>query columnList:<br/>
#getArtists.columnList#p>
cfoutput>
 
<cfdump var="#getArtists#"
        metaInfo="false"
        format="text"
        show="FIRSTNAME, LASTNAME" />

And the output of the tag is as follows:

query columnList:
ADDRESS,ARTISTID,CITY,FIRSTNAME,LASTNAME,STATE

query [Filtered - 2 of 6 columns shown]

[Record # 1]
FIRSTNAME: Aiden
LASTNAME: Donolan

[Record # 2]
FIRSTNAME: Austin
LASTNAME: Weber

[Record # 3]
FIRSTNAME: Elicia
LASTNAME: Kim

[Record # 4]
FIRSTNAME: Jeff
LASTNAME: Baclawski

[Record # 5]
FIRSTNAME: Lori
LASTNAME: Johnson

The previous example specifies which columns should be shown by setting the show attribute to “FIRSTNAME, LASTNAME”. If you wanted to prevent certain columns from being displayed by the tag, you could set the hide attribute, as seen in the following example:

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME, A.ADDRESS, A.CITY, A.STATE
    FROM ARTISTS A
cfquery>
 
<cfoutput>
<p>query columnList:<br/>
#getArtists.columnList#p>
cfoutput>
 
<cfdump var="#getArtists#"
        metaInfo="false"
        format="text"
        hide="ARTISTID, ADDRESS, CITY, STATE" />

And the output of the tag is as follows:

query columnList:
ADDRESS,ARTISTID,CITY,FIRSTNAME,LASTNAME,STATE

query [Filtered - 4 of 6 columns hidden]

[Record # 1]
FIRSTNAME: Aiden
LASTNAME: Donolan

[Record # 2]
FIRSTNAME: Austin
LASTNAME: Weber

[Record # 3]
FIRSTNAME: Elicia
LASTNAME: Kim

[Record # 4]
FIRSTNAME: Jeff
LASTNAME: Baclawski

[Record # 5]
FIRSTNAME: Lori
LASTNAME: Johnson

Dynamically adding columns to a database query using ColdFusion

Peter deHaan — Sun, 28 Nov 2010 05:51:58 +0000

The following example shows how you can dynamically add a column to a database query in ColdFusion using the queryAddColumn() function.

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME
    FROM ARTISTS A
cfquery>
 
<cfset queryAddColumn(getArtists, "fullName", ArrayNew(1)) />
<cfloop query="getArtists">
    <cfset querySetCell(getArtists, "fullName", uCase(getArtists.LASTNAME & ", " & getArtists.FIRSTNAME), getArtists.currentRow) />
cfloop>
 
<cfdump var="#getArtists#" metaInfo="false" format="text" />

And the output of the tag is as follows:

query

[Record # 1]
ARTISTID: 1
FIRSTNAME: Aiden
FULLNAME: DONOLAN, AIDEN
LASTNAME: Donolan

[Record # 2]
ARTISTID: 2
FIRSTNAME: Austin
FULLNAME: WEBER, AUSTIN
LASTNAME: Weber

[Record # 3]
ARTISTID: 3
FIRSTNAME: Elicia
FULLNAME: KIM, ELICIA
LASTNAME: Kim

[Record # 4]
ARTISTID: 4
FIRSTNAME: Jeff
FULLNAME: BACLAWSKI, JEFF
LASTNAME: Baclawski

[Record # 5]
ARTISTID: 5
FIRSTNAME: Lori
FULLNAME: JOHNSON, LORI
LASTNAME: Johnson

You can also populate an array object and pass it to the queryAddColumn() function, as seen in the following example:

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME
    FROM ARTISTS A
cfquery>
 
<cfset col = arrayNew(1) />
<cfloop query="getArtists">
    <cfset arrayAppend(col, uCase(getArtists.LASTNAME & ", " & getArtists.FIRSTNAME)) />
cfloop>
 
<cfset queryAddColumn(getArtists, "fullName", col) />
 
<cfdump var="#getArtists#" metaInfo="false" format="text" />

Or you can pre-size the array object and set the column value using the arrayResize() and arraySet() functions, as seen in the following examples:

<cfquery name="getArtists" datasource="cfartgallery" maxRows="5">
    SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME
    FROM ARTISTS A
cfquery>
 
<cfset col = arrayNew(1) />
<cfset arrayResize(col, getArtists.recordCount) />
<cfloop query="getArtists">
    <cfset idx = getArtists.currentRow />
    <cfset arraySet(col, idx, idx, uCase(getArtists.LASTNAME & ", " & getArtists.FIRSTNAME)) />
cfloop>
 
<cfset queryAddColumn(getArtists, "fullName", col) />
 
<cfdump var="#getArtists#" metaInfo="false" format="text" />

Adding the values in a database query column in ColdFusion

Peter deHaan — Sat, 27 Nov 2010 17:30:05 +0000

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.

<cfquery name="getArtPrices" datasource="cfartgallery" maxRows="5">
    SELECT A.PRICE
    FROM ART A
cfquery>
 
<cfset priceList = valueList(getArtPrices.price) />
<cfset priceArr = listToArray(priceList) />
 
<cfoutput>
list: #priceList#<br/>
sum: #numberFormat(arraySum(priceArr))#<br/>
avg: #numberFormat(arrayAvg(priceArr))#<br/>
cfoutput>

The previous example outputs the following text:

list: 10000,13900,12500,11100,13550
sum: 61,050
avg: 12,210

Getting started with Arrays in ColdFusion

Peter deHaan — Sat, 27 Nov 2010 07:16:41 +0000

The following examples show how you can get started with using the various Array functions in ColdFusion.

Creating a new Array in ColdFusion
Modifying items in an Array in ColdFusion
Determining the number of items in an Array in ColdFusion
Swapping items in an Array in ColdFusion
Determining whether an Array element is defined in ColdFusion
Calculating an array’s average, sum, maximum and minimum using ColdFusion
Sorting an array using ColdFusion
Resizing an Array in ColdFusion
Determining if a variable in an Array in ColdFusion
Determining if an item is in an Array in ColdFusion

Creating a new Array in ColdFusion

The following example shows how you can create a simple array in ColdFusion using the arrayNew() function:

<cfset namesArr = arrayNew(1) />
<cfset namesArr[1] = "Xander Crews" />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array – Top 1 of 1 rows
1) Xander Crews

The previous example creates an empty, 1-dimensional array. If you want to create a 2-dimensional (or 3-dimensional array) you can pass the number of dimensions to the arrayNew() function, as seen in the following example:

<cfset namesArr = arrayNew(3) />
<cfset namesArr[1][1][1] = "Xander Crews" />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array - Top 1 of 1 rows
1) [array]
	1) [array]
		1) Xander Crews

You can also create and populate an array using the [] notation, as seen in the following example:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array – Top 2 of 2 rows
1) Xander Crews
2) Wendell Stamps

Or you can create and populate an array using the listToArray() function, as seen in the following example:

<cfset namesArr = listToArray("Xander Crews,Wendell Stamps") />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array – Top 2 of 2 rows
1) Xander Crews
2) Wendell Stamps

Modifying items in an Array in ColdFusion

The following example shows how you can append items to the end of an array using the arrayAppend() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayAppend(namesArr, "Grace Ryan") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 3 of 3 rows
1) Xander Crews
2) Wendell Stamps
3) Grace Ryan

The following example shows how you can prepend items to the beginning of an array using the arrayPrepend() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayPrepend(namesArr, "Grace Ryan") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 3 of 3 rows
1) Grace Ryan
2) Xander Crews
3) Wendell Stamps

The following example shows how you can overwrite an item in an array using the array access operator:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset namesArr[2] = "Grace Ryan" />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array – Top 2 of 2 rows
1) Xander Crews
2) Grace Ryan

The following example shows how you can overwrite items in an array using the arraySet() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arraySet(namesArr, 2, 2, "Grace Ryan") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 2 of 2 rows
1) Xander Crews
2) Grace Ryan

You can also resize an array using the arraySet() function, as seen in the following example:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arraySet(namesArr, 2, 5, "Grace Ryan") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 5 of 5 rows
1) Xander Crews
2) Grace Ryan
3) Grace Ryan
4) Grace Ryan
5) Grace Ryan

The following example shows how you can insert items at a specific index in an array using the arrayInsertAt() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayInsertAt(namesArr, 2, "Grace Ryan") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 3 of 3 rows
1) Xander Crews
2) Grace Ryan
3) Wendell Stamps

The following example shows how you can delete an item at a specific index in an array using the arrayDeleteAt() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayDeleteAt(namesArr, 1) />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 1 of 1 rows
1) Wendell Stamps

You can also delete a specific item from an array passing the element to be removed instead of passing an index using the arrayDelete() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayDelete(namesArr, "Xander Crews") />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 1 of 1 rows
1) Wendell Stamps

You can delete all items from an array using the arrayClear() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfset success = arrayClear(namesArr) />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

success = YES

array [empty]

Determining the number of items in an Array in ColdFusion

The following example shows how you can determine the number of items in an Array using the arrayLen() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfoutput>Array has #arrayLen(namesArr)# items:<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

Array has 2 items:

array – Top 2 of 2 rows
1) Xander Crews
2) Wendell Stamps

You can check whether the array is empty using the arrayIsEmpty() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfoutput>Array is empty? #arrayIsEmpty(namesArr)#<br/>cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

Array is empty? NO

array – Top 2 of 2 rows
1) Xander Crews
2) Wendell Stamps

Swapping items in an Array in ColdFusion

The following example shows how you can swap items at two indices in an array using the arraySwap() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps", "Grace Ryan"] />
<cfset arraySwap(namesArr, 1, 3) />
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

array – Top 3 of 3 rows
1) Grace Ryan
2) Wendell Stamps
3) Xander Crews

Determining whether an Array element is defined in ColdFusion

The following example shows how you can determine if an array element is defined using the arrayIsDefined() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps", "Grace Ryan"] />
<cfset namesArr[5] = "Arthur Watley" />
<cfoutput>
Array index 1 is defined? #arrayIsDefined(namesArr, 1)#<br/>
Array index 4 is defined? #arrayIsDefined(namesArr, 4)#<br/>
cfoutput>
<cfdump var="#namesArr#" format="text" />

The previous example outputs the following text:

Array index 1 is defined? YES
Array index 4 is defined? NO

array – Top 5 of 5 rows
1) Xander Crews
2) Wendell Stamps
3) Grace Ryan
4) [undefined array element] Element 4 is undefined in a Java object of type class coldfusion.runtime.Array.
5) Arthur Watley

Calculating an array’s average, sum, maximum and minimum using ColdFusion

The following example shows how you can calculate a numeric array’s average value, minimum value, maximum value, and sum using the arrayAvg(), arrayMin(), arrayMax(), and arraySum() functions:

<cfset numArr = [28.72, 25.25, 590, 315, 35.2, 143.9, 27.49, 34.58, 9.95, 7.82, 10.59] />
<cfoutput>
Array average is #arrayAvg(numArr)#<br/>
Array average is #arraySum(numArr)#<br/>
Array minimum is #arrayMin(numArr)#<br/>
Array maximum is #arrayMax(numArr)#<br/>
cfoutput>
<cfdump var="#numArr#" format="text" />

The previous example outputs the following text:

Array average is 111.681818182
Array average is 1228.5
Array minimum is 7.82
Array maximum is 590

array – Top 11 of 11 rows
1) 28.72
2) 25.25
3) 590
4) 315
5) 35.2
6) 143.9
7) 27.49
8) 34.58
9) 9.95
10) 7.82
11) 10.59

Sorting an array using ColdFusion

The following example shows how you can sort an array using the arraySort() function:

<cfset nameArr = ["Xander", "Wendell", "Grace", "Arthur", "Stan", "Taqu'il"] />
<cfset arraySort(nameArr, "textNoCase") />
<cfdump var="#nameArr#" format="text" />

The previous example outputs the following text:

array – Top 6 of 6 rows
1) Arthur
2) Grace
3) Stan
4) Taqu’il
5) Wendell
6) Xander

If you are using a numeric array you can set the sortType attribute to numeric, as seen in the following example:

<cfset numArr = [28.72, 25.25, 590, 315, 35.2, 143.9, 27.49, 34.58, 9.95, 7.82, 10.59] />
<cfset arraySort(numArr, "numeric") />
<cfdump var="#numArr#" type="text" />

The previous example outputs the following text:

array – Top 11 of 11 rows
1) 7.82
2) 9.95
3) 10.59
4) 25.25
5) 27.49
6) 28.72
7) 34.58
8) 35.2
9) 143.9
10) 315
11) 590

You can also sort an array in descending order by specifying an optional third argument, sortOrder, as seen in the following example:

<cfset numArr = [28.72, 25.25, 590, 315, 35.2, 143.9, 27.49, 34.58, 9.95, 7.82, 10.59] />
<cfset arraySort(numArr, "numeric", "desc") />
<cfdump var="#numArr#" type="text" />

The previous example outputs the following text:

array – Top 11 of 11 rows
1) 590
2) 315
3) 143.9
4) 35.2
5) 34.58
6) 28.72
7) 27.49
8) 25.25
9) 10.59
10) 9.95
11) 7.82

Resizing an Array in ColdFusion

The following example shows how you can resize an array using the arrayResize() function:

<cfset nameArr = ["Xander", "Wendell", "Grace"] />
<cfset success = arrayResize(nameArr, 1) />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#nameArr#" format="text" />
 
<cfset success = arrayResize(nameArr, 5) />
<cfoutput>success = #success#<br/>cfoutput>
<cfdump var="#nameArr#" format="text" />

The previous example outputs the following text:

success = YES

array – Top 3 of 3 rows
1) Xander
2) Wendell
3) Grace

success = YES

array – Top 5 of 5 rows
1) Xander
2) Wendell
3) Grace
4) [undefined array element] Element 4 is undefined in a Java object of type class coldfusion.runtime.Array.
5) [undefined array element] Element 5 is undefined in a Java object of type class coldfusion.runtime.Array.

Determining if a variable in an Array in ColdFusion

The following example shows how you can determine if a variable is an array object using the isArray() function:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfoutput>namesArr is array? #isArray(namesArr)#cfoutput>

The previous example outputs the following text:

namesArr is array? YES

You can also check if an array is 1-dimensional, 2-dimensional, or 3-dimensional by passing an optional second argument, number, to the isArray() function, as seen in the following example:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfoutput>
namesArr is array? #isArray(namesArr)#<br/>
namesArr is 1-dimensional array: #isArray(namesArr, 1)#<br/>
cfoutput>

The previous example outputs the following text:

namesArr is array? YES
namesArr is 1-dimensional array: YES

Determining if an item is in an Array in ColdFusion

The following example shows how you can determine if an item exists in an array using ColdFusion and the arrayContains(), arrayFind(), and arrayFindNoCase() functions:

<cfset namesArr = ["Xander Crews", "Wendell Stamps"] />
<cfoutput>
arrayContains('wendell'): #arrayContains(namesArr, 'wendell')#<br/>
arrayContains('wendell stamps'): #arrayContains(namesArr, 'wendell stamps')#<br/>
arrayContains('Wendell Stamps'): #arrayContains(namesArr, 'Wendell Stamps')#<br/>
 
arrayFind('wendell'): #arrayFind(namesArr, 'wendell')#<br/>
arrayFind('wendell stamps'): #arrayFind(namesArr, 'wendell stamps')#<br/>
arrayFindNoCase('wendell'): #arrayFind(namesArr, 'wendell')#<br/>
arrayFindNoCase('Wendell Stamps'): #arrayFind(namesArr, 'Wendell Stamps')#<br/>
cfoutput>

The previous example outputs the following text:

arrayContains('Wendell'): NO
arrayContains('wendell stamps'): NO
arrayContains('Wendell Stamps'): YES

arrayFind('wendell'): 0
arrayFind('wendell stamps'): 0
arrayFindNoCase('wendell'): 0
arrayFindNoCase('Wendell Stamps'): 2

The arrayContains() function searches an array for the presence of a specified object and returns a Boolean value if the specified object exists in the array. The function searches simple objects such as strings and numbers or complex objects such as structures. String searches are case-sensitive.
The arrayFind() function performs a case-sensitive search on an array for a specified object and returns the index in the array of the first match, or 0 if there is no match. The function can search for simple objects such as strings or numbers and complex objects such as structures.
The arrayFindNoCase() function performs a case-insensitive search on an array for a specified object and returns the index in the array of the first match, or 0 if there is no match. The function can search for simple objects such as strings or numbers and complex objects such as structures.

Converting numbers between base 10 and base 16 using ColdFusion

Peter deHaan — Fri, 26 Nov 2010 01:59:44 +0000

The following example shows how you can convert numbers and strings between base 10 (decimal) and base 16 (hexadecimal) in ColdFusion using the formatBaseN() and inputBaseN() functions.

<cfoutput>
<table border="1">
<tr>
    <td>formatBaseN(255, 16):td>
    <td>#formatBaseN(255, 16)#td> 
tr>
<tr>
    <td>formatBaseN(6724044, 16):td>
    <td>#formatBaseN(6724044, 16)#td> 
tr>
<tr>
    <td>inputBaseN("FF", 16):td>
    <td>#inputBaseN("FF", 16)#td> 
tr>
<tr>
    <td>inputBaseN("6699CC", 16):td>
    <td>#inputBaseN("6699CC", 16)#td> 
tr>
table>
cfoutput>

The previous example outputs the following text:

formatBaseN(255, 16): ff

formatBaseN(6724044, 16): 6699cc

inputBaseN(“FF”, 16): 255

inputBaseN(“6699CC”, 16): 6724044

Getting started with Lists in ColdFusion

Peter deHaan — Fri, 26 Nov 2010 00:01:49 +0000

The following examples show how you can get started with using the various List functions in ColdFusion.

Creating a new List in ColdFusion
Determining the number of items in a List in ColdFusion
Getting a specific item from a List in ColdFusion
Appending and prepending items to a List in ColdFusion
Inserting items to a List in ColdFusion
Deleting items from a List in ColdFusion
Replacing items in a List in ColdFusion
Looping over items in a List in ColdFusion
Changing the delimiter in a List in ColdFusion
Sorting a List in ColdFusion
Determining if an item or substring is in a List in ColdFusion
Converting a List to an array in ColdFusion
Determining the number of instances of a specified value in a List in ColdFusion

Creating a new List in ColdFusion

The following example shows how you can create a simple list in ColdFusion using the tag:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List items: <em>#names#em>cfoutput>

The previous example outputs the following text:

List items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il

By default a list is comma (,) separated. The following example shows how you can use a pipe character (|) as a list delimiter (this can be useful if your list items contain a comma character):

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List items: <em>#namesDelim#em>cfoutput>

The previous example outputs the following text:

List items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Determining the number of items in a List in ColdFusion

The following example shows how you can determine the number of items in a List using the listLen() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional second argument, delimiters, to the listLen() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, '|')# items: <em>#namesDelim#em>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Getting a specific item from a List in ColdFusion

The following example shows how you can get a specific item from a list in ColdFusion using the listGetAt() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>The third item in the list is: <em>#listGetAt(names, 3)#em>cfoutput>

The previous example outputs the following text:

The third item in the list is: Grace

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listGetAt() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>The third item in the list is: <em>#listGetAt(namesDelim, 3, '|')#em>cfoutput>

The previous example outputs the following text:

The third item in the list is: Ryan, Grace

If you only want the first item in a list, last item in a list, or all items in the list except the first item, you can use the listFirst(), listLast(), or listRest() functions, as seen in the following example:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>
List has #listLen(names)# items: <em>#names#em><br/>
First item in list: <em>#listFirst(names)#em><br/>
Last item in list: <em>#listLast(names)#em><br/>
Rest items in list: <em>#listRest(names)#em><br/>
cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
First item in list: Xander
Last item in list: Taqu’il
Rest items in list: Wendell,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional secondargument, delimiters, to the listFirst(), listLast(), or listRest() functions, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>
List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>
First item in list: <em>#listFirst(namesDelim, "|")#em><br/>
Last item in list: <em>#listLast(namesDelim, "|")#em><br/>
Rest items in list: <em>#listRest(namesDelim, "|")#em><br/>
cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
First item in list: Crews, Xander
Last item in list: Taqu’il
Rest items in list: Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Appending and prepending items to a List in ColdFusion

The following example shows how you can append an item to the end of a list in ColdFusion using the listAppend() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listAppend(names, "Simon") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 7 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il,Simon

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listAppend() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listAppend(namesDelim, "Simon", "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 7 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il|Simon

The following example shows how you can prepend an item to the start of a list in ColdFusion using the listPrepend() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listPrepend(names, "Killface") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 7 items: Killface,Xander,Wendell,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listPrepend() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listPrepend(namesDelim, "Killface", "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 7 items: Killface|Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Inserting items to a List in ColdFusion

The following example shows how you can insert an item into a specific position within a list in ColdFusion using the listInsertAt() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listInsertAt(names, 2, "Simon") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 7 items: Xander,Simon,Wendell,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional fourth argument, delimiters, to the listInsertAt() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listInsertAt(namesDelim, 2, "Simon", "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 7 items: Crews, Xander|Simon|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Deleting items from a List in ColdFusion

The following example shows how you can delete an item from a specific position within a list in ColdFusion using the listDeleteAt() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listDeleteAt(names, 2) />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 5 items: Xander,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listDeleteAt() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listDeleteAt(namesDelim, 2, "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 5 items: Crews, Xander|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Replacing items in a List in ColdFusion

The following example shows how you can replace an item at a specific position within a list in ColdFusion using the listSetAt() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listSetAt(names, 2, "Darcelle") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 6 items: Xander,Darcelle,Grace,Arthur,Stan,Taqu’il

If you are using a custom list delimiter you can pass an optional fourth argument, delimiters, to the listSetAt() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listSetAt(namesDelim, 2, "Jones, Darcelle", "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 6 items: Crews, Xander|Jones, Darcelle|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

Looping over items in a List in ColdFusion

The following example shows how you can loop over items in a list using the tag and specifying the list and index attributes:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<ul>
<cfoutput>
<cfloop list="#names#" index="currName">
    <li>#currName#li>
cfloop>
cfoutput>
ul>

The previous example outputs the following text:

Xander

Wendell

Grace

Arthur

Stan

Taqu’il

If you are using a custom list delimiter you can specify the delimiters argument in the tag, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<ul>
<cfoutput>
<cfloop list="#namesDelim#" index="currName" delimiters="|">
    <li>#currName#li>
cfloop>
cfoutput>
ul>

The previous example outputs the following text:

Crews, Xander

Stamps, Wendell

Ryan, Grace

Watley, Arthur

Stan

Taqu’il

Changing the delimiter in a List in ColdFusion

The following example shows how you can change the delimiter in a list in ColdFusion using the listChangeDelims() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listChangeDelims(names, ";") />
<cfoutput>List has #listLen(names, ";")# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 6 items: Xander;Wendell;Grace;Arthur;Stan;Taqu’il

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listChangeDelims() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listChangeDelims(namesDelim, ";", "|") />
<cfoutput>List has #listLen(namesDelim, ";")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 6 items: Crews, Xander;Stamps, Wendell;Ryan, Grace;Watley, Arthur;Stan;Taqu’il

Sorting a List in ColdFusion

The following example shows how you can sort a list in ColdFusion using the listSort() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listSort(names, "textNoCase") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 6 items: Arthur,Grace,Stan,Taqu’il,Wendell,Xander

If you want to sort the list in descending order you can pass an optional third argument, sortOrder, to the listSort() function, as seen in the following example:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
 
<cfset names = listSort(names, "textNoCase", "desc") />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il
List has 6 items: Xander,Wendell,Taqu’il,Stan,Grace,Arthur

If you are using a custom list delimiter you can pass an optional fourth argument, delimiters, to the listSort() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
 
<cfset namesDelim = listSort(namesDelim, "textNoCase", "asc", "|") />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il
List has 6 items: Crews, Xander|Ryan, Grace|Stamps, Wendell|Stan|Taqu’il|Watley, Arthur

Determining if an item or substring is in a List in ColdFusion

The following example shows how you can determine if an item or substring exists in a list using ColdFusion and the listContains(), listContainsNoCase(), listFind(), and listFindNoCase() functions:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>
List has #listLen(names)# items: <em>#names#em><br/>
 
1) listFind('gra')? #listFind(names, "gra")#<br/>
2) listFindNoCase('gra')? #listFindNoCase(names, "gra")#<br/>
3) listFind('grace')? #listFind(names, "grace")#<br/>
4) listFindNoCase('grace')? #listFindNoCase(names, "grace")#<br/>
 
5) listContains('gra')? #listContains(names, "gra")#<br/>
6) listContainsNoCase('gra')? #listContainsNoCase(names, "gra")#<br/>
7) listContains('grace')? #listContains(names, "grace")#<br/>
8) listContainsNoCase('grace')? #listContainsNoCase(names, "grace")#<br/>
cfoutput>

The previous example outputs the following text:

List has 6 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il

1) listFind(‘gra’)? 0
2) listFindNoCase(‘gra’)? 0
3) listFind(‘grace’)? 0
4) listFindNoCase(‘grace’)? 3

5) listContains(‘gra’)? 0
6) listContainsNoCase(‘gra’)? 3
7) listContains(‘grace’)? 0
8) listContainsNoCase(‘grace’)? 3

The difference between the listFind() and listContains() functions is that the listFind() function determines the index of the first list element in which a specified value occurs, whereas the listContains() function determines the index of the first list element that contains a specified substring. Or in other words, the listFind() function only matches whole items, whereas the listContains() function matches substrings within items. And the difference between the listFind() and listFindNoCase() functions is that listFind() is case sensitive whereas listFindNoCase() is not.

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listFind(), listFindNoCase(), listContains(), or listContainsNoCase() functions, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>
List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>
 
1) listFind('gra')? #listFind(namesDelim, "gra", "|")#<br/>
2) listFindNoCase('gra')? #listFindNoCase(namesDelim, "gra", "|")#<br/>
3) listFind('ryan, grace')? #listFind(namesDelim, "ryan, grace", "|")#<br/>
4) listFindNoCase('ryan, grace')? #listFindNoCase(namesDelim, "ryan, grace", "|")#<br/>
 
5) listContains('gra')? #listContains(namesDelim, "gra", "|")#<br/>
6) listContainsNoCase('gra')? #listContainsNoCase(namesDelim, "gra", "|")#<br/>
7) listContains('grace')? #listContains(namesDelim, "grace", "|")#<br/>
8) listContainsNoCase('grace')? #listContainsNoCase(namesDelim, "grace", "|")#<br/>
cfoutput>

The previous example outputs the following text:

List has 6 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il

1) listFind(‘gra’)? 0
2) listFindNoCase(‘gra’)? 0
3) listFind(‘ryan, grace’)? 0
4) listFindNoCase(‘ryan, grace’)? 3

5) listContains(‘gra’)? 0
6) listContainsNoCase(‘gra’)? 3
7) listContains(‘grace’)? 0
8) listContainsNoCase(‘grace’)? 3

Converting a List to an array in ColdFusion

The following example shows how you can convert a list to an array in ColdFusion using the listToArray() function:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il" />
<cfoutput>List has #listLen(names)# items: <em>#names#em><br/>cfoutput>
<cfdump var="#listToArray(names)#" />

If you are using a custom list delimiter you can pass an optional second argument, delimiters, to the listToArray() function, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il" />
<cfoutput>List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>cfoutput>
<cfdump var="#listToArray(namesDelim, '|')#" />

Determining the number of instances of a specified value in a List in ColdFusion

The following example shows how you can determine the number of instances of a specified value in a list in ColdFusion using the listValueCount() and listValueCountNoCase() functions:

<cfset names = "Xander,Wendell,Grace,Arthur,Stan,Taqu'il,Wendell X" />
<cfoutput>
List has #listLen(names)# items: <em>#names#em><br/>
 
listValueCount('Wendell'): #listValueCount(names, "Wendell")#<br/>
listValueCountNoCase("wendell"): #listValueCountNoCase(names, "wendell")#<br/>
cfoutput>

The previous example outputs the following text:

List has 7 items: Xander,Wendell,Grace,Arthur,Stan,Taqu’il,Wendell X

listValueCount(‘Wendell’): 1
listValueCountNoCase(“wendell”): 1

If you are using a custom list delimiter you can pass an optional third argument, delimiters, to the listValueCount() and listValueCountNoCase() functions, as seen in the following example:

<cfset namesDelim = "Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu'il|Wendell X" />
<cfoutput>
List has #listLen(namesDelim, "|")# items: <em>#namesDelim#em><br/>
 
listValueCount('Wendell'): #listValueCount(namesDelim, "Wendell", "|")#<br/>
listValueCountNoCase("wendell"): #listValueCountNoCase(namesDelim, "wendell", "|")#<br/>
cfoutput>

The previous example outputs the following text:

List has 7 items: Crews, Xander|Stamps, Wendell|Ryan, Grace|Watley, Arthur|Stan|Taqu’il|Wendell X

listValueCount(‘Wendell’): 0
listValueCountNoCase(“wendell”): 0

In the previous example, neither the listValueCount() or listValueCountNoCase() functions matched any items. This is because the listValueCount() method matches whole items, not substrings within items.

Displaying a database query in a grid using the CFGRID tag in ColdFusion

Peter deHaan — Thu, 25 Nov 2010 08:04:30 +0000

The following examples show how you can display a database query in a grid using the and tags in ColdFusion.

<html>
 
<cfquery name="getArtists" datasource="cfartgallery">
    SELECT A.*
    FROM ARTISTS A
    ORDER BY A.LASTNAME, A.FIRSTNAME
cfquery>
 
<head>
head>
<body style="padding:20px;">
 
    <cfform>
        <cfgrid name="myGrid" query="getArtists" />
    cfform>
 
body>
html>

And the output of the tag is as follows:

By default the tag displays the grid as a Java applet. To display the grid in a different format, set the format attribute, as seen in the following example:

<html>
 
<cfquery name="getArtists" datasource="cfartgallery">
    SELECT A.*
    FROM ARTISTS A
    ORDER BY A.LASTNAME, A.FIRSTNAME
cfquery>
 
<head>
head>
<body style="padding:20px;">
 
    <cfform>
        <cfgrid name="myGrid" query="getArtists" format="html" />
    cfform>
 
body>
html>

And the output of the tag is as follows:

formatBaseN(255, 16):	ff
formatBaseN(6724044, 16):	6699cc
inputBaseN(“FF”, 16):	255
inputBaseN(“6699CC”, 16):	6724044