AND Portal Search

[glasnost]

I am new to Filemaker and have inherited a single table db which is published via the web companion and uses a single search page built using HomePage 3.0. The database holds information on accommodation for students such as location, size, smoker - non-smoker preferred etc.

The problem I have is that users can only do OR searches in the form therefore if they choose a room for a non-smoker in a particular area it pulls back all non-smoker rooms and also all rooms in said area. I need to do an AND search but changing the -LOP value in the search page to AND results in no records being found. The search page uses dropdowns and checkboxes built on value-lists and so I am not sure how to base a search on a concatenated field made up of the necessary fields.

Instant web publishing seems to allow for AND searches so why not other HTML search pages?

Can anyone help?

[Garry Claridge]

Without seeing the whole Form it may be a bit hard to see why the AND search is not working.

All the best.

Garry

[glasnost]

Hi Garry,

Form can be found online here http://www.accom.gla.ac.uk/pad/FMPro?-db...h.htm&-view

Please feel free to have a look.

Thanks,

Brian

[Garry Claridge]

I found this at the start of the Form:

<INPUT TYPE="hidden" NAME="-SortORder" VALUE="Ascending"><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><div align="center"><INPUT TYPE="hidden" NAME="-Max" VALUE="2500">

You may want to place just one of these immediately before the "AccommodationFor" field.

I also found this in there:

<INPUT TYPE="hidden" NAME="-LOP" VALUE=OR>

Hence, the "AND" search will not work.

Good Luck.

Garry