Chapter 7. SQL Data Manipulation
Chapter 6, “Introducing SQL,” introduced data drivers, data sources, SQL, and data retrieval (using the SELECT statement). You’ll probably find that you spend far more time retrieving data than you do inserting, updating, or deleting it (which is why we concentrated on SELECT first).
Note
As in the previous chapter, the SQL Query Tool in the ows/sql directory will be used to execute the SQL statements. For security’s sake (to prevent accidental data changes) the SQL Query Tool by default allows execution of SELECT statements, but no other SQL statements.
To change this behavior, edit the Application.cfc file in the ows/sql directory. You will see a series ...
Get Adobe® ColdFusion® 9 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
