Developer’s Guide

B-8 Developer’s Guide
Value is: The operator to use. There are short and long versions of
each operator. The default operator is "begins with". Valid operators
are as follows:
You can use any FileMaker Pro –find operator by specifying the
begins with (bw) parameter. For example, to specify the "Find
Content Match" (= =) operator, you would specify the begins with
parameter (bw) and then you would place the characters "==" before
the actual search criteria. The required lines would look like this:
<input type="hidden" name="–op" value="bw">
<input type="text" name="FirstName" value="= =Sam">
Optional with: –find requests
Requires: A field name and a value
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–op=eq&FirstName=Sam&–find
–max (Maximum records)
Name/Value Type: Parameter
What it does: Specifies the maximum number of records that should
be returned.
Value is: A number from 1 through 2147483647, or the word "All".
The default value is 25.
Optional with: –find requests
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–max=10&–find
–skip (Skip records)
Name/Value Type: Parameter
What it does: Tells FileMaker Pro how many records to skip in the
found set.
Value is: A number from 0 through 2147483647, or the word "All".
If the value is greater then the number of records in the found set or
the value is "All" then the last record is displayed. The default value
is 0.
Optional with: –find requests
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–skip=10&–max=5&–find
In this example, the first 10 records in the found set are skipped and
records 11 through 15 are returned.
–sortfield (Sort field)
Name/Value Type: Parameter
What it does: Specifies the field that will be used for sorting. The
–sortfield parameter can been used multiple times to perform
multiple field sorts. The position in which –sortfield appears in the
CGI command will determine the sort order of the fields.
Short Long FileMaker Pro equivalent operator
eq equals =word
cn contains "word"
bw begins with word*
ew ends with *word
gt greater than > word
gte greater than or equals >= word
lt less than < word
lte less than or equals <= word
neq not equals omit, word