Miguel,
This is more of a database question than anything because your query
will have to do the heavy lifting. Your query will have to compare each
keyword to your fields. From the ASP.NET side it's easy. Just do a
Split( ) on the textbox value to get an array of keywords. After that, it's
SQL. I'm assuming that you are capable with SQL, so I will suggest that you
pass in the keywords to the query in a comma-separated string. Then in your
query, you can convert this string to a rowset and perform the joins and
comparisons necessary.
For help with your query, I suggest posting to a SQL newsgroup. The ASP.NET
side is easy.
Best regards,
Jeffrey Palermo
"Miguel Dias Moura" <we****@27lamps.com> wrote in message
news:OE**************@TK2MSFTNGP09.phx.gbl...
Hello,
What I know:
To send a Value in the URL and filter the results in order to display
only the database records which FIELD_A = Value.
What I need to do:
I have a page with an Input Text Box and a Search Button.
Each record of my database has 5 fields:
ID, Title, Author, Editor, Date.
In the Input Text Box keywords are entered by the user.
When the Search Button is pressed I want to show all records, in a new
page, which contains one of those keywords in Title, Author or Editor
fields.
Can someone help me out with this?
I am working with Dreamweaver MX 2004 and ASP.Net / VB.
Thank You,
Miguel
