Check out the query functions: QueryNew(), QueryAddRow(), QuerySetCell() along with CFFILE and a bit of looping and a liberal sprinkling of list functions should do the trick.
Steve > -----Original Message----- > From: Kris Pilles [mailto:[EMAIL PROTECTED]] > Sent: 21 December 2001 15:08 > To: CF-Talk > Subject: reading a text file into a query?? > > > Sinze I'm having so much trouble using cfhttp to read a txt > file in then > output it as a query is there any other way that I can do > this with CF??? > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > ______________________________________________________________________ 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
