Robbe
Mon May 02 22:12:36 CDT 2005
That is kind of a poor assignment on your teacher's part. Microsoft Access
is not the proper tool for such an endeavor. You'd never write a
search engine in a database not suited for use in a web environment at a
real
job or you'd get laughed out of the office.
Not to mention Access isn't capable of applying sql search characteristics
to stored binaries such as .doc, .xls, .ppt, or other formats.
I'd have hoped your teachers were more concerned with your need
to learn applicable skills...
The proper tool for this in Microsoft Index Server.
I can't think of a better option off the top of my head to complete
your assignment short of LIKE clauses dynamically built from
each word of the search criteria (which opens you up to SQL
Injection attacks). Then, as you iterate through
the results, you'd do a total word count and attach it to the DataTable.
At the end, perform a .Select on the DataTable with an order by clause on
your total words found column.
I apologize for the weak response but I'm not used to being forced
to use the wrong tools to solve problems.
--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.masterado.net/home/listings.aspx
"Martin Williams" <wildstar@nospam.net> wrote in message
news:ytOdnWSFbIwxVevfRVn-sQ@comcast.com...
>i have an assignment for school that requires me to create a web search
>page
> and rank the results. however, we are to use an access database and not
> SQL. we have to come up with a custom ranking system. are there any
> examples of this anywhere? i'm not even sure how to start.
>
>