Enhancing Application Functionality with Programming Events (ColdFusion)

You've probably noticed that until now you've built your Task Management application without having to deal with the programming code. CodeCharge Studio can help you build fairly functional systems without any programming; however creating more sophisticated systems will require a certain amount of programming code. Fortunately, CodeCharge Studio makes programming easy by providing you with a first-rate code editor, in addition to Events and Actions that aid you in inserting pre-programmed snippets of code into the right place within the program.

Here are the definitions of Action and Event:

Actions

User-definable code generation component, which inserts block of code into an event procedure. CodeCharge Studio comes with several predefined Actions, which are installed into the following folder: (CCS folder)\Components\Actions. Internally, actions consist of XML and XSL code that can be easily customized. For example an action can be set on a Textbox to validate the e-mail address.

Events

Events are the best place for putting custom programming code.

ColdFusion Server Side Database Connection

Although your Design time connection when using ColdFusion can be made directly to an Access database, the Server side connection has to be configured differently from the Design connection. In the case of ColdFusion the Server side connection has to be made to a registered data source. If you are using ColdFusion 4.01, you will need to make the connection using an ODBC DSN. For higher versions of ColdFusion such as version 5.0 or MX, you can use any data source that has been registered in the ColdFusion administrator. For more information about ColdFusion database connections, please refer to the section on ColdFusion Server side connections.

Topics

• Step 1
  1. Use the Before Show Row Event to Alter Text Color
  2. Programmatically Control Field's Value
  3. Preview Tasks List Page
• Step 2
  1. Modify a Label Field on the Task Maintenance Page
  2. Use the Before Show Event to Alter a Label's Value
• Step 3
  1. Add a Hidden "Assigned By" Field to Auto-Update New Tasks
  2. Add a Hidden "Date Created" Field to the Record Form
  3. Test the Label and Hidden Fields
• Step 4
  1. Programming the Record Form
  2. Add Code in the After Insert Event to Send Emails
  3. Use the After Update Event to Send Emails
  4. Test Email Delivery
• Step 5
  1. Implement Record Security in After Initialize Event