Click to See Complete Forum and Search --> : Data Save Error


Metroid
08-28-2003, 06:49 AM
http://training.uanet.org/opeval.asp

I am stuck. I am getting an error on submit that I can't seem to find what is wrong. Can someone please offer some light?

Error Below:

Database Save Error [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.

Thanks-in-advance

TBor
08-29-2003, 09:45 AM
Metroid,
Site seems to be PW protected, can you post code? Will need to see the ASP code (not as a loaded ASP page from your server) to help out.

Based on the error though, check the query that's giving you the error and make sure the number of arguments matches the table. For instance, if you're doing an INSERT query and you're trying to insert 11 values into a table that only has 10 fields, it's not going to work.

Until I see the code though, it's hard to say anything for sure.

Hope this helps,
TBor

Metroid
08-31-2003, 02:42 AM
Thanks TBor,

I figured out the problem. One was the database and the other was error in the script.

Thanks,

M.