Developer’s Guide

Table Of Contents
7-4
Developer’s Guide
<applet code=com.ms.xml.dso.XMLDSO.class width=0 height=0
id=xmldso MAYSCRIPT=true>
<PARAM NAME="url" VALUE=fmpro?–db=PhoneList.fp5&
–format=–dso_xml&–find=>
</applet>
Description of elements in the FMPDSORESULT grammar
Each ROW element in the generated FMPDSORESULT grammar
contains a number of FIELD elements that correspond to the field
names in the specified layout.
Spaces or single colons in field names are converted to underscores
in the element names (for example,
<FIRST_NAME>). Double colons
in portal fields are converted to periods (for example,
<PHONE.PHONE_NUMBER>). This is done because colons are
reserved in XML for specifying namespaces and spaces are not
allowed in XML element names.
For repeating and portal fields, each FIELD element will contain a
DATA element that corresponds to each repetition or portal record.
Note The content of container fields in the database will be
generated in the form of the relative URL used for retrieving the
content instead of the actual content (such as an image).
To qualify the XML elements for the FileMaker Pro application, the
names of all elements and attributes in this grammar are associated
with the unique XML namespace http://www.filemaker.com/
fmpdsoresult. This namespace is declared in the grammar as the
default namespace.
The following is an example of XML data generated with the
FMPDSORESULT grammar.
Example of XML data in the FMPDSORESULT grammar
<?xml version="1.0" encoding="UTF-8"?>
<FMPDSORESULT xmlns=“http://www.filemaker.com/fmpdsoresult”>
<ERRORCODE>0</ERRORCODE>
<DATABASE>PhoneList.fp5</DATABASE>
<LAYOUT>Web Layout</LAYOUT>
<ROW RECORDID=“3” MODID=“23”>
<FIRST_NAME>John</FIRST_NAME>
<LAST_NAME>Smith</LAST_NAME>
<PHONE.PHONE_NUMBER>
<DATA>555-444-3333</DATA>
<DATA>555-222-9999</DATA>
</PHONE.PHONE_NUMBER>
</ROW>
<ROW RECORDID=“6” MODID=“32”>
<FIRST_NAME>Barbara</FIRST_NAME>
<LAST_NAME>Jones</LAST_NAME>
<PHONE.PHONE_NUMBER>
<DATA>555-666-7777</DATA>
<DATA>555-333-0000</DATA>
<DATA>555-111-7654</DATA>
</PHONE.PHONE_NUMBER>
</ROW>
</FMPDSORESULT>
Note If the –lay parameter is not specified in the FileMaker Pro CGI
request, the LAYOUT element is empty and data for every field in
the database is returned. (See “Generating FileMaker Pro CGI
requests for an XML document” on page 7-8 for information.)