Tables Records are not recording everything

I have created and connected a table to store the form records.

As you can see in the screenshot, all the fields are selected to be stored in the DB.
[attachment=1]Screen Shot 2013-05-28 at 12.07.27 PM.png[/attachment]

But when using "Show Data", the record does not display all the fields.
[attachment=0]Screen Shot 2013-05-28 at 12.01.37 PM.png[/attachment]

What am I doing wrong?

Hi modernmagic,

What columns do you see in the database table if you check it with PHPMyAdmin?

Bob

The db matches the Record View:[attachment=0]Screen Shot 2013-05-31 at 10.44.12 AM.png[/attachment]

What am I doing wrong that all 27 fields are not getting saved to the db?

Here is the live form: http://www.drjillgoldman.com/resource-center/forms/consent-form.html

Hi modernmagic,

Did you add more inputs to the form after creating the table? If so, this FAQ may help.

Bob

Yes, I had added more inputs.

I dropped the table and created a new one in CF. Now I see all 27 columns in the DB.

I'm new to CF. Thanks for your help.