Hi Lists,

I hope somebody out there would be able to help with my problem. I have and access database and asp pages that i would like to do a search base on single word, two or more words and phrases but finding some difficulty with it. At the moment i can only do one word search and if i try to do more words it generates an error.

How can i use the code below to search for multiple keywords?

The code i am using is below:

Private Function sqlString(ByVal keyword)
sqlString = "SELECT * FROM qryMetaData "
sqlString = sqlString & "WHERE "
sqlString = sqlString & "((Abstract LIKE '%" & Replace(Keyword, "'", "''") & "%') OR (Title LIKE '% " & Replace(Keyword, "'", "''") & "%')) "

If DataType = "2" then
       sqlString = sqlString & " AND (DATAFORM LIKE '%MapInfo%') "
Elseif DataType = "3" then
      sqlString = sqlString & " AND ((DATAFORM = 'PDF') OR (DATAFORM = 'IMAGE')) "
End if
sqlString = sqlString & "ORDER BY [TITLE] ASC;"
End Function

Any help would be deeply appreciated.
Thank you in advance

Can you explain more on this to help you better.

What is the difficulty you face with it? Is that showing any error? What does Datatype mean in your code there? Is MapInfo a variable/constant? Which part of the query contruction, you are facing difficulty? What is that you are searching for and on which field are you doing that? Is that Title or Abstract?

More questions would arise if the post is very generic not explain where you face the difficulty:)

Cheers!


_________________________
- Vijay G
Strive for Perfection

Hi, I want to be able to do the same thing.
I want to let the user enter multiple words to be searched on.

I have got the code working to return one word, but I don't know how to do it for 2 or more words.

I am using asp with an msaccess database.

Thanks for reading, and hope somebody can help.

This could be done a bit easier in SQL server. As you use msaccess, you will have to do that with some extra effort to get something similar to what it result in sql server.

1) Search for the entire keyword entered.
2) Break the entire keyword into separate words from your frontend and construct the query and search for each word that matches.

This can be done in one step or as two steps, but in anyways there would be performance hit on the db.

Hope that explains.
Cheers!

_________________________
- Vijay G
Strive for Perfection