SELECT Problems

Thpuffer · June 19th, 2006, 04:26 PM

this is my code.

Select Case UCase (Request.QueryString("view"))
    Case "ALL"
        sqltext = "SELECT * FROM Jobs WHERE status=1 "
    Case Else
        TheMessage = "Search Results"
        sqltext = "SELECT * FROM Jobs "
        sqltext = sqltext & " WHERE " & varin
        sqltext = sqltext & " AND status=1"
        sqltext = sqltext & " LIKE '%" & varfind & "%'"
End Select

and this is the result.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/jobs/results.asp, line 24

Browser Type:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.2)

it does this in either case.

rstelma · June 19th, 2006, 05:06 PM

Looks like you need some more information before the LIKE.

Something like:

Code:

sqltext = sqltext & " AND [Column Name] LIKE '%" & varfind & "%'"

Best thing to do is put this code on your page and post the results here.

Code:

Response.Write "<br>This is sqltext: " & sqltext
Response.End