It sounds to me like the photos aren't in the database at all, but probably just in a directory? If they are in a DB table, then as mentioned the primary key/ indexing really needs to be rethought.
Rather than run a purge via the query (which is going to be a big resource load, from the looks of it) I'd put the delete photos functionality into whatever method is used to close a listing. E.g. house sells, close the listing and delete the photos. Good luck -Ed ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
