ColdFusion CFDIV Bind - Show query data without page refresh

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>









More coldfusion examples