Hi Bob,
<cfset record = 0 >
<cffile action="read" file="D:\WebNew\temp\EPARank.txt"
attributes="readonly" variable="epafile" />
<cfloop index="line" list="# epafile #" delimiters="#chr(10)##chr(13)#">
<cfset record = record + 1 />
<cfif record neq 1 >
//Do Insert
This will skip the first line.
Paul.
-----Original Message-----
From: Bob Imperial [mailto:[email protected]]
Sent: Friday, February 13, 2009 10:38 AM
To: cf-newbie
Subject: looping a text file for an insert?
Hi folks,
I'm working on something that's new for me here and need some help. I have a
tab delimited text file that is sent to me every night and I would like to
automate the process of inserting the contents into a table I already have
set up. I've been importing the file manually into and access db then using
mySQL migration tool to import it into my table. This text file comes to me
the same way each time with the first row of values being the column names.
I don't have clue how to set this up other than to use
<cffile action="read" file="D:\WebNew\temp\EPARank.txt"
attributes="readonly" variable="epafile" /> to read the contents and I've
played with that and am able to see the contents doing a dump but I have no
idea how to handle the first row or what the syntax would even look like.
Any help would be appreciated. TIA!
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4360
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
