• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 7. Changing the Contents of a Databa... > Troubleshooting Insert and Update Op...

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> tag.

  • If your database seems to be truncating the text you entered from an input form, check the data type for that field. For example, in Microsoft Access, the text data type allows up to only 256 characters. Longer text strings will require you to change the field's data type to memo.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint