• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Advanced SQL Topics

You have already learned quite a bit about SQL in this book. In Chapter 5, “Introducing SQL,” you learned how to retrieve records using SELECT, WHERE, and ORDER BY. In Chapter 6, “SQL Data Manipulation,” you learned how to change the data in your database with INSERT, UPDATE, and DELETE and how to use the AS keyword to create aliases. You have also seen how the <CFQUERY> tag lets you create SQL statements dynamically, based on form parameters and other variables.

This chapter introduces you to some additional topics related to querying your databases with Macromedia ColdFusion MX. This section explains certain aspects of SQL that haven't been discussed yet, and which will be particularly relevant when putting together report style pages.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint