ChartDirector 6.0 (ColdFusion Edition)

Database Sample Code Overview


All ChartDirector database sample scripts described in this documentation are based on the sample MS Access database "sample.mdb" included in the "cfdemo" subdirectory.

To run this example, you need to set up the sample data source first. Please use your ColdFusion Administrator to create a data source as follows:

The "sample.mdb" is a MS Access database that contains only one table called "Revenue" . The table stores the monthly revenue data for three business units - Hardware, Software and Services. It contains four columns as follows:

Column NameType
TimeStampDate/Time
HardwareNumber
SoftwareNumber
ServicesNumber

Each row in the database table contains monthly revenues for the business units, where the date is stored in the "TimeStamp" column. The sample database contains rows from Jan 1990 to Dec 2001.