Re: WebDB Keyword Search Report

mccaffry_at_my-deja.com wrote:

> Just wondering if anyone can give me a hand with a problem I am having
> with WebDB:
>
> I am creating a WebDB report for a table that has a large text column.
> I want to have a keyword search so people can enter in multiple words
> into the search and it will search for all of the words independently
> in the text field (just like a search engine search). Unfortunatly I
> can't figure out how to have WebDB search for all of the words in the
> field independantly. I can only get it to treat it as one big string of
> text. Anyone know how I can add this functionallity?
>

I did create a seach string in a view

 upper ( ( row1 || ' ' || row2 || ' ' ...........' '|| rowX ) keyword_search1,
 upper ( ( row1 || ' ' || row2 || ' ' ...........' '|| rowX ) keyword_search2

then U can
make a select
like

where upper ( keyword1 ) like '%' || keyword_search1 || '%' and upper ( keyword2 ) like '%' || keyword_search2 || '%'

where upper ( keyword1 ) like '%' || keyword_search1 || '%' or upper ( keyword2 ) like '%' || keyword_search2 || '%'

it works in my search

maybe there is even a better one.
let us know.

Regards greg Received on Fri Sep 15 2000 - 04:46:12 CEST