queryGetCellByIndex

Returns a cell value from the row with the given value in a query's index column. Set the index column with the indexName query option.

queryGetCellByIndex(query, column_name, index [, defaultValue]) → returns any

This function requires Lucee 5.3.4.34 and up.  Not supported on Adobe ColdFusion, etc.

Argument Reference

query query
Required

The query.

column_name string
Required

The column to read.

index string
Required

The index value of the row.

defaultValue any

Returned when no row matches. When omitted, an error is thrown.

Examples
Sample code invoking the queryGetCellByIndex function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub