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
