Database search which ranks results
Currently using DataAssist 1, although thinking about upgrading to 2. ASP and Access DB.
As part of a shop I'm building I would like to include a simple keyword search box which looks for matches across 2-3 fields. I would like the results to be listed in order of relevance. Is this possible?
i.e. search page results are filtered on three fields - manufacturer, model and description. If the user enters "remo pinstripe", how can I make sure that the resulting recordset lists the most relevant records first?
Is it possible to weight the results toward a particular field, for example, the manufacturer?
I'm not quite sure how best to set-up the search in DataAssist. Should I just add one item which is set to compare with all of the columns I want to search or should I add a separate line for each of the columns I want to search and use the AND and OR separator?
I'm also not clear on the difference between a "value" and a "keyword".
Sorry, lots of questions. I hope someone can help. Thanks.