ColdFusion CFdbinfo - How to get column list from a table

cfdbinfo - get column list from a table

cfdbinfoColumns.cfm


<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ColdFusion cfdbinfo tag example: how to get column list from a table</title>
</head>

<body>
<h2 style="color:DodgerBlue">ColdFusion cfdbinfo tag example: Column List</h2>

<cfdbinfo datasource="cfbookclub" table="Books" type="columns" name="result"> 

<cfquery dbtype="query" name="qColumnList">
 SELECT COLUMN_NAME FROM result
</cfquery>

<cfdump var="#qColumnList#">
</body>
</html>





More ColdFusion examples