Whatever message this page gives is out now! Go check it out!
<html> |
Code | Description | |
| Places data into a table. | |
| In the first row of the table, includes three columns, with the headings: First Name, Last Name, and Salary. | |
| Tells ColdFusion to display the results of the GetEmployees query. | |
| For each record in the query, creates a row in the table, with three columns that display the values of the FirstName, LastName, and Salary fields of the record. | |
| Ends the output region. | |
| Ends the table. |
<td>#Salary#</td> |
<td>#DollarFormat(Salary)#</td> |
<html> |
Code | Description | |
| Retrieves the fields listed from the Departmt and Employee tables, joining the tables based on the Dept_ID field in each table. | |
| If the user specified a department on the form, only retrieves records where the department name is the same as the one that the user specified. Use number signs (#) in the SQL AND statement to identify Form.Department as a ColdFusion variable, but not in the IsDefined function. | |
| If the user specified a last name in the form, only retrieves the records in which the last name is the same as the one that the user entered in the form. |