This is from the Certified ColdFusion Developer Study Guide:

pg 37 Tip #1

<crit_quote>

The function of the query loop is the same as using <cfoutput> with a query attribute. For performance reasons, use a Query loop rather than a <CFOUTPUT query="qAny"> loop. Before ColdFusion 4.x, the <CFoutput query="qAny"> query loop performed better.

Generally speaking you should use a <cfloop> with a query attribute when doing all, or mostly, processing in the loop. If there is nothing in the loop but display, use <cfoutput>

</crit_quote>

So what's right?

-- Best regards, Critter ------------------------------------------- Wednesday, May 09, 2001, 11:50:56 S2k, you wrote:

KO> Sorry for the crosspost (had conflicting answers from other lists)

KO> but is there a consensus on which method of looping over a query is fastest?

KO> cfloop or cfoutput..

KO> Cheers

KO> KOLa

KO>