Custom Web Publishing Guide

Chapter 3
|
Accessing XML data with the Web Publishing Engine 35
For date, time, and timestamp fields, data for value lists are formatted 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. See
“Using the date, time, and day extension functions” on page 72. For example, if a
“birthdays” value list is used for a pop-up menu on a “birthdate” field of a layout, and the “birthdate” field
is of type date, then the values output for that value list will all be in the “fm” date format.
Note If two fields with different field types on a layout share the same value list, the first field’s type
determines the format of the value list data.
Example of XML data in the FMPXMLLAYOUT grammar
The following is an example of XML data generated with the FMPXMLLAYOUT grammar.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" "/fmi/xml/FMPXMLLAYOUT.dtd">
<FMPXMLLAYOUT xmlns="http://www.filemaker.com/fmpxmllayout">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="06/15/2005" NAME="FileMaker Web Publishing Engine" VERSION="8.0.1.32"/>
<LAYOUT DATABASE="art" NAME="web2">
<FIELD NAME="Title">
<STYLE TYPE="EDITTEXT" VALUELIST=""/>
</FIELD>
<FIELD NAME="Artist">
<STYLE TYPE="EDITTEXT" VALUELIST=""/>
</FIELD>
<FIELD NAME="Image">
<STYLE TYPE="EDITTEXT" VALUELIST=""/>
</FIELD>
<FIELD NAME="artlocation::Location">
<STYLE TYPE="EDITTEXT" VALUELIST=""/>
</FIELD>
<FIELD NAME="artlocation::Date">
<STYLE TYPE="EDITTEXT" VALUELIST=""/>
</FIELD>
<FIELD NAME="Style">
<STYLE TYPE="POPUPMENU" VALUELIST="style"/>
</FIELD>
</LAYOUT>
<VALUELISTS>
<VALUELIST NAME="style">
<VALUE>Impressionist</VALUE>
<VALUE>Modern</VALUE>
<VALUE>Abstract</VALUE>
</VALUELIST>
</VALUELISTS>
</FMPXMLLAYOUT>