Michael: I've used CFFILE to read a text file, but never tried anything beyond about 3 MB in size. No performance problems so far.
snippet (real version dynamically adds the real file name): <CFFILE ACTION="READ" FILE="C:\MAIL\temp\#Name#.txt" VARIABLE="TempVarMail"> Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl Wakefield Sent: Friday, August 02, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] help reading a text file... The only method i'm aware of is to use <cfhttp> then you can execute a query off that. Looks like: <cfhttp method="get" url=http://www.yoursite.net/foo.txt (<--should be quotes around that) name="grabTextFile" delimiter=","> Then you can output it just like a cfquery like so: <cfouput query="grabTextFile">#grabTextFile.columnName#</cfoutput> Thats straight from the text book. I have not had opportunity to try this in real life so I can't comment reliably on performance. A. ----- Original Message ----- From: "Johnson, Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 12:55 PM Subject: [KCFusion] help reading a text file... > > what's the best way to read a very large tab delimeted text file? > > does cf.. read the whole file into one variable... how does this get > effected if you're reading a large file? > > > Mike Johnson > Science Application International Corporation > (757) 870-9165 > Emai: [EMAIL PROTECTED] > > <<Johnson, Michael.vcf>> > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]