ColdFusion cfdbinfo tag example: how to get column list from a table
cfdbinfoColumns.cfm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<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>
No comments:
Post a Comment