Update Statement
The update statement should be reasonably self-explanatory, having an insertData property like the insert statement. Contents of the insertData property (a structure) are mapped directly to columns in the database. So for example if the database table has a "productid" column and the insertData structure contains a "productid" structure key, the value associated with that key will be inserted into the productid column. Instead of throwing an error like CFUPDATE, structure keys which do not map to columns in the table are ignored.
Update statements can also be filtered.
The Update object has these properties:
| Property | Default | Description |
|---|---|---|
| table | n/a | The table from which data is returned |
| insertData | n/a | a structure containing data to insert into the table |
| insertNulls | false | boolean - if true, null values will be inserted into any columns not represented in the insertData structure |
| insert | true | boolean - if true an insert will be performed if no data is modified during the update - defaults to false if the statement has no filters |
| setnull | n/a | a comma delimited list of columns to set null during update |
| include | and | and/or - indicates whether filters are cumulative (and) or mutually exclusive (or) |