This content has been marked as final. Show 4 replies
Will this xml always be sorted by year?
It will always be sorted by year and by employer. I was just trying to get the basic concept of the looping and would figure the rest out myself. But I would want it to look like this.
Year: 90 Wages: 2000.00
Year: 91 Wages: 2500.00
Employer: Gas Station
Year: Wages: 1000.00
Year: Wages: 1500.00
Thanks in advance.
This might be easier with a query. Create one with QueryNew(), and populate it when you loop through the xml. Then use Q of Q to sort it by employer, then year. You can now use the group attribute of cfoutput to group by employer.
Thanks alot. That is perfect. Much easier.