Complex Queries

[tap2k]

Hi, I am trying to perform a complex web search query on an FM db, by using the logical operators and and or. Basically I want to display an or'ed search on one field along with anded searches on other fields, and get the result in xml. Anyone have any idea how to do this?

[Keith M. Davie]

I answer from my experiences in FMPr0 4.0v3.

First, in order to do a search of multiple fields using and, I found through serendipity on FileMaker's web site, that, in the <form>...</form> structure, the line "<input type="hidden" name="fieldname" value="==">" had to be inserted immediately before the line "<input type="text" name="fieldname" value="">" for each field which in which data was to be input into the space created by "".

I don't know that this will answer your question, but it may give you a place from which to experiment. Of course the quotes external the pointy brackets in the quoted lines above do not occur in your format file.

Good luck, Peace

Keith M. Davie