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 > > > > > > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
