I. Create data base

• Create a data base that is ODBC complient eg. MS Access 7.0

(ODBC means Open Data Base Connectivity)

II. Create data source

• In the Cold Fusion Administrator, select data sources
• Click add to add data source
• Name data source
• Select database for this data source

III. Verify data source

• In the Cold Fusion Administrator select data sources
• Highlight data source to verify
• Click verify

IV. Inserting data (ch. 6)

• HTML form
• CFINSERT

V. Slecting and displaying data (ch. 5)

• CFQUERY
• CFOUTPUT
• CFTABLE
• Dynamic parameters
  Form fields
  URL parameters

VI. Updating data (ch. 6)

• CFUPDATE
• Delete

VII. Crystal Reports (ch. 14)

• Create crystal report
  • Using the wizard
  • Using SQL queries
• CFREPORT

 

Hope everything went fine. If any problems encountered submit request to IM3 Support

If you have comments or suggestions, email me at antoniov@utep.edu