How to use columns attribute when read a CSV file in ColdFusion

cfhttp - columns attribute when reading a csv file

employee1.csv


1, Jenny, Jones
2, Anne, Joli
3, Sonia, Fara

cfhttpColumns.cfm


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>cfhttp: how to use columns attribute when read a csv file in coldfusion</title>
</head>

<body>
<h2 style="color:IndianRed; font-style:italic">cfhttp tag example: how to use columns attribute</h2>
<hr width="500" align="left" color="IndianRed" />
<br />

<cfhttp 
  method="get"
    url="http://localhost:8500/cfexample/employee1.csv" 
    name="EmployeeData"
    columns="EmpID,FirstName,LastName"
    firstRowAsHeaders="no"
    >
</cfhttp>

<table border="1" cellpadding="5" cellspacing="0" bordercolor="IndianRed">
    <tr bgcolor="Crimson" style="color:White; font-weight:bold">
        <td>
            Employee ID
        </td>
        <td>
            First Name
        </td>
        <td>
            Last Name
        </td>
    </tr>
 <cfoutput query="EmployeeData">
     <tr bgcolor="Snow" style="color:IndianRed; font-weight:normal">
         <td>
                #EmpID#
            </td>
         <td>
                #FirstName#
            </td>
         <td>
                #LastName#
            </td>
        </tr>
    </cfoutput>
</table>

</body>
</html>

More ColdFusion examples