Custom Web Publishing with XML and XSLT

92 FileMaker Server Custom Web Publishing with XML and XSLT
–edit (Edit record) query command
Updates the record specified by the –recid parameter, populating the fields with the contents of any field
name/value pairs. The –recid parameter indicates which record should be edited.
Required query parameters: –db, –lay, –recid, one or more field name(s)
Optional query parameter: –modid, –script
Note For information on editing records in a portal, see “Editing records in a portal” on page 89.
Example:
To edit a record:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=13&Country=USA&–edit
–find, –findall, or –findany (Find records) query commands
Submits a search request using defined criteria
Required query parameters: –db, –lay
Optional query parameters: –recid, –lop, –op, –max, –skip, –sortorder, –sortfield, –script, –script.prefind,
–script.presort, field name
Examples:
To find a record by field name:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&Country=USA&–find
Note Specifying a field name multiple times in a single request is not supported; FileMaker Server parses
all of the values, but uses only the last value parsed.
To find a record by record ID:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–recid=427&–find
To find all records in the database, use –findall:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–findall
To find a random record, use –findany:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–findany
–findquery (Compound find) query command
Submits a search request using multiple find records and omit records requests.
Required query parameters: –db, –lay, –query
Optional query parameters: –max, –skip, –sortorder, –sortfield, –script, –script.prefind, –script.presort
Example:
Find records for cats or dogs that are not named “Fluffy.”
http://host/fmi/xml/fmresultset.xml?–db=vetclinic&–lay=animals&–query=(q1);(q2);!(q3)
&
–q1=typeofanimal&–q1.value=Cat&–q2=typeofanimal&–q2.value=Dog&–q3=name&–q3.value=Fluffy&–findquery
Using the -findquery command for compound finds
A –findquery statement consists of four parts, in the following order:
1 The –query parameter