There are two custom tags in the Allaire Exchange that work great for this.
L2QColumns.cfm
LinesToQuery.cfm
--Bill
-----Original Message-----
From: Rick Eidson [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 3:44 PM
To: CF-Server
Subject: Uploading CSV File
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
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
