help: creating an effective search result

[mark | r]

we have a MSAccess database of products with titles, short descriptions,
long descriotions, bulletpoints etc contained for each product.

we currently search the database looking for the target keyphrase within the
fields, but this doesnt give any accurate results as for example a product
that is compativle with "widget 1" is shown before "widget 1"

anyone know of a process that will give us better, more relevant search
results?

mark

[Bob Barrows]

Re: creating an effective search result

mark | r wrote:[color=blue]
> we have a MSAccess database of products with titles, short
> descriptions, long descriotions, bulletpoints etc contained for each
> product.
>
> we currently search the database looking for the target keyphrase
> within the fields, but this doesnt give any accurate results as for
> example a product that is compativle with "widget 1" is shown before
> "widget 1"
>
> anyone know of a process that will give us better, more relevant
> search results?
>
> mark[/color]

Sorry. Can't help without more details. Perhaps if you showed us a few rows
of sample data (just the minimum number of fields to illustrate the
problem), the query you are currently using to search the data, the
incorrect result you are getting, and the result you want to get, we would
be better placed to help you.

Bob Barrows


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[mark | r]

Re: creating an effective search result

> > we have a MSAccess database of products with titles, short[color=blue][color=green]
> > descriptions, long descriotions, bulletpoints etc contained for each
> > product.
> >
> > we currently search the database looking for the target keyphrase
> > within the fields, but this doesnt give any accurate results as for
> > example a product that is compativle with "widget 1" is shown before
> > "widget 1"
> >
> > anyone know of a process that will give us better, more relevant
> > search results?[/color]
> Sorry. Can't help without more details. Perhaps if you showed us a few[/color]
rows[color=blue]
> of sample data (just the minimum number of fields to illustrate the
> problem), the query you are currently using to search the data, the
> incorrect result you are getting, and the result you want to get, we would
> be better placed to help you.[/color]

its really easy

id,category(num ber),pname(text ),sdescription( text),bulls(mem o),ldescription (
memo),width(num ber),height(num ber)


mark

[Bob Barrows]

Re: creating an effective search result

mark | r wrote:[color=blue][color=green][color=darkred]
>>> we have a MSAccess database of products with titles, short
>>> descriptions, long descriotions, bulletpoints etc contained for each
>>> product.
>>>
>>> we currently search the database looking for the target keyphrase
>>> within the fields, but this doesnt give any accurate results as for
>>> example a product that is compativle with "widget 1" is shown before
>>> "widget 1"
>>>
>>> anyone know of a process that will give us better, more relevant
>>> search results?[/color]
>> Sorry. Can't help without more details. Perhaps if you showed us a
>> few rows of sample data (just the minimum number of fields to
>> illustrate the problem), the query you are currently using to search
>> the data, the incorrect result you are getting, and the result you
>> want to get, we would be better placed to help you.[/color]
>
> its really easy
>
>[/color]
id,category(num ber),pname(text ),sdescription( text),bulls(mem o),ldescription ([color=blue]
> memo),width(num ber),height(num ber)
>
>
> mark[/color]

How does this help? Please reread my request.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"