O'Reilly logo

macromedia® Coldfusion® MX 7 Web Application Construction Kit by Angela Buraglia, Leon Chalnick, Raymond Camden, 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 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 last 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.cfm file in the ows/sql directory. You will see a series ...

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