Double Search

[Frazer]

Hi Guys,

Does anyone know of a way I can search two fields at once?

My form set up is:

<FORM ACTION="FMPro" METHOD="POST">

<INPUT TYPE="hidden" NAME="-db" VALUE="timetables.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="details">

<INPUT TYPE="hidden" NAME="-error" VALUE="error.htm">

<input type="hidden" name="-Find1" value=" ">

<INPUT TYPE="hidden" NAME="-lop" VALUE="or">

I've included the <-lop "or"> tag because one of the two form elements is a multiple line text box where users can select more than one option.

Thanks,

Frazer

[Garry Claridge]

Frazer,

You can do it this way:

<FORM ACTION="FMPro" METHOD="POST">

<INPUT TYPE="hidden" NAME="-db" VALUE="timetables.fp5">

<INPUT TYPE="hidden" NAME="-lay" VALUE="details">

<INPUT TYPE="hidden" NAME="-error" VALUE="error.htm">

<INPUT TYPE="hidden" NAME="-lop" VALUE="or">

<input type="hidden" name="-op" value="eq">

<input type="text" name="searchFld1" value="">

<input type="hidden" name="-op" value="cn">

<input type="text" name="searchFld2" value="">

<input type="submit" name="-find" value="Search">

I hope this is what you are after. The "searchFld" is where your field names go. I have included the "-op" tags as an example of how you would use different criteria for different fields.

All the best.

Garry

[Keith M. Davie]

In spite of what FileMaker, Inc says about the cdml tags "-op" and "-lop" and their parameters, in spite of the examples which they present, when you try to apply those tags in a form action call you will not get the results you are expecting. That is because they don't work that way. You need to learn how to use the parameters ==, ..., etc. Those which are used by FileMaker Pro. You will find those options in the status bar when you perform a search on your database. You can save yourself a lot of time by abandoning the "-lop" and "-op" tags in your form action calls. Put that time into developing an understanding of the options mentioned. Technical papers on the exact search have been referenced in these Forums in the past week. Find them and use them.

SIMPLIFY ...

Keith