ok, worth a try, I set it up in CF Admin, it said it's "ok" but when I try to read in RDS, it requires a username/password. I didn't set one up or even have the ability to do so in admin that I saw. What am I missing?
> You might still use the Merant ODBC text driver to do the work of retrieving > the lines, though. Just treat it as a single large field and continue to > parse it as you're doing. > > Jim > > > ----- Original Message ----- > From: "Chris Giminez" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, January 25, 2002 10:42 AM > Subject: Re: extracting data from a huge text file > > > > the format of the text file is not very consistent. It's a comma delimited > list, but the last field > > is itself a comma delimited list and fields 8 and 9 contain one double > quote instead of a pair like > > every other field. It's very strange and I can't get the writers of this > text file to explain their > > logic or change it so far. > > I don't think an automated solution will work for these reason, so I am > parsing each line piece by > > piece and saving as individual variables. > > > > > > > Another option.. Why not open it as an ODBC data source, and let the > > > ODBC > > > drivers worry about the size of the file? We recently did something > > > like > > > this with VB for a text file, only a few lines/records though. But it > > > should still work well with larger files. > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
