CF / MS Access : Number of query values and destination fields are not the same.
hi newbie here with a Microsoft Access & Cold Fusion problem.
Im seem to be having some problems with a simple form that sends data post method to fusebox.cfm
The fusebox.cfm is supposed to take the variables and put it in my Microsoft Access DB. Unfortunately, I get an error that says:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
The database has 4 tables: quote, user, distribution_profile, picture
the relations are:
1 to many - disribution_profile to picture (distribution_id to pic_distribution_id)
1 to many - distribution_profile to quote (distribution_id to quote_distribution_id)
1 to many distribution_profile to user (dist_user_id to user_id)
I figured it out,
the values were sending 2 '#FORM.other_comments#', instead of one.
:confused: Another problem: Now my Access database has duplicate entries. It appears the form processes it more than once and I get duplicates :eek: