izweig
asked on
Nesting cfloop queries
Hello.
I need to do the following:
I have MyTable structured like this.
ID NumImages
a 3
b 6
c 4
I want to output each ID as many times as there is NumImages.recordcount ,output it as a1,a2,a3 then output the next ID NumImages.recordcount as b1,b2,b3...
Trying to achieve this result:
a1
a2
a3
b1
b2
b3
b4
b5
b6
c1
c2
c3
c4
I have tried all kings of nesting cfoutputs, cfloops, cfoutput loops..I just don't get it.
Hope this makes sense.
Can you help?
I need to do the following:
I have MyTable structured like this.
ID NumImages
a 3
b 6
c 4
I want to output each ID as many times as there is NumImages.recordcount ,output it as a1,a2,a3 then output the next ID NumImages.recordcount as b1,b2,b3...
Trying to achieve this result:
a1
a2
a3
b1
b2
b3
b4
b5
b6
c1
c2
c3
c4
I have tried all kings of nesting cfoutputs, cfloops, cfoutput loops..I just don't get it.
Hope this makes sense.
Can you help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome.
ASKER