A dynamic form is an HTML form generated by a cfm file that uses elements created with database query results and CFML. |
This example shows a select list of employees' names that is created with a query against the employees table. |
<CFQUERY NAME="EmpName" DATASOURCE="CF 3.0 Examples"> |
SELECT Employee_ID, LastName, FirstName |
FROM Employees |
</CFQUERY> |
<FORM ACTION="example.cfm" METHOD="post"> |
<SELECT NAME="Employee_ID"> |
<CFOUTPUT QUERY="EmpName"> |
<OPTION VALUE="#Employee_ID#">#LastName#, #FirstName# |
</CFOUTPUT> |
</SELECT> |
<INPUT TYPE="submit" VALUE="Submit"> |
</FORM> |