If you're using SQL Server, you can create a DTS package then call it from CF. I couldn't believe the difference in speed when I switched to DTS. (If you need to use CF to validate the incoming data, use DTS to populate a temp table, CF to pull it out and insert the validated data into its permanent home. I'd wager still much quicker than using a loop over cffile contents, though I'd be curious to know if you wind up trying both...)
On Mon, 10 Jan 2005 17:36:09 -0500, Ken <[EMAIL PROTECTED]> wrote: > Hi. I want to enable the user to upload a csv file, then the data > should be validated against pre-defined criteria for different columns > in the csv file. Once that is done, I want to write the validated > rows from the csv file to the DB. > > Please help. > > Thanks, > Ken > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189866 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
