Custom Web Publishing with XML and XSLT

88 FileMaker Server Custom Web Publishing with XML and XSLT
Guidelines for using query commands and parameters
When using query commands and parameters in a query string, keep the following guidelines in mind:
1 A query string must contain only one query command; no more and no less. For example, a query string
can contain –new to add a new record, but it can’t contain –new and –edit in the same query string.
1 Most query commands require various matching query parameters in the query string. For example, all
query commands except –dbnames and –process require the –db parameter that specifies the database to
query. See the table of required parameters in
“Using FileMaker query strings to request XML data” on
page 37.
1 For query parameters and field names, specify the particular value you want to use, such as
–db=employees. For query commands, don’t specify an “=” sign or a value after the command name, such
as –findall.
1 Query command and parameter names must be specified in lowercase, such as –delete or –lay.
1 Database names, layout names, and field names used in query strings are case insensitive, such as
–lay=mylayout to specify MyLayout.
Note Field and database names that are used in XSLT statements outside of query strings are case
sensitive and must exactly match the actual names used in the database. For example, in this statement:
<xsl:value-of select="fmrs:field[@name='LastName']"/>
the field reference “LastName” must exactly match the name of the LastName field in the database.
1 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,” below.
1 For the –find command, the value of a field is case insensitive. For example, you can use Field1=Blue or
Field1=blue. For the –new and –edit commands, the case you use in the value of a field is preserved and
stored in the database exactly as you specify in the query string. For example, LastName=Doe.
About the FileMaker Query Strings Reference
This release includes a FileMaker database called Query Strings Reference.fp7 that contains brief descriptions
and examples of each of the FileMaker query commands and query parameters. This can be found in the
following directory on any machine in your FileMaker Server deployment (master or worker):
Mac:
/Library/FileMaker Server/Examples/XSLT
Windows:
<drive>:\Program Files\FileMaker\FileMaker Server\Examples\XSLT
Where: <drive> is the primary drive from which the system is started.