Column count doesn't match value count at row 1

[ashay]

I am getting this error when I am inserting into a table of 124 fields only 64 fields..
from what knowledge I have..i can do that if i explicitely mention the column names...which I do.

can anybody help me what other problem can it be?

[non_zero]

could you rephrase that?

[ashay]

I have a table of 124 fields.
I am insert into it only 64 fields.
its not allowing me to do so and throwing out an error which is the subject line up there.
But i read some where that if you explicitely indicate the table fields in ure insert statement...you can insert lesser no of columns than what exactly are there in the table...
so can anyone suggest me a solution so that i can insert only the 64 fields I want to insert

[maxtran2005]

I have about 100 fields. I only want to colect 80 fieldnames and insert into my database. Can someone show me how? Thanks much.

[laserlight]

But i read some where that if you explicitely indicate the table fields in ure insert statement...you can insert lesser no of columns than what exactly are there in the table...

That's true, but this explicit naming of columns must also match the list of fields to be inserted for the new row. You can insert fewer fields than there are columns in the table, but you cannot insert fewer fields than there are columns named for insertion in your new row.

[jeepin81]

Post some code, so we can take a look at what you are working w/ and possibly see a solution.

Best-
J.