Problem with inserting values into an access db
I have a problem with using an ASP page and i am trying to insert values from a repeating table that is being updated by a recordset. this is the error it gives.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
/parts_db/project4/partpick.asp, line 115
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:
POST 16088 bytes to /parts_db/project4/partpick.asp
POST Data:
Inventory=ACTV1635&Description=RECEIVER%2C+OPTICAL+-+590812&PartNo=590812&Price=1597.67&amount=25&Request+ID=&Submit=Add&Inventory=ACTV8201&Description=TRANSMITTER%2CSGL+ISOLATED+UNCOOLED+DISTR+FEEDBA . . .
Time:
Tuesday, March 29, 2005, 8:42:35 AM
here is a screenshot of the page http://www.goofu.net/screen.jpg
Vincent Puglia posted this at 16:25 — 7th April 2005.
They have: 634 posts
Joined: Dec 1999
Without seeing any code, anybody's guess is as good as another. So, mine is: you are/are not looping properly --> that is, loopCounter = 0 or 1 dependent upon language
Where the world once stood
the blades of grass cut me still
chrishirst posted this at 06:47 — 12th April 2005.
He has: 379 posts
Joined: Apr 2005
that error is caused by having a different number of fields to the number of variables you are inserting/updating
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.