There is an article in this month's CF Developers Journal about using a
custom tag called 'querysim' to mimic database calls. The article
discusses a number of different uses for it, including using it to parse
through a web server log file (space delimited usually) as if it were a
database recor
we have tried this and are using it, somewhat different in how things go,
but you can set up a datasource to a folder, and then your queries are
something like
select * from somefile.csv
and if there's a header line in the csv, you will get a nice normal query to
work with after that point. work
I would recommend looking at either a java or COM component that is specifically
developed to give you bite sized portions. VB/Com certainly has sequential file
access, which doesn't require you to have 1 MB of RAM for every 1 MB of file size. It
would just allow you to walk through the file
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):
Keith Purtell, Web/Network Administrator
VantageMed Operations (Kansas City)
Email: [EMAIL PROTECTE
I haven't tried this, but there is a Microsoft ODBC text driver that
supports TXT (Text files) and CSV (comma delimited files). You may be able
to setup an ODBC connection to this file.
Randy Ellis
Senior Programmer Analyst
City of Overland Park
-Original Message-
From: Johnson, Michael
It depends on what you want to do with it, but here's an idea.
The only method i'm aware of is to use then you can execute a query
off that. Looks like:
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:
#grabTextFile.columnName#
Th
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, Mi