Take a look at a custom tag CFX_CSVtoQuery in the Allaire developer exchange. Perhaps this will help, works well for us.
Tony Gruen -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 8:56 AM To: CF-Talk Subject: Re: reading a text file into a query?? Is this a text file you are getting from elsewhere, or are you trying to just use a text file as a datasource? I mean, is CFHTTP really the way to go get the txt file? would CFFILE work? Would the ASCII TXT ODBC driver work? If you want me to look at the text file and the code to see if you ar e just doing something a little wrong, email me off list, and I'll chec k it out for you. It may just be a semi-obvious bug that keeps it from working, rather than a real systemic problem. Please DO NOT send the data or code to the list, but if its under 2 M B or so, feel free to send your CFM and .txt files to my email, and I'll t ry to get it working here. Jerry Johnson >>> [EMAIL PROTECTED] 12/21/01 10:07AM >>> Sinze I'm having so much trouble using cfhttp to read a txt file in t hen output it as a query is there any other way that I can do this with C F??? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] _____________________________________________________________________ _ 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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
