O'Reilly logo

Adobe ColdFusion 9 Web Application Construction Kit, Volume 2: Application Development by Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 37 Using Stored Procedures

IN THIS CHAPTER

Why Use Stored Procedures? 397

Calling Stored Procedures from ColdFusion Templates 398

Most server-based database systems—SQL Server, Oracle, and MySQL—support stored procedures. A stored procedure is a chunk of SQL code that’s given a name and stored as a part of your database, along with your actual data tables. After the stored procedure has been created, you can invoke it in your ColdFusion templates using the <cfstoredproc> tag.

NOTE

The use of stored procedures in database applications is a relatively advanced topic. It’s not rocket science, but you will be more comfortable working with stored procedures if you are familiar with the SQL concepts introduced in the previous chapter or have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required