Anthony Trotter
|
| Posted: 07/10/2001, 2:38 AM |
|
CC Version: 1.1.16
Lang: ASP 2.0
I am getting the following the following error when searching:
------------------------------------------------------
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters
/Common.asp, line 27
------------------------------------------------------
Contained in common.asp by line:
------------------------------------------------------
24 sub openrs(rs, sql)
25 Set rs = Server.CreateObject("ADODB.Recordset")
26 rs.CursorLocation = adUseServer
27 rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText
28 end sub
------------------------------------------------------
I am searching on search.asp which posts to results.asp. I have four
text boxes and a list box. I tried adding data to each form field and
it didn't fix the problem. The worst part is that this was working a
couple of weeks ago. I just don't know what I changed.
Any help would be appreciated.
Anthony
|
|
|
 |
Anthony Trotter
|
| Posted: 07/10/2001, 3:24 AM |
|
Problem solved.
On my results.asp page under Form Properties > SQL > Where, I had the
field name wrong. Can't search a db with a wrong where clause : )
"Anthony Trotter" <support@worldnetcity.com> wrote in message
news:9ieiff$3u1$1@news.codecharge.com...
> CC Version: 1.1.16
> Lang: ASP 2.0
>
> I am getting the following the following error when searching:
> ------------------------------------------------------
> Microsoft JET Database Engine error '80040e10'
> No value given for one or more required parameters
>
> /Common.asp, line 27
> ------------------------------------------------------
>
> Contained in common.asp by line:
> ------------------------------------------------------
> 24 sub openrs(rs, sql)
> 25 Set rs = Server.CreateObject("ADODB.Recordset")
> 26 rs.CursorLocation = adUseServer
> 27 rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly,
adCmdText
> 28 end sub
> ------------------------------------------------------
>
> I am searching on search.asp which posts to results.asp. I have
four
> text boxes and a list box. I tried adding data to each form field
and
> it didn't fix the problem. The worst part is that this was working
a
> couple of weeks ago. I just don't know what I changed.
>
> Any help would be appreciated.
>
> Anthony
>
>
>
>
|
|
|
|
|
