> Nope... > suppose you have a query in memory with 100 records in it. > You want to delete record number 43 from the query and leave > all of the other's in place. How would one go about doing > this? I don't want to touch the database. I'm assuming the > best way may be to copy the query to a structure and then > delete that row from the structure but I'm not sure. >
Just to add to the email I've already sent. You don't need to copy it to struct, you can already access a query as a structure in the form YourQuery["YourColumn"][RowNumber] Regards Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4