Thanks- I've got a couple options to import the file directly into the db without using cffile. That's a good thing. What this discussion has done, though, is presented the problem of preventing a user from uploading a file that's too big to begin with. It seems there are two solutions. One is an expensive utilitiy from http://www.softartisans.com/. I've also seen a couple applets that can read a file size before it's uploaded but they require the user to download the applet first. I'd like the process to be seamless to the user but safeguarded for us.
BG >From: "Mark Stewart" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Querying a text file >Date: Fri, 1 Aug 2003 14:34:56 -0400 > >Couple days late on this, but... I usually use SQL Server DTS packages to >do my heavy file lifting - I set-up a connection to the file and place the >contents into the db. If I'm not worried about real time data, I schedule >the package. You can also run a dts package through cf using COM. You >really don't want to use cffile with what you're doing. I don't know if >you're using sql server or if your host will allow you to utilize dts >packages (probably not), but it's worth a try. > >Mark > > >-----Original Message----- >From: B G [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 30, 2003 5:40 PM >To: CF-Talk >Subject: Querying a text file > > >I am building an application where users can upload a comma delimited text >file to a unique user directory then retrieve the data from it for later >use. The structure of the file will be pre-defined and the users must >follow that format. Field names are included in the first row. > >I had intentionally decided not to import that data from the text file into >a table because of the file size. Reading the contents of a file with >CFFILE puts the entire contents into a variable which takes up memory. 100 >users all working with 10 meg files at the same time could cause a problem. > >But I am finding that no host will offer to support a text ODBC connection. >I even had one tell me it couldn't be done. Also, a few have stated that >querying a text file is too flaky to be considered reliable. > >Has anyone had any experience similar to this? Am I worrying about using >too much RAM unnecessarily? Perhaps a more efficient way to get the >contents of the text file other than CFFILE? > >Thanks! > >BG > >_________________________________________________________________ >Add photos to your e-mail with MSN 8. Get 2 months FREE*. >http://join.msn.com/?page=features/featuredemail > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
