it's kind of kludgy, but you could upload the file, do a CFHTTP to the new file, use File.Contents as the variable over which to list loop.
additionally, why not rename the old file, then upload the new file to the same name? christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Marlon Moyer [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:19 PM To: CF-Talk Subject: Re: Q: Looping through a CSV File I used to use a custom tag that would create datasources in cf4.5, I'm not sure of the name anymore, but I got it off of the developer exchange. In essence it rewrites some registry settings, so I'm not sure if your hosting company would allow it. The other option is to have a permanent ODBC entry set up on the server and then just replace the text file with one of the same name. Marlon ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 2:57 PM Subject: RE: Q: Looping through a CSV File > Are these ODBC options available in CFServer 4.5? I > have 5.0 (dev server) but our web hosting company is > still at 4.5. > > > > The structure will always be the same but the file name is going to > > change though. I am backing up the old file before I push the new file > > up. > > > > Thanks, > > Jason Larson > > > > > > -----Original Message----- > > From: Marlon Moyer [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 21, 2002 9:35 AM > > To: CF-Talk > > Subject: Re: Looping through a CSV File > > > > If the csv structure will always be the same, you could set up an ODBC > > connection and treat it like a table. > > > > > > ----- Original Message ----- > > From: "Mike Townend" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, March 21, 2002 10:26 AM > > Subject: RE: Looping through a CSV File > > > > > > > Treat the file as a list of lists... > > > > > > List 1 - Delimiter = #Chr(10)##Chr(13)# > > > > > > And each element of that list is a list with delimeter , > > > > > > HTH > > > > > > > > > > > > -----Original Message----- > > > From: Jason Larson [mailto:[EMAIL PROTECTED]] > > > Sent: 21 March 2002 16:14 > > > To: CF-Talk > > > Subject: Looping through a CSV File > > > > > > > > > I have a CSV File that I am pushing up using cffile. I want to loop > > > through the csv file and insert the content into a database, and I am > > > not sure how to do this. Any help our guidance would help? > > > > > > Thanks > > > Jason > > > > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
