Custom Web Publishing with XML and XSLT

Table Of Contents
Appendix A
|
Valid names used in query strings 95
Optional with: all query commands in an XSLT request
Example:
http://192.168.123.101/fmi/xsl/my_template/my_stylesheet.xsl?–db=employees&–lay=departments
&–grammar=fmresultset&–encoding=Shift_JIS&–findall
See “Setting text encoding for requests” on page 56.
–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 28, 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 can contain periods, with
the following exceptions:
1 The period cannot be followed by a number. For example, myfield.9 is an invalid field name.
1 The period cannot be followed by the text string op (the two letters “op”). For example, myfield.op is
an invalid field name.
1 The period cannot be followed by the text string global (the word “global”). For example, myfield.global
is an invalid field name.
Field names containing any of these exceptions cannot be accessed via XML or XSLT using an HTTP
query. These contructs are reserved for record IDs, as described in the section,
“About the syntax for a fully
qualified field name” on page 89.
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.