Never mind, I tested it locally and it is skipping your first row as a column row. Add a row to the top that identifies the column names and it'll work
Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ----- Original Message ----- From: [EMAIL PROTECTED] To: CF-Talk Sent: Thursday, December 13, 2001 3:17 PM Subject: Re: wharts wrong with this cfhttp? I think that it might be ignoring the first row thinking that it is the field headers. I can't find the documentation to support this, but I'm referencing Mastering CF 4.5 and their examples have a text doc with four fields, the first being field headers, but the output is only the 3 records. If you can adjust your text doc to reflect line numbers, then we can test this theory. Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ----- Original Message ----- From: Bryan Love To: CF-Talk Sent: Thursday, December 13, 2001 3:05 PM Subject: RE: wharts wrong with this cfhttp? me too, except that the query has 3 rows and the text file has 4... +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:04 PM To: CF-Talk Subject: Re: wharts wrong with this cfhttp? I just copied and pasted your code onto my dev server and it worked just fine. What problems were you having? Michael Corrigan Programmer Endora Digital Solutions www.endoradigital.com 630/942-5211 x-134 ----- Original Message ----- From: Kris Pilles To: CF-Talk Sent: Thursday, December 13, 2001 2:24 PM Subject: wharts wrong with this cfhttp? <cfhttp url="http://webmaster.wsboces.org/xcatalog.txt" method="Get" delimiter="," textqualifier="''" columns="Syear,Catalog_code,Catalog_name,Keywords,Description" name="buildquery"> <cfoutput query="Buildquery"> #Syear# #Catalog_code# #Catalog_name# #Keywords# #Description#<br> </cfoutput> file located at webmaster.wsboces.org/test.cfm plese help...?? Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists