Adobe 38043740 Developing Applications - Page 110

DEVELOPING COLDFUSION 9 APPLICATIONS 105 The CFML Programming Language Error. No employee data was passed. INSERT INTO Employees (FirstName, LastName, Email, Phone, Department) VALUES ( '#attributes.empinfo.firstname#' , '#attributes.empinfo.lastname#' , '#attributes.empinfo.email#' , '#attributes.empinfo.phone#' , '#attributes.empinfo.department#' ) Employee Add Complete Reviewing the code The following table describes the code: Code Description Error. No employee data was passed. If the custom tag was called without an empinfo attribute, displays an error message and exit the tag. INSERT INTO Employees (FirstName, LastName, Email, Phone, Department) VALUES ( '#attributes.empinfo.firstname#' , '#attributes.empinfo.lastname#' , '#attributes.empinfo.email#' , '#attributes.empinfo.phone#' , '#attributes.empinfo.department#' ) Add the employee data passed in the empinfo structure to the Employees table of the cfdocexamples database. Use direct references to the structure entries, not StructFind functions. If the database does not support automatic generation of the Emp_ID key, add an Emp_ID entry to the form and add it to the query. Employee Add Complete Display a completion message. This code does not have to be inside the cfelse block because the cfexit tag prevents it from being run if the empinfo structure is empty. Structure functions You can use the following functions to create and manage structures in ColdFusion applications. The table describes the purpose of each function and provides specific, but limited, information that can assist you in determining whether to use the function instead of other technique. All functions except StructDelete throw an exception if a referenced key or structure does not exist. For more information on these functions, see the CFML Reference. Last updated 1/20/2012