LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-p79.htm

coldfusion/6.1/htmldocs/tags-p79.htm

GameDev — 2006-03-27T13:17:00

I think to be a little more clear, yes there is a problem when nesting loops w/ queries. It seems that the inner loop takes over the scope therefore preventing your outer loop from iterating. A simple fix though would be this:

#nestedVar#

coldfusion/6.1/htmldocs/tags-p79.htm

kuMX — 2005-03-08T07:43:16

Nested statements are indeed buggy. The workaround is to use an additional variable in the outer loop:

inner: #q1.x#

outter: #temp#

coldfusion/6.1/htmldocs/tags-p79.htm

2005-02-09T00:27:50

When I nest multiple statements I have a problem of the 2nd loop "remembering" what happened in the first itterations,
eg, say q1 returns a list of numbers from 1 through 10 and q2 returns 1 row

inner: #q1.x#

outter: #q1.x#

I will get:
inner: 1
outter: 1
..
inner: 2
outter: 1
..
inner: 3
outer: 1

why?

coldfusion/6.1/htmldocs/tags-p79.htm

ultrarodMX — 2004-12-08T16:46:37

It is possible to put into a cfloop with query a nested cfloop using any value of the external loop?

Select name, ID_Name, area, areabelong
from tnames
order by ID_name

Select name, ID_Name, area, areabelong
from tnames
where area = #area#

what i need is:

Select area
from tnames
where area = #belong#

#name#, #area#>br>

I just want a list from all those are in my area beyond areabelong is not like myarea

coldfusion/6.1/htmldocs/tags-p79.htm

herakles_uk1 — 2004-10-10T16:34:36

Nice.. wonder if the seemingly dodgy ripoff named "BlueDragon" can muster that...

Another advantage of course is removing the need to treat queries as arrays when done inside outer queries with overkill such as...

item number #x# in this subqueries name is: #item[x]#

But really, I guess I'm just expanding on the previous point, so probably shouldn't post this, ahh well, guess for yourself whether I clicked "Submit" or "Cancel"

coldfusion/6.1/htmldocs/tags-p79.htm

ECDatDOT — 2004-07-09T12:28:55

However, that in itself is one of the advantages of looping over a query. Should there be for some reason a need to nest a query output loop, you can write something like this:

...

Of course, that's not best practice, but then this book isn't about best practices.

Another (probably more important) advantage of cfloopping over a query is whitespace control. Even if this command is issued:

one can still control whitespace inside a <,cfloop> unlike in a

coldfusion/6.1/htmldocs/tags-p79.htm

halL — 2004-07-09T12:13:53

There is no specific reason not to use a cfinclude inside a cfoutput tag.
We should remove the statement:
"The advantage of looping over a query is that you can use CFML tags that are not allowed in a cfoutput tag."

coldfusion/6.1/htmldocs/tags-p79.htm

ECDatDOT — 2004-06-22T08:38:00

The last of the new examples has a typo:

...

...

And I've never heard of not being allowed inside a before.

coldfusion/6.1/htmldocs/tags-p79.htm

wlee — 2004-03-25T10:58:59

We are working to improve the examples in the ColdFusion reference pages. We propose to replace the current example on this page with the the following example. If you have any comments on this example, add them to this page.

dataSource = "cfsnippets">
SELECT * FROM Messages

#Message_ID#

The cfloop tag also iterates over a record set with dynamic start and stop points. This gets the next n sets of records from a query. This example loops from the 5th through the 10th record returned by the MessageRecords query:

startRow = "#Start#"
endRow = "#End#">
#MessageRecords.Message_ID#

The loop stops when there are no more records, or when the current record index is greater than the value of the endRow attribute.

The advantage of looping over a query is that you can use CFML tags that are not allowed in a cfoutput tag. The following example combines the pages that are returned by a query of a list of page names into one document, using the cfinclude tag.

dataSource = "Library"
maxRows = "5">
SELECT TemplateName
FROM Templates