Too few parameters. Expected 1.
- From: "bobojones" <bobojones69@xxxxxxxxxxx>
- Date: Thu, 18 Jan 2007 14:34:10 -0600
I am getting the following error in my code "Too few parameters. Expected
1." I am getting it on the following line
set rs = conn.Execute(SQLStatement)
When I put in response.write (SQLstatement) I get
SELECT * FROM QPR WHERE Status= Closed
If I change it to set rs = conn.Execute("SELECT * FROM QPR")
it will work.
I need ot be able to use the where clause. This is how I am setting
SQLstatement.
SQLStatement = "SELECT * FROM QPR WHERE Status= " &
Request.QueryString("Status")
Thanks
Bob
.
- Follow-Ups:
- Re: Too few parameters. Expected 1.
- From: Bob Barrows [MVP]
- Re: Too few parameters. Expected 1.
- Prev by Date: Re: asp/sql looping problem
- Next by Date: Re: Too few parameters. Expected 1.
- Previous by thread: asp/sql looping problem
- Next by thread: Re: Too few parameters. Expected 1.
- Index(es):