Yugiohwiz Posted May 6, 2006 Share Posted May 6, 2006 ERRORColumn count doesn't match value count at row 1 I have this error how do I fix it Link to comment Share on other sites More sharing options...
aspnetguy Posted May 8, 2006 Share Posted May 8, 2006 what is your table structure??? What is the query you are using??? Link to comment Share on other sites More sharing options...
Jack McKalling Posted May 10, 2006 Share Posted May 10, 2006 As for the INSERT query, keep in mind it needs for both columns and values the same amount of fields. INSERT INTO table (column1,column2,column3) VALUES ('value1','value2','value3')You may have forgotton to specify the columns, when you did not had a value for all the collumns. There are four rules for the INSERT query:-Values must be in the same order as the column names.-A partly column list is allowed-A columnlist is not prohibited-The columnlist and the values list must be in the same length Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now