If the text file contains HTML, then it is not an appropriate choice for the use of the NAME and "delimiter". Name/delimeter/texqualifiers are used to convert a correctly formatted tab or comma separated file into a query. To convert an HTML table into a query you are going to have to use regex.
-mk -----Original Message----- From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:27 PM To: CF-Talk Subject: RE: Need help with CFHTTP In fact, by adding the textqualifier attribute I am now able to see the content of the text file: <cfhttp method="get" name="PHAPlansQuery" URL="http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice#- #fiscalyear#.txt" delimiter=";" textqualifier=""> And yes, it is pointing to a real text file which in fact contains HTML tables already. Long story why and how -- it comes from a VB application someone built long time ago. I am not supposed to take this text file and sort its content. I might get back with more questions :-) Thanks, Mitko ---------- Original Message ---------------------------------- From: "Mark A. Kruger - CFG" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 15:09:34 -0500 >I would get rid of the NAME and "delimeter" attributes and try simply >"getting" the file first. Does that work? Can you get the raw contents of >the file (without putting it into a query). > >Also, is the <Cfhttp> actually pointed at a filename? Or does it point to a >cfm page that delivers up the file? If the latter, it could be that you >need a POST request with <Cfhttpparams>. > >-mk > > >-----Original Message----- >From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]] >Sent: Monday, September 23, 2002 2:57 PM >To: CF-Talk >Subject: Need help with CFHTTP > > >Hello, > >Last week I asked about a CFFILE issue and was advised to use CFHTTP to read >files from a remote server. > >Now I am trying to make this work but with no success yet. Unfortunatelly, >this is on an intranet and I am not able to give you the link, but I will >try to explain what is happenening. > >received_plans_test.cfm (similar to >http://webapps1.hud.gov/pih/pha/plans/received/received_plans.cfm) sends a >form to received_plans_test.cfm >(similar to >http://webapps1.hud.gov/pih/pha/plans/received/view_received.cfm) > >The form sends whatever field office, plan type, fiscal year and beginning >quarter is selected from a set of drop-down menus. > >Depending on the fiscalyear selected in page1.cfm, page2.cfm is supposed to >read a text file and expose its content sorted one way or another. > >Here is the error message I am getting: > >Error Diagnostic Information >CFHTTP > >The error occurred while processing an element with a general identifier of >(CFHTTP), occupying document position (449:11) to (450:111) in the template >file /home1/web-docs-80/pih/pha/received/view_received_test.cfm. > > >Date/Time: Mon Sep 23 15:52:49 2002 >Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows 95; YComp 5.0.0.0) >Remote Address: 10.200.36.101 >HTTP Referrer: http://www2.hud.gov/pih/pha/received/received_plans_test.cfm > >Here is the piece of code between lines 449 and 450: > > > <cfhttp method="get" name="PHAPlansQuery" > >URL="http://www.hud.gov/offices/pih/pha/received/#fiscalyear#/#fieldoffice# - >#fiscalyear#.txt" delimiter=";"> > </cfhttp> > >What is wrong? > >Thanks in advance for your help, > >Mitko > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
