Well... There are a number of techniques for ensuring data integrity. In cases where I'm using CF to manage a bulk import (rather than the database itself) I tend to use a staging database to import the data and then I only transfer it to the production database IF the import passes some sort of checksum test. Then I manage the data transfer from the staging database to the production database using a DTS package(MS SQL) rather than using CF as database specific data migration tools tend to work far more quickly and a far more reliable.
=] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:328316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
