Accessibility

ColdFusion Article

 

A Beginner's Guide to Using Stored Procedures with ColdFusion


Daryl Banttari

Daryl Banttari

Senior Consultant
www.macromedia.com

Table of Contents

  1. Introduction
  2. Background and Benefits of Stored Procedures
  3. The Scenario
  4. Data Requirements
  5. Using ColdFusion To Access Stored Procedures
  6. Result Sets and Oracle
Created:
02 August 2004
User Level:
Beginner, Intermediate

The scenario: You are a ColdFusion developer and your boss has asked you to create a simple web-based employee directory using ColdFusion to access stored procedures that the database administration group of your company created. For security reasons, you can only use stored procedures, not direct queries, to access the data from a sensitive personnel database. How do you succeed at developing the application?

This tutorial will help you understand stored procedure basics. It will also help you figure out what questions to ask your database administrators about the database and define the stored procedures you'd like them to create for you, based on your application needs. You'll build a simple web-based employee directory using ColdFusion tags to access stored procedures.

Requirements

To complete this tutorial you will need to install the following software and files:

ColdFusion MX 6.1

Microsoft SQL Server 2000 (or any database server that supports stored procedures)

Tutorials and sample files:

Prerequisite knowledge: A basic understanding of ColdFusion server and basic use of the CFQUERY tag

Page 1 of 6
Next Page

About the author

Daryl Banttari has been working with computers professionally since 1986, and started using ColdFusion in 1997. He has been a member of the ColdFusion professional services team since 2000.