I need to upload a CSV file and enter its field values into a database.
I can read the file and output it
<cffile destination="e:\WebSites\KCHost\Fax" action="UPLOAD"
nameconflict="overwrite" filefield="XFile">
<cffile action="READ" file="e:\WebSites\KCHost\Fax\#FILE.ServerFile#"
variable="RawFile">
<cfquery datasource="enews" name="Update">
INSERT INTO Fax
(Name)
VALUES('#RawFile#')
</cfquery>
This puts into one field. But how can Read each field
The fields would be Name, Faxnumber
Rick Eidson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
