> The two options I can see are looping over each record and copying it to > a struct, or using Query functions to manipulate the recordset itself. I > haven't worked with the query functions very much - are there any > limitations to either of these approaches? How about performance?
If you already have the data in a query type variable, I would just leave it there and manipulate it directly if possible. Using the query functions is not that hard to learn, though adding a row can be cumbersome. If you're using CF5 you can also use QofQ to easily extract data from your modified query data. -Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ______________________________________________________________________ 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
