I have a large ugly query listing the threads in a message board. (each thread can have multiple articles) I have a separate function that stores a user profile for a member based on their username. In each article (post) the username defaults to their real username, but they can edit it and perhaps put someone else's username. I have the queries to find out the poster's real username, and then I can compare it to the main query's username to see if it's a "fake". Of course these quries right now are in the output loop of the big ugly query. I'd like to loop over them and create a structure, or array to store the threadid and the REAL username of the poster BEFORE the main output. This way I could test for the real username of the poster while in the output loop without hitting the db. I'm using CF4.5 so I can't query a query. :-( And I think building a list would be rather crude. Could someone help get me started? Which is proper to use for this an array or structure?
______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

