Custom Web Publishing Guide

96 FileMaker Server Advanced Custom Web Publishing Guide
–lop (Logical operator) query parameter
Specifies how the find criteria in the –find query command are combined as either an “and” or an “or” search
Value is: and or or (which must be specified in lowercase). If the –lop query parameter is not included, then
the
–find query command uses the and value.
Optional with: –find query command
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&Last+Name=Smith
&Birthdate=2/5/1972&–lop=and&–find
–max (Maximum records) query parameter
Specifies the maximum number of records you want returned
Value is: A number, or use the value all to return all records. The value all must be specified in lowercase.
If
–max is not specified, all records are returned.
Optional with: –find or –findall query commands
Examples:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–max=10&–findall
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–max=all&–findall
–modid (Modification ID) query parameter
The modification ID is an incremental counter that specifies the current version of a record. By specifying
a modification ID when you use an
–edit query command, you can make sure that you are editing the current
version of a record. If the modification ID value you specify does not match the current modification ID
value in the database, the
–edit query command is not allowed and an error code is returned.
Value is: A modification ID, which is a unique identifier for the current version of a record in a FileMaker
database.
Optional with: –edit query command
Requires: –recid parameter
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=22&–modid=6
&last_name=Jones&–edit
–recid (Record ID) query parameter
Specifies the record you want processed. Used mainly by the –edit, and –delete query commands.
Value is: A record ID, which is a unique specifier to a record in a FileMaker database
Required with: –edit, –delete, and –dup query commands
Optional with: –find query command
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=22&–delete