Too few parameters. Expected 1.

K

Ken

I have the query below on a page but when I load the page I get an error
stating Too few parameters. Expected 1. The query will work if I insert it
in access but not through the web page.
Any suggestions

Ken

fp_sQry="SELECT * FROM Action_Items WHERE (((Action_Items.Due_Date)<Date())
AND ((Action_Items.Current_Status)=""open"")); "
 
T

Thomas A. Rowe

Means one of the value of the following is missing or incorrectly passed:

Action_Items.Due_Date
Action_Items.Current_Status

To determine which value is missing or incorrect add the following right
after the query;

Response.Write fp_sQry

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

too few parameters 5 expected 2
Run-time error 3061. Too Few Parameters. Expected 2. 2
Too few parameters error with a IIF statement 5
Query parameters in combo box 1
Too few parameters exporting to text 14
Access 2000 Too Few Parameters: Expected 1 3
Too few parameters. Expected 2 1
On Export I get: Too few parameters, expected 2? 1

Top