Searching Multiple fields

[mattw]

Originally posted by Vaughan:

Join up all of the text fields into a calculation field (field1 & field2 & ...) then perform a single search on the calculation field!

Can anyone give an example of this ?

Thanks in advance,

[CaelC]

I'm not sure what the original question was but you can search multiple fields in CDML enabled solutions by using the -OP and -LOP command tags inside hidden inputs in a form to string together the fields for the find with an "And" .

Hope this helps,

Cael.

[Vaughan]

Nope, do it in the database. Maake a calculation field:

field3 = field1 & field2 where all aree text fields.

Now in your cdml, perform the search on field3.

[mattw]

Thanks guys,

I did the calculation in the database

Works great!

Matt

[mattw]

Thanks guys,

I did the calculation in the database

Works great!

Matt