Chapter7.SQL Data Manipulation


Chapter 7. SQL Data Manipulation

IN THIS CHAPTER

Adding Data 153

Modifying Data 157

Deleting Data 159

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 of variables that are set, one of which is select_only. This is a flag that is set to yes (the default setting) instructing the utility to only execute SELECT statements. Change this value to no before proceeding (and save the updated Application.cfm) with the examples in this chapter (or an error will be thrown).

When you're done, set the flag back to yes, just to be safe.




Macromedia Coldfusion MX 7 Web Application Construction Kit
Macromedia Coldfusion MX 7 Web Application Construction Kit
ISBN: 321223675
EAN: N/A
Year: 2006
Pages: 282

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net