Hi

I'm pretty new to ASP, and am struggling with a piece of code and can't figure it out. Fron a HTML form search box, the database is supposed to be searched. But isn't not working.

I am getting this error


Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/totalreddwarf/fansite_directory/searchdb.asp, line 27

This is my code

Dim searchStr, MyConn, RS, i

searchStr = Replace(Request.Form("strSearch", "'", "''"

Set MyConn=Server.CreateObject("ADODB.Connection"

MyConn.Open "totalreddwarf1"

SQL = "SELECT * FROM tblFansites WHERE tblFansites.SiteDescription"
SQL = SQL & "LIKE '%"& strSearch & "%' "

Set RS = MyConn.Execute(SQL)

If searchStr <> "" Then
If RS.BOF AND RS.EOF Then
Response.Write "<center> No Records Found.</center>"
Else
Response.Write "<center><table border=""1""><tr>"
For i= 0 to RS.Fields.Count - 1
Response.Write "<th>" & RS(i).SiteTitle & "</th>"
Next

Response.Write "</tr>"
While Not RS.EOF
Response.Write "<tr>"
For i= 0 to RS.Fields.Count - 1
Response.Write "<td>" & RS(i) & "</td>"
Next
Response.Write "</tr>"
RS.MoveNext
WEND
Response.Write "</table>"
End If

Else
Response.Write "<center>No Search String Entered.</center>"

End IF

RS.Close
MyConn.Close
Set RS = Nothing
Set MyConn = Nothing


Can anyone see what I'm doing wrong?

Many Thanx

Paul

What part of this code is line 27?

Edited by - vfarcic on 09/28/2001 17:51:02

Hiya


Set RS = MyConn.Execute(SQL)


is line 27 but I have a feeli9ng that is't something to do with the line before it

Paul

Yuo've used two different variable names:

Dim <b>searchStr</b>, MyConn, RS, i

<b>searchStr</b> = Replace(Request.Form("strSearch", "'", "''"

Then later on:

SQL = SQL & "LIKE '%"& <b>strSearch</b> & "%' "

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Oh yeah ! Doh! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I'll give it a try, thanx very much <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Paul