update database

[member 37483]

I am trying to update a database and I keep getting an error that says:
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.


When I verify my query through frontpage it goes through correctly, all my fields are named correctly and match my form fields. Can someone tell me what this problem is?
John

 

[DRowland]

You have to be sure that every field us use in filtering your results, is a valid field, and has something in it. A blank field will not work, if it is used in query language.
Also, check your page with html, and make sure the language looks right. You may have entered a wildcard item incorrectly.

I have that problem a lot. I have to double check stuff 6-8 times, before I can get it right.. Just slow, I guess.