Summary

In this chapter, you have learned how to connect to a data source and perform various data manipulation operations on it. The <CFQUERY> tag performs a number of data operations. This chapter also presented an overview of SQL and covered the use of <CFQUERY> in conjunction with SQL. Alternatives to using SQL statements, such as SQL Builder, were also discussed. Security issues arise when you pass parameters in a query. These issues can be resolved by using the <CFQUERYPARAM> tag.

In the next chapter, you'll learn the various security levels and how to implement them in ColdFusion MX applications.