Inserting Porblem

<i><b>Originally posted by : Shawn</b></i><br />hi..... <br />I have a problem. I have a table consisting 4 columns. <br />The first column is for auto assignation of product number. And in my web page....there are only 3 text boxes for inserting value into the rest of the 3 column. <br /><br />I get the following error. Is there anway to solve this problem. <br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same. <br /><br /><br />Thanx<br />

<i><b>Originally posted by : RHarper (rish@gte.net)</b></i><br />I am not certain how you are doing this but this is how I do it.<br /><br />The error is stating that the number of items to be inserted does not match the number of fields to insert them into.<br /><br />Solution: <br /><br />Instead of using the <br /><br />INSERT INTO table VALUES 'Value1',Value2,'Value3')<br /><br />Define the Fields you are using like this:<br /><br />INSERT INTO Table (Field1, Field2, Field3) VALUES ('Value1', Value2, 'Value3')<br /><br />Each Values in the second set of parenthesis will exactly match the fields in the first set of parenthesis.<br /><br />If you have questions, feel free to email me at rish@gte.net.<br /><br />I hope this helped,<br />Rick<br /><br /><br /><br /><br />------------<br />Shawn at 2/16/2000 1:55:53 AM<br /><br />hi..... <br />I have a problem. I have a table consisting 4 columns. <br />The first column is for auto assignation of product number. And in my web page....there are only 3 text boxes for inserting value into the rest of the 3 column. <br /><br />I get the following error. Is there anway to solve this problem. <br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same. <br /><br /><br />Thanx<br />