• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

form fields for two tables

Guest
Apr 18, 2006 Apr 18, 2006

Copy link to clipboard

Copied

How can I get different form fields to pass data to two different tables.
I have a very large form with about 2000 cells and SQL only holds 1024.
I can retrieve data from the tables with queries, but the second half of the form will not submit data to the second table.
An error message says that the column cannot be found in the first table.
Any help will be appreciated.
Thanks.
TOPICS
Advanced techniques

Views

329

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 18, 2006 Apr 18, 2006

Copy link to clipboard

Copied

You might have attempted to insert or update form data into the first table, that was meant for the second table. Why don't you code the names of the form fields with indices, e.g. fieldname_1, fieldname_2, which immediately tells you which table the data will go to.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 18, 2006 Apr 18, 2006

Copy link to clipboard

Copied

It's very easy as long as you are using cfquery and not cfinsert.

What percentage of your users do you expect to fill out all 2000 form fields?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Apr 18, 2006 Apr 18, 2006

Copy link to clipboard

Copied

LATEST
What percentage of your users do you expect to fill out all 2000 form fields?
100%, assuming, of course, Chief13 works for the IRS.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation