Column count doesn't match value count at row 1

I am running the coldfusion insert into mySQL dataabse and getting the error message
Column count doesn't match value count at row 1 .

I am supplying 21 column to the insert query. THe table inself has 22 columns including the primary key.

 INSERT INTO users( str_fname ,str_mname ,str_lname ,dtt_dob ,str_address1 ,str_address2 ,str_city ,int_country_state_id ,str_state ,str_zipcode ,str_phone ,dtt_date_join ,str_email ,str_school_affiliate ,str_username ,str_password ,str_chapter_check ,bit_course_completed ,str_certificate_details ,bit_version_type ,bit_active ) VALUES( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , null, (param 8) , (param 9) , (param 10) , (param 11) (param 12) , null, (param 13) , (param 14) , null, (param 15) , null, null, (param 16) ) 

Open in new window

LVL 19
erikTsomikSystem Architect, CF programmer Asked:
Who is Participating?
 
_agx_Commented:
You are missing a comma between two of the parameters:


VALUES
(
 ....
, (param 11) (param 12)    <!=== should be a comma in between
, ...
)
0
 
erikTsomikSystem Architect, CF programmer Author Commented:
Thank you, Silly mistake
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.