print out the same row three times

[HandersonVA]

I have records in the color table.
Index_id colorname
1 red
2 yellow
3 blue
4 orange

I would like to print out the same row three times by adding a different
static character as below (format: index_ID, A, B, or C, colorname)

1Ared
1Bred
1Cred
2Ayellow
2Byellow
2Cyellow
3Ablue
3Bblue
3Cblue
4Aorange
4Borange
4Corange

[The ScareCrow]

Just use the ascii codes of the characters that you want to prepend for the
index of a loop

<cfoutput query.....................>
<cfloop from="#Asc('A')#" to="#Asc('C')#" index="idx">
#Chr(idx)##queryName.ColumnName#
</cfloop>
</cfoutput>

Ken

[eastinq]

Or ...



<cfoutput query="myqry">
#index_ID# A #colorname#<br>
#index_ID# B #colorname#<br>
#index_ID# C #colorname#<br>
</cfoutput>