Hi I'm working on bulk updating/inserting data into a database from several txt files I think I've solved the actual updating/inserting bit with help from people on this list. My new dilemna is how to account for titles that have to be deleted from the original database because they were not on the update txt file. I thought that possibly I could have a yes/no "show" field and change all to No before an update then change any updates/inserts to yes Is this a reasonably elegant way of doing things? any better ways? Many thanks Seamus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
