I tried a brute force method by reading in the file... Not sure how efficient it is.. I have only testing on small files:
http://bennadel.com/index.cfm?dax=snippets:19.view However, I am pretty sure you can use CFHttp to grab a file and throw it into a query object. I have not tried that yet though. If you ever run into a problem with memory, you can probably use a Java file buffer and to a readLine() sort of thing and mess with one line at a time... But again, I am not talking from experience. ....................... Ben Nadel www.bennadel.com -----Original Message----- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 6:00 PM To: CF-Talk Subject: Query a flat file Has anyone ever queried a comma delimited flat file in CF7? I have 2 frequently updated files of around 15MB and 3MB, and don't want to import it into a database every time it changes. How efficiently can CF7 query a large file like that? Can I do calculations, filtering, etc. similar to a database query? Any other suggestions on how I might accomplish this? Thanks. Mike Klostermeyer [EMAIL PROTECTED] 402.408.3733 ext. 101 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247121 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
