Hi I'm stuck. I have written some ASP to search my database but i want the user to be able to "match atleast one of the words in the database" I've put the search string into an array but have no idea how to go about putting the array into the SQL. Can anyone help?
Heres the code where i select.
If SC ="morethan1" THEN
Dim sentencewords
aWords = split(SearchText, " ")
'Open our recordset
SQL = "SELECT * from advert WHERE (((table.title) = '%" & awords & "%')) OR (((table.bf) = '%" & SearchText & "%')) OR (((table.type) = '%" & awords & "%'));"
rs.Open SQL, objConn
End if
Many thanks if anyone can help
Heres the code where i select.
If SC ="morethan1" THEN
Dim sentencewords
aWords = split(SearchText, " ")
'Open our recordset
SQL = "SELECT * from advert WHERE (((table.title) = '%" & awords & "%')) OR (((table.bf) = '%" & SearchText & "%')) OR (((table.type) = '%" & awords & "%'));"
rs.Open SQL, objConn
End if
Many thanks if anyone can help