Very Computer

by **Ton?** » Wed, 26 May 1999 04:00:00

Hi,

I'm working with the web companion and I'm trying to figure out how I
can let my users type in one word and search for that word in several
fields in the database.
To be exact, I want them to type in one word which will be searched for
in the title, theme and description fields in the database. I can set up
a search form with cdml for the three seperate fields, but forcing my
users to type in the same word in three fields isn't really a solution
Alternatively, I'm trying to figure out the possibilities for copying
the contents of the one field to two ohter (invisible) fields and work
from there...But so far I haven't been able to do that either..

Anyone got any suggestions??

Thanks in advance

Ton

by **Paul E. Est** » Fri, 28 May 1999 04:00:00

> Hi,

> I'm working with the web companion and I'm trying to figure out how I
> can let my users type in one word and search for that word in several
> fields in the database.
> To be exact, I want them to type in one word which will be searched for
> in the title, theme and description fields in the database. I can set up
> a search form with cdml for the three seperate fields, but forcing my
> users to type in the same word in three fields isn't really a solution
> Alternatively, I'm trying to figure out the possibilities for copying
> the contents of the one field to two ohter (invisible) fields and work
> from there...But so far I haven't been able to do that either..

> Anyone got any suggestions??

> Thanks in advance

> Ton

Hi Ton,

Create a calculation result text

title & "?" & theme & "?" & description

Have the users search that field.

Paul E.

--
To reply via email remove n s p a m.

by **Ton?** » Fri, 28 May 1999 04:00:00

Thanks...

Sometimes solutions are so simple you overlook them.....

> Hi Ton,

> Create a calculation result text

> title & "?" & theme & "?" & description

> Have the users search that field.

> Paul E.

> --
> To reply via email remove n s p a m.

by **Michael Caufma** » Fri, 28 May 1999 04:00:00

Maybe try something like a calculation field that combines the fields that
you need....then use this field for your searching. I think that this would
have to be a stored calculation to work properly.....
--
Mike Caufman

(remove the space between the y and . to reply)

----------

> Hi,

> I'm working with the web companion and I'm trying to figure out how I
> can let my users type in one word and search for that word in several
> fields in the database.
> To be exact, I want them to type in one word which will be searched for
> in the title, theme and description fields in the database. I can set up
> a search form with cdml for the three seperate fields, but forcing my
> users to type in the same word in three fields isn't really a solution
> Alternatively, I'm trying to figure out the possibilities for copying
> the contents of the one field to two ohter (invisible) fields and work
> from there...But so far I haven't been able to do that either..

> Anyone got any suggestions??

> Thanks in advance

> Ton

Very Computer

web one entry for multiple field search??multiple

web one entry for multiple field search??multiple

web one entry for multiple field search??multiple

web one entry for multiple field search??multiple

web one entry for multiple field search??multiple