Complex datatypes, such as structures, are passed by reference. In your loop you are repopulating the same structure with information. When you append to the array, you are appending a reference to the structure.
Add <cfset StreeRow = StructNew()> at the beginning of the loop.
That fixed it.
But this code worked before, is this something new?
Nothing new. Not sure why this worked before unless you only had one street in the query :-)
As proof, here's a link to an old article from 2010 of someone else having the same issue. Appending to array within a loop issue - Get Started - The SitePoint Forums
Or i just never noticed it
I'm the only webmaster/web developer here in charge of all the websites and internal web applications.
It's a lot to keep track of sometimes
anyway thanks for the help. I figured it was probably either a bug or me missing something simple.