M
Miguel Dias Moura
Hello,
I have a search form in an ASP.NET/VB page.
The form has the input text box and the button "search".
The keywords are passed in the URL to results.aspx.
Here is an example:
results.aspx?search=asp%20book%20london
(%20 means for space)
I used the words "asp", "book", "london".
Each database record has 2 fields: "title" and "description".
I want to display all the records where at least one of the keywords is
found in any of the 2 fields "title" and "description".
1. I suppose I need to get the words out of the URL to be used by SQL.
Am I right? How can I do this?
2. How should the SQL look?
I have been applying filters but never something as complex as this
search.
Thanks,
Miguel
I have a search form in an ASP.NET/VB page.
The form has the input text box and the button "search".
The keywords are passed in the URL to results.aspx.
Here is an example:
results.aspx?search=asp%20book%20london
(%20 means for space)
I used the words "asp", "book", "london".
Each database record has 2 fields: "title" and "description".
I want to display all the records where at least one of the keywords is
found in any of the 2 fields "title" and "description".
1. I suppose I need to get the words out of the URL to be used by SQL.
Am I right? How can I do this?
2. How should the SQL look?
I have been applying filters but never something as complex as this
search.
Thanks,
Miguel