well first off the only two valid characters for the delimiter are a tab or
comma and you are using a semi-colon.
Here is the excerpt from CF Help:
GET file into a query -- To download a file in a ColdFusion page so that a
query can be built using the file, the file must be either comma-separated
or tab-delimited. Although risky, text qualification may be omitted. The
file will be parsed and an appropriate query built from it. Columns may be
specified in the attribute list so that the client can override the columns
specified in the file. There is error checking within the tag that prevents
a user from either entering an invalid column name or using an invalid
column name that was specified in the original file. If such an illegal
filename is encountered, the illegal characters are stripped. Such action
could produce duplicate column names, so duplicate columns are renamed and
inserted into the query header. The query has all of the functionality of a
standard CFQUERY object.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication 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
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Mitko Gerensky-Greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 12: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
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
