Sams Teach Yourself ColdFusion® in 21 Days

Troubleshooting Insert and Update Operations

If you don't see the confirmation message for either the insert or update page, check the following:

• Does your datasource point to a database or table that is password protected? If so, you'll need to specify the username and password in the datasource setup to enable ColdFusion to "write" data to your table.

• Do all the field names posted by your form exactly match those in your table? If you've added any form fields for other purposes, ColdFusion might be trying to insert or update those, and won't do so because it can't find a matching field in the table. If this is the problem, specify which forms you want to be updated or inserted by using the formfields parameter in your <CFINSERT> or <CFUPDATE> ...