Jim Mixon wrote: > er, sorry . . I do not understand . . . > > how does CFFILE get a line of text from a list of lines of text inserted > into and existing table??
sorry i thought you wanted to append a record to an existing dataset in a comma delimted file.. then from what I understand... then u need to load the data into cf as a query... either with a text odbc driver (best, fastest) or using list functions or something then simply loop of the data with cfloop and do sql inserts using cfqueryparam to keep things running fast... if this is any kind of large/regular process then u should look into your db's direct loading functions... z ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
