cfdiv bind - show query data without page refresh
cfdivBind.cfm
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>cfdiv bind: how to show query data without page refresh in coldfusion</title>
</head>
<body>
<h2 style="color:Crimson; font-style:italic">cfdiv tag example: how to show dynamic data</h2>
<hr width="500" align="left" color="Crimson" />
<br />
<cfquery name="qEmployeeID" datasource="cfdocexamples">
SELECT Emp_ID, FirstName FROM Employees
</cfquery>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="SeaGreen">
<tr>
<td colspan="2" bgcolor="DarkSeaGreen" style="color:Snow; font-size:large" align="center">
Explore Employee Details
</td>
</tr>
<tr valign="top">
<td style="color:DarkSeaGreen; font-weight:bold">
Select Employee
</td>
<td >
<cfform name="CalendarSelectedDateTest" method="post" format="html">
<cfselect name="EmployeeID" query="qEmployeeID" value="Emp_ID" display="FirstName" />
</cfform>
</td>
</tr>
</table>
<br />
<cfdiv id="EmployeeDiv" bind="url:EmployeeDetails.cfm?Emp_ID={EmployeeID}">
</body>
</html>
EmployeeDetails.cfm
<cfparam name="url.Emp_ID" default="0">
<cfif url.Emp_ID gt 0>
<cfquery name="qEmployee" datasource="cfdocexamples">
SELECT Emp_ID, FirstName, LastName, Email, Department FROM Employees
WHERE Emp_ID= #url.Emp_ID#
</cfquery>
<table border="1" cellpadding="5" cellspacing="0" bordercolor="Orange">
<tr valign="top" style="color:Snow; background-color:OrangeRed; font-weight:bold">
<td>
Employee ID
</td>
<td>
First Name
</td>
<td>
Last Name
</td>
<td>
Email
</td>
<td>
Department
</td>
</tr>
<cfoutput query="qEmployee">
<tr valign="top" style="color:OrangeRed;">
<td>
#qEmployee.Emp_ID#
</td>
<td>
#qEmployee.FirstName#
</td>
<td>
#qEmployee.LastName#
</td>
<td>
#qEmployee.Email#
</td>
<td>
#qEmployee.Department#
</td>
</tr>
</cfoutput>
</table>
</cfif>