Whatever message this page gives is out now! Go check it out!
<cfoutput> |
<cfquery name="GetEmployees" datasource="cfdocexamples"> |
<cfquery name="GetEmployees" datasource="cfdocexamples"> |
<cfquery name="GetEmployees" datasource="cfdocexamples"> |
<html> |
Code | Description | |
| Queries the data source cfdocexamples and names the query GetEmployees. | |
| Retrieves the FirstName, LastName, and Salary fields from the Employee table, but only if the value of the LastName field matches what the user entered in the LastName text box in the form on formpage.cfm. | |
| Displays results of the GetEmployees query. | |
| Displays the value of the FirstName, LastName, and Salary fields for a record, starting with the first record, then goes to the next line. Keeps displaying the records that match the criteria you specified in the SELECT statement, followed by a line break, until you run out of records. | |
| Closes the cfoutput block. | |
| Displays a blank line followed by the text "Contractor": and the value of the form Contractor check box. A more complete example would test to ensure the existence of the variable and would use the variable in the query. |
<cfif IsDefined("Form.Contractor")> |
<cfinput type="Text" name="FirstName" size="20" maxlength="35" required="Yes"> |
<input type="Text" name="FirstName" size="20" maxlength="35"> |
<cfinput type="Text" name="FirstName" size="20" maxlength="35" required="Yes" |
<input type="hidden" name="FirstName_required" |