query.rowByIndex()

edit

Introduced: 5.3.4.34

query.rowByIndex( index=string, defaultValue=numeric )

Returns: Numeric

Argument Description
index
string, required 		edit

Name of the index.
defaultValue
numeric, optional 		edit

In case no matching index was found, this value is returned by the function, in case it is not set, the function will throw an exception.

Examples

edit 
<cfscript>
    q_tag = queryNew("tag,id")
    tags = getTagList();
    loop collection="#tags.cf#" item="tag" {
        res = queryAddRow(q_tag);
        QuerySetCell(q_tag, "tag", tag, res);
        QuerySetCell(q_tag, "id", res, res);
    }
</cfscript>

<cfquery name="q_tags_indexed" indexName="tag" dbtype="query">
    select * from q_tag;
</cfquery>

<cfscript>
    writeDump(q_tags_indexed.rowByIndex("tag",5));
</cfscript>

See also