Custom Web Publishing Guide

Appendix A
|
Valid names used in query strings 93
–field (Container field name) query parameter
Specifies the name of a container field
Required with: request for data in a container field
See “About the URL syntax for FileMaker container objects in XML solutions” on page 27, and “About the
URL syntax for FileMaker container objects in XSLT solutions” on page 53.
fieldname (Non-container field name) query parameter
Field names are used to control criteria for the –find query command, or to modify the contents of a record.
When you need to specify a value for a non-container field for a query command or parameter, use the field
name without the hyphen (
–) character as the name portion of the name/value pair.
Name is: Name of the field in the FileMaker database. If the field is not in the underlying table of the layout
specified in the query string, the field name must be fully qualified. Field names that contain periods (such
as “
text.field”) cannot be accessed via XML or XSLT using an HTTP query. The period is a reserved
character used for record-ids in a fully qualified field name. See
“About the syntax for a fully qualified field
name” on page 87.
Value is: For the –new and –edit query commands, specify the value you want to store in the field in the
current record. For the
–find query commands, specify the value you want to search for in the field. When
you specify the value for a date, time, or timestamp field, specify the value using the “fm” format for that
field type. The “fm” formats are
MM/dd/yyyy for date, HH:mm:ss for time, and MM/dd/yyyy HH:mm:ss for
timestamp.
Required with: –edit query command
Optional with: –new and –find query commands
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–op=eq&FirstName=Sam
&–max=1&–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.