Determining the number of results from a database query in ColdFusion

In a previous example, “Querying a database in ColdFusion using the CFQUERY tag”, we saw how you could query a database in ColdFusion 9 using the <CFQUERY> tag.

The following example shows how you can get the number of records returned by a database query in ColdFusion by using the recordCount property on the query object.

Continue reading Determining the number of results from a database query in ColdFusion

Creating a simple conditional loop in ColdFusion using the CFLOOP tag

In previous examples, “Creating a simple index loop in ColdFusion using the CFLOOP tag” and “Setting the step size on an indexed loop in ColdFusion using the CFLOOP tag”, we saw how you could create a simple index loop in ColdFusion using the <CFLOOP> tag using the index, from, and to, and step attributes.

The following example shows how you can create a simple conditional loop in ColdFusion using the <CFLOOP> tag using the condition attribute.

Continue reading Creating a simple conditional loop in ColdFusion using the CFLOOP tag

Setting the step size on an indexed loop in ColdFusion using the CFLOOP tag

In a previous example, “Creating a simple index loop in ColdFusion using the CFLOOP tag”, we saw how you could create a simple index loop in ColdFusion using the <CFLOOP> tag and setting the index, from and to attributes.

The following example shows how you can set the step size on an indexed loop using the <CFLOOP> tag and specifying the step attribute.

Continue reading Setting the step size on an indexed loop in ColdFusion using the CFLOOP tag

Just a bunch of ColdFusion examples