coldfusion/6/CFML_Reference/Tags-pt175.htm

fdgsogc91 — 2004-12-17T07:59:01

Thank you MarkZet for your comment/correction. I was trying to mark a list of check boxes as checked where the userid had previously selected. In essence showing the user thepreferences by checkbox that they selected in an earlier session.

I could not get this to work properly until I entered your [queryname.CurrentRow] code. Thank you, thank you, thank you.

coldfusion/6/CFML_Reference/Tags-pt175.htm

MarkZet — 2004-12-14T07:23:52

If you have an inner and outer loop over two queries, expressions referring to data in the outer query will return data from the first record during the execution of the inner query loop. However, the CurrentRow pointer still works as expected.

Example: suppose you have query 'q1' (a column named 'letter' containing two records with values 'A' and 'B') and query 'q2' (a column named 'number' containing two records with values 1 and 2) :

#q1.letter# #q2.number#

This will produce the following output:
A 1 A 2 A 1 A 2

Workaround:

#q1.letter[q1.CurrentRow]# #q2.number#

Gives:
A 1 A 2 B 1 B 2

Question: is this by design? It has caused some unexpected output at occasions. Especially in a setup such as the following:

and in template show.cfm:
#q1.letter#: #q2.number#
There's really no way to be sure but to postfix every query inside a with [q.CurrentRow].

LiveDocs Comments - coldfusion - 6 - CFML_Reference - Tags-pt175.htm

coldfusion/6/CFML_Reference/Tags-pt175.htm

coldfusion/6/CFML_Reference/Tags-pt175.htm