User Guide

336 Chapter 18 Interacting with Remote Servers
<!--- Now substitute different column names --->
<!--- by using the columns attribute --->
<hr>
Now using replacement column names<br>
<cfhttp method="Get"
url="http://127.0.0.1/orders/june/orders.txt"
name="juneorders"
columns="ID,Number,ODate,SDate,Name,Address"
delimiter=",">
<cfoutput query="juneorders">
Order ID: #ID#<br>
Order Number: #Number#<br>
Order Date: #SDate#<br>
</cfoutput>
3 Substitute the URL with the location of your text file.
4 Substitute the name of a text file and the column headers to those in your text file.
5 Save the file as querytextfile.cfm in myapps under your Web root directory and
view it in your browser.