multiple word keyword search in ASP.NET

[reyn]

I want to find this book: The history of Columbia's rebels
here is my SQL Query:

Select * from Project (Title Like ("*columbia*rebels*")) OR (Description Like ("*columbia*rebels*"))

this works in Access but not in ASP.NET ... whats wrong?

this is my SQL statement in ASP.net

Select
....
WHERE (Project.Title LIKE '*'+ keyword +'*') OR (Project.Description LIKE '*'+ keyword +'*')

keyword is assigned to a textbox control.....

whats wrong?

[balabaster]

That would be because * isn't a valid T-SQL wildcard - try replacing it with % and you should be golden.

In addition, if you turn on FullText searching in your SQL database, you can use the contains keyword:

Select * From MyTable Where Contains(Field1, 'FieldSearchValue') Or Contains(Field2, 'OtherFieldSearchValue)

But, you have to turn FullTextIndexing on your database and on the fields you want FullText indexed in order to use that option.

[reyn]

That would be because * isn't a valid T-SQL wildcard - try replacing it with % and you should be golden.

In addition, if you turn on FullText searching in your SQL database, you can use the contains keyword:

Select * From MyTable Where Contains(Field1, 'FieldSearchValue') Or Contains(Field2, 'OtherFieldSearchValue)

But, you have to turn FullTextIndexing on your database and on the fields you want FullText indexed in order to use that option.

-----------------------------------------------------------------------------------

I'm using an Access database where do you go to turn fulltext searching on ?

[balabaster]

Okay, I've got a chunk of code I use here that works that will do what you're looking for:

Dim InputData As String = "FindMe"
Dim oCon As New OledbConnection(...ConnectionString...)
oCon.Open
Dim oCmd As New OledbCommand("Select * From Table Where (Field1 Like @FindVal1) Or (Field2 Like @FindVal2)", oCon)
oCmd.Parameters.Add(New OledbParameter("FindVal1", "*"& InputData & "*"))
oCmd.Parameters.Add(New OledbParameter("FindVal2", "*"& InputData & "*"))
Dim oRdr As OledbDataReader = oCmd.ExecuteReader()
If oRdr.HasRows Then
  While oRdr.Read()
    'Do stuff
  End While
End If
oRdr.Close()
oCmd.Dispose()
oCon.Close()
oCon.Dispose()

Sorry - when I read you got it working in access, I guess my brain interpreted it as you were trying to use SQL Server...not ASP.NET