There is also a custom tag in the MM devex that will do this, although the tag's suipport of cfqueryparam is broken (the author left a bug in it that defaults it permanently to cf_sql_varchar IIRC... oddly when I told him about it he refused to accept that the bug existed). It will take a quoted, comma-delimited file and turn it into a query. You can do the rest from there. If you need the filename I can track it down.
One thing I found is that you wind up with a lot of processing when doing this sort of thing if you are synching up two disparate db systems -- maybe the batch results of the day's brick/mortar customer service system. I added a hash field to the tables of both db's. I digest the entire contents of the local file, which is a local job -- no bandwidth or load on the web server. then compare that value to the hash on the site's db. Only If the hashes don't match then does an updater kick in. Saved me some outrageous time by just comparing the digest values. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
