Custom Web Publishing Guide

Appendix A
|
Valid names used in query strings 87
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 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, 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
The FileMaker Server Web Publishing CD 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. You can open the FileMaker Query Strings Reference in the
Custom Web Publishing Reference
folder on the FileMaker Server Web Publishing CD.
About the syntax for a fully qualified field name
A fully qualified field name identifies an exact instance of a field. Because fields with common names can
be based on different tables, you must use fully qualified names, in some cases, to avoid errors.
The syntax for specifying a fully qualified field name is:
table-name::field-name(repetition-number).record-id
where:
1 table-name is the name of the table that contains the field. The table name is only required if the field is
not in the underlying table of the layout specified in the query string.
1 field-name(repetition-number) is the specific value in a repeating field, and is only required for repeating
fields. The repetition number starts counting at the numeral 1. For example,
field-name(2) refers to the
second value in the repeating field. If you don’t specify a repetition number for a repeating field, the first
value in the repeating field is used. The repetition-number is required for the
–new and –edit query
commands involving repeating fields, but it is not required for the
–find command.
1 record-id is the record ID, and is only required if you are using a query string to add or edit records in
portal fields. See the following sections
“Adding records to a portal,” and “Editing records in a portal.”
The record-id is required for the –new and –edit query commands involving portal fields, but it is not
required for the
–find command.
Note To be accessible, fields must be placed on the layout you specify in the query string.