FileMaker Server Custom Web Publishing with XML



Similar documents
FileMaker Server Custom Web Publishing with XML and XSLT

FileMaker Server 15 カスタム Web 公開ガイド

FileMaker Server Getting Started Guide

FileMaker Server Getting Started Guide

FileMaker Server Getting Started Guide

FileMaker Server Help

FileMaker Server Custom Web Publishing with PHP

FileMaker Server 9 Getting Started Guide

FileMaker Instant Web Publishing Guide

FileMaker Instant Web Publishing Guide

FileMaker Server Custom Web Publishing with XML and XSLT

FileMaker Server 8 Advanced Web Publishing Installation Guide

FileMaker WebDirect Guide

FileMaker 15 WebDirect ガイド

FileMaker Server Custom Web Publishing with PHP

FileMaker WebDirect Guide

Installation and New Features Guide for FileMaker Pro 10 and FileMaker Pro 10 Advanced

FileMaker Server Help

FileMaker Instant Web Publishing Guide

FileMaker Pro Tutorial

FileMaker Instant Web Publishing Guide

Installation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced

FileMaker Pro 15 および FileMaker Pro 15 Advanced インストールおよび新機能ガイド

FileMaker Server 10 ヘルプ

Installation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced

Installation and New Features Guide for FileMaker Pro and FileMaker Pro Advanced

FileMaker Server 16 インストールおよび構成ガイド

FileMaker Pro 9 Tutorial

FileMaker Server 15 入門ガイド

FileMaker Pro 8.5 Tutorial

Bento User’s Guide

FileMaker Pro 9 Advanced Development Guide

FileMaker Server Getting Started Guide

FileMaker Pro 9 Advanced Development Guide

FileMaker ODBC and JDBC Guide

Running FileMaker Pro 8 on Citrix Presentation Server

FileMaker Pro Advanced Development Guide

FileMaker Go Development Guide

() < > </ > / HTML SGML HTML 1.1 DTD DTD ( DTD (prolog) )SGML 1. DTD ( ) 2. DTD <!-- DTD-- > <!ELEMENT MAIL - - ((TO,FROM)?,DATE?,BODY) > <!ELEMENT TO

FileMaker Server 8 Guide to Updating Plug-ins

FileMaker 16 ODBC と JDBC ガイド

FileMaker 15 ODBC と JDBC ガイド

0序文‐1章.indd

Bento ユーザーのための FileMaker Pro クイックスタディガイド

FileMaker ODBC and JDBC Guide

¥Í¥Ã¥È¥ï¡¼¥¯¥×¥í¥°¥é¥ß¥ó¥°ÆÃÏÀ

山梨県ホームページ作成ガイドライン

Mac OS X Server QuickTime Streaming Server 5.0 の管理(バージョン 10.3 以降用)

2014_Apr_FSLP_A4

ohp.mgp

_02-5.ppt

ii II Web Web HTML CSS PHP MySQL Web Web CSS JavaScript Web SQL Web

JP1/Integrated Management - Service Support 操作ガイド

文書情報標準化ガイドライン.PDF

ipad iphone Windows Mac Web App : 12, * Starter Solution Excel PDF Web Web CSV, Excel, XML, ODBC ODBC / JDBC ** SQL Advanced : 20, * (HT

FileMaker Pro Network Install Setup Guide

Web 1990,HTTP, HTML, URL XML HTML XHTML XML Web XMLSOAPWSDL ( ) Web2.0 Web XML+WebAPI

Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21

GPS携帯端末を用いた近隣バス停位置と

ウイルスバスター ビジネスセキュリティ インストールガイド

第2回_416.ppt

book

COBOLソース解析支援 導入・運用ガイド

日本オラクル株式会社

biz-Stream v4 各種機能別動作環境一覧表

Transcription:

FileMaker Server 12 Web with XML

2007-2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL www.filemaker.co.jp 01

7 7 1 Web 8 Web 9 Web 9 Web with PHP 10 Web with XML 10 PHP XML 10 PHP 10 XML 11 2 Web with XML 12 Web Web 12 Web with XML 13 Web 13 Web 13 Web Web 13 14 14 3 Web 15 Web 15 15 16 Web MIME ) 16 Web 17 17 17 18 Web 19 FileMaker Web 19 19 Web 20 Web 21

4 4 Web XML 22 Web with XML 22 Web FileMaker Pro XML / 22 Web XML 23 Web XML 24 XML URL 24 XML URL 24 XML FileMaker URL 25 URL 26 Web XML 26 FileMaker XML 27 FileMaker 27 FileMaker 27 fmsresultset 28 fmresultset 28 fmresultset XML 30 FileMaker XML 31 FMPXMLRESULT 31 FMPXMLRESULT XML 32 FMPXMLLAYOUT 33 FMPXMLLAYOUT XML 35 UTF-8 36 FileMaker XML 36 XML 38 XML 38 XML 39 5 40 Web 40 Web 40 XML 41 42 Web 42 Web 42 Web 44 Tomcat 44

5 A 45 45 45 46 47 47 48 49 -dbnames 49 -delete 50 -dup 50 -edit 50 -find -findall -findany 51 -findquery ( ) 51 -layoutnames 52 -new 52 -scriptnames 52 -view 53 53 -db 53 -delete.related 53 -field 54 54.op 55 -lay 56 -lay.response 56 -lop 56 -max 57 -modid ID 57 -query 57 -recid ID 58 -relatedsets.filter 59 -relatedsets.max 59 -script 60 -script.param 60 -script.prefind 61 -script.prefind.param 61 -script.presort 61 -script.presort.param 62 -skip 62 -sortfield 62 -sortorder 63

6 B Web 64 XML 64 FileMaker 64 C FileMaker 12 XML 71 XML 71 XML 71 71 72 72 73

XML Web FileMaker Pro FileMaker Server Web with XML 1 XML Web 1 XML 1 Web Web 1 FileMaker Server XML FileMaker www.filemaker.co.jp Web FileMaker Server FileMaker Server Web Web with PHP Web with XML FileMaker Server FileMaker Server FileMaker Web FileMaker Server Web with PHP FileMaker Server Web with XML ODBC JDBC FileMaker ODBC JDBC ODBC JDBC

1 Web FileMaker Server FileMaker Web Web Web Web Web Web Web FileMaker Pro FileMaker Pro Advanced FileMaker Server Advanced FileMaker Pro Web Web FileMaker Pro FileMaker Web FileMaker Pro Web Web HTML Web Web ( Web Web FileMaker Server Web ) FileMaker Web Web FileMaker Server Web Web FileMaker Server Web FileMaker Pro Web 1 Web 1 1 Web FileMaker Server Web 1 Web with PHP FileMaker Pro PHP FileMaker API for PHP FileMaker PHP Web PHP Web 1 Web with XML XML FileMaker Web FileMaker HTTP URL FileMaker Server XML XML

1 Web 9 Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML Web Web HREF Web FileMaker URL Uniform Resource LocatorWeb XML Web with PHP Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web 1 2 3.fmp12.fmp12 Web Web Web FM API PHP Web Web 6 5 4 Web 1. Web Web 2. Web FileMaker Web Web 3. Web 4. FileMaker Server FileMaker Web 5. Web FileMaker 1 PHP Web API 1 XML Web Web XML 6. Web Web Web FileMaker Pro PDF www.filemaker.co.jp

1 Web 10 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP Web with XML XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML PHP XML PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP http://php.net 1 PHP Web with PHP FileMaker Server Web with PHP

1 Web 11 XML 1 FileMaker XML 1 XML W3C 1 XML Unicode 1 XML 1 Web XML FileMaker Pro XML FMPXMLRESULT

2 Web with XML Web Web Web XML FileMaker Server Web Web 1 Web FileMaker Web 1 FileMaker XML FileMaker Web 1 FileMaker Web Web FileMaker Web 1 FileMaker Server Web XML Web FileMaker Web XML Web Web 1 1 Web XML URL Web with XML Web with XML FileMaker HTTP FileMaker XML XML 26 Web XML

2 Web with XML 13 Web with XML XML FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 JavaScript XML 1 FileMaker Pro Web 16 1 Web FileMaker 65 Web 19 FileMaker Web 1 FileMaker 60 -script.param 61 -script.prefind.param 62 -script.presort.param 1 fmresultset XML relatedset 1 A Web Web Web with XML 1 FileMaker Server 1 Microsoft IIS Windows Apache Mac OS X Web 1 Web FileMaker 1 Web 1 FileMaker Server FileMaker Pro 1 Web IP 1 Web Web Web FileMaker Server Web Web Web Web with XML 1 Web 1 Web 1 Web IP

2 Web with XML 14 FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP Web 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 15 Web 1 XML FileMaker 26 Web XML

3 Web Web Web Web with XML Web with XML Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. fmxml Web with XML 3. Admin Web with XML Web ASCII a z A Z 0 9! % FileMaker Pro Web Web Web Web HTTP Web Web Web HTTP Web Web 1 Web 1 Web

3 Web 16 1 Web Web Web 1 1 Web [ ] Web 1 FileMaker Pro Web Web [ ] Web FileMaker Pro Web with XML 1 Web 1 Web with XML 1 Web 1 Web FileMaker Server Admin Console Web Web FileMaker Server 1 Web IP Web 192.168.100.101 IP Web IP Web 1 Web Web SSL Secure Sockets Layer SSL SSL Web FileMaker Pro PDF www.filemaker.co.jp Web MIME ) MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web

3 Web 17 Web FileMaker FileMaker Server 25 XML FileMaker URL Web (.mp3).mov.mp4.avi PDF Web Web PDF [Web ] Web 1. FileMaker ProWeb 2. FileMaker Pro [ ] 3. WebWeb 1 IIS Windows < >: Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS / /WebServer/Documents 1 MIME Multipurpose Internet Mail Extensions Web MIME Web Web Web MIME Web 1 QuickTime

3 Web 18 FileMaker Pro [ ] FileMaker Server FileMaker Server FileMaker Pro 1. FileMaker Server FileMaker Pro WindowsMac OS 1 Windows 32 [ ]: Program Files FileMaker FileMaker Server Data Databases 1 Windows 64 [ ]: Program Files (x86) FileMaker FileMaker Server Data Databases 1 Mac OS / /FileMaker Server/Data/Databases/ 2. RC_Data_FMS 3. RC_Data_FMS Customers Customers FileMaker Server 4. Mac OS fmsadmin FileMaker Server Web (.mp3).mov.mp4.avi PDF Web Web PDF [Web ]

3 Web 19 Web Web 1 Web Web 1 Web FileMaker Web FileMaker Pro Web Web FileMaker FileMaker 65 Web URL Web FileMaker Pro [ ] [ ] [ Web ] Web FileMaker Pro Web 20 Web Web Web wpe.log42 Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ]

3 Web 20 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web 1 [ / ] [ ] [ ] [ ] [ / ] Web [ / ] 1 Get( ) Web Publishing Engine Web FileMaker Pro Web Web FileMaker Pro FileMaker Pro / URL Web FileMaker Server Web Web Web 19 Web Web Web Web Web Web Web [ ] Web

3 Web 21 / Web [ ] Web [ / ] Web FileMaker Pro Web FileMaker Pro FileMaker Pro 12 [ ] OnFirstWindowOpen OnLastWindowClose

4 Web XML Web FileMaker XML Extensible Markup Language HTML World Wide Web XML XML Web with XML XML URL Web with XML Web HTTP URL FileMaker FileMaker Server XML XML XML XML XML FileMaker Web www.filemaker.co.jp Web XML XML 1.0 XML www.w3.org XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 1 XML Web fmresultset FMPXMLRESULT FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT 26 Web XML 1 Web XML URL Web FileMaker Pro XML FileMaker Pro 1 Web FileMaker Server FileMaker Pro XML

4 Web XML 23 1 Web URL FileMaker XML FileMaker Pro XML XML 1 Web XML FileMaker Pro XML 1 Web FileMaker XML FileMaker Pro 1 Web FileMaker Pro 1 Web HTTP HTTPS FileMaker FileMaker Pro FileMaker Pro XML FileMaker Pro Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS 2. Web Web Web FileMaker Server Web Web 3. Web FileMaker FileMaker Web CWPE Web.fmp12.fmp12 Web FileMaker XML.fmp12.fmp12 FileMaker Web XML Web 6. Web Web Web 5. Web XML Web FileMaker Server Web Web 4. FileMaker Web Web CWPE Web

4 Web XML 24 Web XML Web FileMaker XML 1. FileMaker Server Admin Console XML FileMaker Server 2. FileMaker FileMaker Pro XML Web fmxml 15 Web XML [ ] [ ] [ ] XML XML XML 3. HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 36 FileMaker XML A 4. Web URL XML Web 5. Web XML Web XML URL Web FileMaker XML URL XML URL Web FileMaker XML URL < >://< >[:< >]/fmi/xml/<xml >.xml[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS 443

4 Web XML 25 1 <XML > FileMaker XML fmresultset FMPXMLRESULT FMPXMLLAYOUT 28 fmsresultset 31 FileMaker XML 1 < > FileMaker XML -dbnames 36 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT 45 Web XML URL http://server.company.com/fmi/xml/fmresultset.xml?-db=products&-lay=sales&-findall http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=products&-lay=sales&-findall XML FileMaker URL XML XML <data> URL <data>/fmi/xml/cnt/data.< >?< ></data> < >.jpg MIME Web < > XML URL <data>/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2</data> XML -field 47

4 Web XML 26 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > XML URL http://www.company.com/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2 <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 17 Web <data> URL XML URL UTF-8 Unicode Transformation 8 Bit 36 UTF-8 infofiancée URL http://server.company.com/fmi/xml/fmresultset.xml?-db=members &-lay=relationships&-recid=2&info= fianc%c3%a9e&-edit URL %C3%A9 UTF-8 é URL URL www.w3.org URL Web XML Web XML FileMaker FileMaker FileMaker URL Web XML XML 1 fmresultset Web XML FileMaker Web FMPXMLRESULT 28 fmsresultset

4 Web XML 27 1 FMPXMLRESULT FMPXMLLAYOUT XML FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 31 FileMaker XML URL Web XML XML XML FileMaker XML Web FileMaker XML Web XML UTF-8 Unicode Transformation Format 8 36 UTF-8 FileMaker XML XML XML <DATABASE> FileMaker XML Oracle XML XML <DATABASE> Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns="http://www.filemaker.com/xml/fmresultset" xmlns="http://www.filemaker.com/ fmpxmlresult" xmlns="http://www.filemaker.com/fmpxmllayout" FileMaker Web XML 0 fmresultset FMPXMLRESULT FMPXMLLAYOUT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE> XML B Web FileMaker FileMaker DTD HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT HTTP http://< >[:< ]/fmi/xml/fmresultset.dtd http://< >[:< ]/fmi/xml/fmpxmlresult.dtd http://< >[:< ]/fmi/xml/fmpxmllayout.dtd

4 Web XML 28 fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall fmresultset Web fmresultset XML XML Web <?xml...?> <!DOCTYPE> fmresultset <!DOCTYPE> fmresultset DTD URL fmresultset fmresultset <datasource> <metadata> <resultset> <datasource> fmresultset <datasource> table layout date-format time-format timestamp-format totalcount database 1 XML <datasource> date-format MM/dd/yyyy 1 MM - 01 12 01 12 12 1 dd - 00 31 1 yyyy - 1 XML <datasource> time-format HH:mm:ss 1 HH - 24 00 23 1 mm - 00 59 1 ss - 00 59 1 <datasource> timestamp-format date-format time-format MM/dd/yyyy HH:mm:ss

4 Web XML 29 <metadata> fmresultset <metadata> <field-definition> <relatedset-definition> <field-definition > 1 auto-enter yes no 1 four-digit-year yes no 1 global field yes no 1 max-repeat 1 max-characters 1 not-empty yes no 1 numeric-only yes no 1 text number date time timestampcontainer 1 time-of-day yes no 1 normal calculationsummary 1 <relatedset-definition> <relatedset-definition> <field-definition> <relatedset-definition> <resultset> <resultset> <record> <record> mod-id record-id <data> <relatedset> <record> <relatedset> count table

4 Web XML 30 fmresultset XML fmresultset XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" ""http://localhost:80/fmi/xml/fmresultset.dtd"> <fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0" /> <product build="12/31/2012" name="filemaker Web Publishing Engine" version="0.0.0.0" /> <datasource database="art" date-format="mm/dd/yyyy" layout="web3" table="art" time-format="hh:mm:ss" timestamp-format="mm/dd/yyyy HH:mm:ss" total-count="12" /> <metadata> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="title" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artist" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal" /> <relatedset-definition table="artlocations"> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::location" notempty="no" numeric-only="no" result="text" time-of-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::date" notempty="no" numeric-only="no" result="date" time-of-day="no" type="normal" /> </relatedset-definition> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="style" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal" /> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="length" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="calculation" /> </metadata> <resultset count="1" fetch-size="1"> <record mod-id="6" record-id="14"> <field name="title"> <data>spring in Giverny 3</data> </field> <field name="artist"> <data>claude Monet</data> </field> <relatedset count="0" table="artlocations" /> <field name="style"> <data /> </field> <field name="length"> <data>19</data> </field> </record> </resultset> </fmresultset>

4 Web XML 31 FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=employees&-lay=family&-findall FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=family&-view FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAME RECORDS DATEFORMAT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 28 fmresultset FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes / NoEMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 57 -modid ID <COL> <COL> / <DATA>

4 Web XML 32 FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" ""http://localhost:80/fmi/xml/fmpxmlresult.dtd"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION="0.0.0.0" /> <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="web" NAME="art" RECORDS="12" TIMEFORMAT="HH:mm:ss" /> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Artist" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Image" TYPE="CONTAINER" /> </METADATA> <RESULTSET FOUND="1"> <ROW MODID="6" RECORDID="15"> <COL> <DATA>Spring in Giverny 4</DATA> </COL> <COL> <DATA>Claude Monet</DATA> </COL> <COL> <DATA>/fmi/xml/cnt/data.jpg?-db=art&-lay=web&-recid=15&-field=Image(1)</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> <COL> <METADATA> <FIELD> <METADATA> Title ArtistVillage Market Camille Pissarro <RESULTSET> <ROW>

4 Web XML 33 FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <VALUELISTS> <VALUELIST> <VALUE> FileMaker [ ] <VALUE> DISPLAY ID ("100" ) ("Impressionism" ) [ ] DISPLAY 1 [ ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100">100</VALUE> <VALUE DISPLAY="101">101</VALUE> <VALUE DISPLAY="102">102</VALUE> </VALUELIST> </VALUELISTS> 1 [ ] [ ] DISPLAY XML DISPLAY <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionism">100</VALUE> <VALUE DISPLAY="Cubism">101</VALUE> <VALUE DISPLAY="Abstract">102</VALUE> </VALUELIST> </VALUELISTS>

4 Web XML 34 1 [ ] [ ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100 Impressionism">100</VALUE> <VALUE DISPLAY="101 Cubism">101</VALUE> <VALUE DISPLAY="102 Abstract">102</VALUE> </VALUELIST> </VALUELISTS> fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss birthdaysbirthdate birthdate fm

4 Web XML 35 FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" ""http://localhost:80/fmi/xml/fmpxmllayout.dtd"> <FMPXMLLAYOUT xmlns="http://www.filemaker.com/fmpxmllayout"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION="0.0.0.0" /> <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="artlocations::Location"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="artlocations::Date"> <STYLE TYPE="EDITTEXT" VALUELIST="" /> </FIELD> <FIELD NAME="Style"> <STYLE TYPE="POPUPMENU" VALUELIST="style" /> </FIELD> </LAYOUT> <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionism">100</VALUE> <VALUE DISPLAY="Cubism">101</VALUE> <VALUE DISPLAY="Abstract">102</VALUE> </VALUELIST> </VALUELISTS> </FMPXMLLAYOUT>

4 Web XML 36 UTF-8 Web XML UTF-8 Unicode Transformation Format 8 ASCII Unicode 16 XML Unicode UTF-8 UTF-8 ASCII 0 127 Unicode UTF-8 Web UTF-8 1 ASCII UTF-8 ASCII UTF-8 1 ASCII 1 UTF-8 1 1 UTF-8 Unicode 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker http://192.168.123.101/fmi/xml/fmresultset.xml?-db=products-lay=sales&-findall -new -dbnames -db URL FileMaker 45 -dbnames -delete -dup -edit -find -findall -findany -findquery Web

4 Web XML 37 -layoutnames -new -scriptnames -view Web Web FMPXMLLAYOUT fmresultset FMPXMLRESULT XML <metadata> -db -delete.related -field.op -lay -lay.response XML -lop -max -modid ID -query -recid ID -relatedsets.filter -relatedsets.max -script -script.param -script -script.prefind -find -findany -findall -script.prefind.param -script.prefind -script.presort -script.presort.param -script.presort -skip -sortfield.[1-9] -sortorder.[1-9] -dbnames -edit URL 25 XML FileMaker URL -edit -find 54 -find -dbnames -layoutnames -scriptnames -dbnames -layoutnames -scriptnames -find -find -findall -findquery -edit -findquery -edit -delete -dup -find -find -findall -findany -edit -new -dup -findquery -find -edit -new -dup -findquery -find -findall -findany -new -edit -delete -dup -view -findquery -script -findquery -find -findany -findall -findquery -script.prefind -findquery -find -findall -findquery -script.presort -findquery -find -findall -findquery -find -findall -findquery -find -findall

4 Web XML 38 XML -lay XML XML XML XML -lay.response Budget Salary 100,000 ExecList Salary http://192.168.123.101/fmi/xml/fmresultset.xml -db=employees &-lay=budget&salary=100000&salary.op=gt&-find&-lay.response=execlist XML XML XML FileMaker Server Web XML 1. -lay 2. URL.global= 3. -script.prefind 4. -find -new 5. -script.presort 6. 7. -script 8. -lay.response 9. XML -sortfield 102

4 Web XML 39 XML Web XML 1 XML Web 15 Web 1 FileMaker Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server

Web 1. 3 Web 2. XML FileMaker Server Admin Console FileMaker Server 3. Web Web 4. Web 1 FileMaker Server FileMaker 1 FileMaker Pro Web Web 1 FileMaker Server 18 RC_Data_FMS 5. Web Web Web XML Web 1 1

5 41 1 Web 19 FileMaker Web 1 Web Web Web FileMaker Server URL http://127.0.0.1/ Web URL 24 XML URL XML XSLT 1 XML Web XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <xsl:output method="xml"/> <xsl:template match="/"> <xsl:copy-of select="."/> </xsl:template> </xsl:stylesheet> 1 HTML <textarea> XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <xsl:output method="html"/> <html> <body> <xsl:template match="/fmrs:fmresultset"> <textarea rows="20" cols="100"> <xsl:copy-of select="."/> </textarea><br/> </xsl:template> </body> </html> </xsl:stylesheet>

5 42 Web Web 1 Web 1 Web 1 Web 1 Tomcat IIS WindowsMicrosoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web Apache Mac OSApache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web www.w3.org Web Web wpe.log Web XML Web Web Web wpe.log FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Logs wpe.log < > 1 Apache Mac OS/ /FileMaker Server/Logs/wpe.log

5 43 Web wpe.log [ Web ] Admin Console wpe.log Web Web Web XML [ ] Admin Console FileMaker Server FileMaker Server 12 Web wpc_access_log.txt pe_application_log.txt wpe.log wpe.log Admin Console wpe.log wpe.log Web wpe.log 1 wpe.log.1 wpe.log wpe.log.1 Web wpe.log [TIMESTAMP_GMT] [WPC_HOSTNAME] [CLIENT_IP:PORT] [ACCOUNT_NAME] [MODULE_TYPE] [SEVERITY] [FM_ERRORCODE] [RETURN_BYTES] [MESSAGE] 1 [TIMESTAMP_GMT] (GMT) 1 [WPC_HOSTNAME] Web 1 [CLIENT_IP:PORT] XML IP 1 [ACCOUNT_NAME] FileMaker 1 [MODULE_TYPE] Web with XML XML Web with PHP PHP 1 [SEVERITY] INFO ERROR 1 [FM_ERROR_CODE] FileMaker 62 FileMaker HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE]

5 44 Web wpe.log 1 Web 2012-06-02 15:15:31-0700 - - - - INFO - - FileMaker Server Web Publishing Engine started. 2012-06-02 15:46:52-0700 - - - - INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML 2012-06-02 15:21:08-0700 WPC_SERVER 192.168.100.101:0 jdoe XML INFO 0 3964 "/fmi/xml/fmresultset.xml?-db=contacts&-lay=contact_details&-findall" 2012-06-02 15:26:31-0700 WPC_SERVER 192.168.100.101:0 jdoe XML ERROR 5 596 "/fmi/xml/fmresultset.xml?-db=contacts&-layout=contact_details&-findall" 1 2012-06-02 17:33:12-0700 WPC_SERVER 192.168.100.101:0 jdoe - ERROR 4 - Web Scripting Error: 4, File: "10b_MeetingsUpload", Script: "OnOpen", Script Step: "Show Custom Dialog" 1 Web 2012-06-09 10:59:49-0700 WPC_SERVER 192.168.100.101:0 jdoe - INFO - - XML Web Publishing Engine is enabled. 1 2012-06-02 15:30:42-0700 WPC_SERVER 192.168.100.101:0 jdoe XML ERROR - - Communication failed Web Web Web web_server_module_log.txtweb FileMaker ServerLogs Web FileMaker Server Tomcat Tomcat FileMaker Server Web 1 IIS Windows< >: Program Files FileMaker FileMaker Server Admin admin-master-tomcat logs < > 1 Apache Mac OS/ /FileMaker Server/Admin/admin-master-tomcat/logs/

Web FileMaker -dbnames 49 -delete 50 -dup 50 -edit 50 -find -findall -findany 51 -findquery 51 -layoutnames 52 -new 52 -scriptnames 52 -view 53 -db 53 -field 54 fieldname 54 fieldname.op 55 -lay 56 -lay.response 56 -lop 56 -max 57 -modid 57 -query 57 -recid 58 -relatedsets.filter 59 -relatedsets.max 59 -script 60 -script.param 60 -script.prefind 61 -script.prefind.param 61 -script.presort 61 -script.presort.param 62 -skip 62 -sortfield.[1-9] 62 -sortorder.[1-9] 63 -dbnames -layoutnames -scriptnames -lay 1 -new -new -edit 1 -dbnames -db 36 FileMaker XML 1 -db=employees -findall =

A 46 1 Web -lop=and, -lop=or, -sortorder=ascend, -sortorder=descend, -max=all 1 MyLayout -lay=mylayout 1 1 myfield.9 1 op opmyfield.op 1 global global myfield.global HTTP XML ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe Web XML 1. -database 2. -find&-edit 3. -lop=amd 4. (-db ) 5. (-lay ) 6. 7. -lop -delete -lop B Web

A 47 table-name::field-name(repetition-number).record-id 1 table-name 1 field-name(repetition-number) (2) -new -edit -find 1 record-id ID record-id -new -edit -find -new 1 1 ID 1 1 URL Employees John Doe Jane Dependents NamesID ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=family&firstname=john&lastname=doe&id=9756&dependents::names.0=jane&-new 1

A 48 -edit ID ID ID XML <relatedset> <record> record-id 28 fmsresultset URL ID 1001 Dependents NamesNames.2 2 ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.2=kevin&-edit http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.2=kevin&dependents::names.5=susan&-edit -edit ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.0=timothy&-edit -delete -edit -delete.related URL employees1001 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=1001&-delete URL Dependents 1001 ID 3 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&-delete.related=dependents.3&-edit 53 -delete.related -relatedsets.filter -relatedsets.max 59 -relatedsets.filter 59 -relatedsets.max :: ( ).global

A 49 global 47 FileMaker Pro.global Web XML.global Web http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments &Country.global=USA&-recid=1&-edit XML -dbnames FileMaker Server Web with XML http://192.168.123.101/fmi/xml/fmresultset.xml?-dbnames

A 50 -delete -recid -db -lay -recid -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=4&-delete -dup -recid -db -lay -recid -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=14&-dup -edit / -recid -recid -db -lay -recid -modid -script 48 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=13&country=usa&-edit

A 51 -find -findall -findany -db -lay -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&country=usa&-find FileMaker Server ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=427&-find -findall http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall -findany http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findany -findquery ( ) -db -lay -query -max -skip -sortorder -sortfield -script -script.prefind -script.presort Fluffy http://host/fmi/xml/fmresultset.xml?-db=vetclinic&-lay=animals &-query=(q1);(q2);!(q3)&-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal &-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 1 -query 1 1 1 q-q1 1 -q1.value=fieldvalue 1 fieldvalue begins with -q1.value=fieldvalue*

A 52 1 -findquery -query 57 -query -layoutnames FileMaker Server Web with XML -db http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames -new / -db -lay -script 47 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&country=australia&-new -scriptnames FileMaker Server Web with XML -db http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-scriptnames

A 53 -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata -db -lay -script http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=departments&-view http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view XML -db -db -db -dbnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-findall -delete.related -edit ID jobtable 7 ID 20 http://host/fmi/xml/fmresultset.xml?-db=career&-lay=applications&-recid=7&-delete.related=jobtable.20&-edit

A 54 -field 24 XML URL -find / - FileMaker 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML 47 ID -new -edit -find fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss -edit -new -find http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-op=eq&firstname=sam&- max=1&-find FileMaker Server

A 55.op -find begins with eq FileMaker Pro = cn * * bw * ew gt gte lt lte neq * > >= < <= -find :: = & ::.op= 1 1 cn http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&name=tim&name.op=cn&-find bw FileMaker Pro... bw... http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&- lay=departments&idnum=915...925&idnum.op=bw&-find FileMaker Pro

A 56 -lay -dbnames -layoutnames -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view -lay.response -lay XML -lay.response -lay.response -lay XML -lay.response -dbnames -layoutnames -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=budget&salary=100000&salary.op=gt&-find&-lay.response=execlist -lop -find and or and or -lop -find and -find findquery http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&last+name=smith&birthdate=2/5/1972&-lop=and&-find

A 57 -max all -max -find -findall -findquery?max 59 -relatedsets.max http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=10&-findall http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=all&-findall -modid ID ID -edit ID ID ID -edit ID ID FileMaker ID -edit -recid http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=22&- modid=6&last_name=jones&-edit -query 51 -findquery ( ) -findquery -query=< >< >&-findquery < > 1 qq1 1 AND (q1, q2) q1 q2 q and

A 58 1 FileMaker Pro! (q1);!(q2) q1 q2 1 OR (q1);(q2) q1 or q2 OR 1 < > (-) -< ID>=< >&-< ID>.value=< > -q1=typeofanimal&-q1.value=cat -q2=name&-q2.value=fluffy FluffyGray http://host/fmi/xml/fmresultset.xml?-db=petclinic&-lay=patients&-query=(q1, q2);!(q3)&-q1=typeofanimal&- q1.value=cat&-q2=color&-q2.value=gray&-q3=name&-q3.value=fluffy&-findquery -recid ID -edit -delete -view FMPXMLLAYOUT ID FileMaker -edit -delete -dup -find -view http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=22&-delete http://localhost/fmi/xml/fmpxmllayout.xml?-db=test&-lay=empty&-view&-recid=9

A 59 -relatedsets.filter layout none 1 -relatedsets.filter layout FileMaker Pro [ ] [ ] 1 [ ] [ ] -relatedsets.max -relatedsets.max 1 [ ] -relatedsets.max [ ] [ ] 1 none-relatedsets.filter none Web [ ] [ ] [ ] 1 -relatedsets.filter XML -relatedsets.filter layout none FileMaker Pro 1 [ ] [ ] XML [ ] -find -edit -new -dup -findquery http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english &-relatedsets.filter=none&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample &-lay=english&relatedsets.filter=layout&-relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english &-relatedsets.filter=layout&-relatedsets.max=10&-findany -relatedsets.max all 1 -relatedsets.max [ ] FileMaker Pro [ ] -relatedsets.filter layout 1 -relatedsets.max Web 1 -relatedsets.max all Web -relatedsets.filter

A 60 -find -edit -new -dup -findquery http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample &-lay=english&relatedsets.filter=layout&-relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english &-relatedsets.filter=layout&-relatedsets.max=10&-findany -script FileMaker 38 XML dbnames -layoutnames -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script=myscript&-findall -script.param -script FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script -script.param -script.param 1 -script.param Web -script http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script=myscript&-script.param=smith%7cchatterjee%7csu &-findall

A 61 -script.prefind -find FileMaker -dbnames -layoutnames -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.prefind=myscript&-findall -script.prefind.param -script.prefind FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web -script.prefind http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.prefind=myscript&-script.prefind.param=payroll &-findall -script.presort -find FileMaker -dbnames -layoutnames -scriptnames http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.presort=myscript&-sortfield.1=dept &-sortfield.2=rating&-findall

A 62 -script.presort.param -script.presort FileMaker 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber(Get( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web -script.presort http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.presort=myscript&-script.presort.param=18%7c65 &-sortfield.1=dept&-sortfield.2=rating&-findall -skip -find 10 11 15 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-skip=10&-max=5&-findall -sortfield -find -findall -sortfield -sortfield. = -sortfield. precedence-number 1 1 1 1 9

A 63 dept rating -sortorder http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=performance&-sortfield.1=dept&-sortfield.2=rating&-findall -sortorder < > Custom ascend descend FileMaker Pro a z -10 10 z a 10-10 < > -find -findall -sortfield -sortorder -sortfield -sortorder. = 1 -sortorder. -sortorder -sortfield 1 ascend dept ascend rating descend -sortorder.2 -sortorder.2=descend -sortfield.2=rating http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=performance&-sortfield.1=dept&-sortorder.1=ascend&-sortfield.2=rating &-sortorder.2=descend&-findall -sortorder

B Web Web XML FileMaker (http://filemaker-jp.custhelp.com) XML Web XML XML fmresultset <error code> FMPXMLRESULT FMPXMLLAYOUT <ERROCODE> fmresultset <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "/fmi/xml/fmresultset.dtd"> <fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0"></error> FMPXMLRESULT <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "/fmi/xml/fmpxmlresult.dtd"> <fmpxmlresult xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <error code> <ERRORCODE> Web Web FileMaker -1 0 1 2 3 4 5 [ ] 6 7 8

B Web 65 9 10 11 12 13 14 15 16 17 UTF-16 18 19 A Z a z 0 9 ASCII 20 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 130 131 200 201 202 203 204 205 206

B Web 66 207 208 209 210 211 212 213 214 215 216 217 218 300 301 302 303 304 306 ID 307 308 400 401 402 403 FileMaker Pro 404 405 406 407 ) 408 409 410 412 FileMaker Pro 413 414 415 416 417 500 501 502 503

B Web 67 504 505 506 507 508 509 510 511 512 600 601 602 603 700 706 EPSF 707 708 709 QuickTime 710 QuickTime 711 714 715 Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSL 718 Xerces XML 719 Xalan XSL XML 720 721 722 723 724 725 726 727 729 730 Excel Excel 2000 731 732

B Web 68 733 734 735 736 737 Bento 800 801 802 1 1 FileMaker Server 1 803 804 805 806 FileMaker Pro 807 FileMaker Pro 808 809 / 810 / 811 FileMaker Pro 813 814 815 816 817 819 820 821 822 FMI 823 824 FileMaker 825 826 850 851 852 900 901 902 903 904 FileMaker Server

B Web 69 905 906 920 921 922 923 951 954 XML 955 956 957 958 959 Web 960 1200 1201 1202 1203 1204 ( 1205 */ 1206 1207 1208 ( 1209 1210 1211 1212 + - * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 1216 GetSummary 1217 1218 1219 1220 1221 1222 1223 1224 1225

B Web 70 1300 1400 ODBC ODBC 1401 ODBC 1402 ODBC 1403 ODBC 1404 ODBC 1405 ODBC 1406 SQL API ODBC 1407 ODBC 1408 ODBC 1409 ODBC 1410 ODBC 1411 ODBC 1412 ODBC 1413 ODBC 1414 SQL 1450 PHP 1451 1501 SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP 1550 1551 1626 1627 1628 SSL 1629 60 1630 URL 1631

C FileMaker 12 XML FileMaker 12 XML XML FileMaker 12 1 -process FileMaker 12 1 -encoding 1 -grammar 1 -stylehref 1 -styletype 1 -token.[string] XML FileMaker 12 Web 46 FileMaker 12 -script -find performfind FileMaker 11 -db=customers&-lay=account&-script=performfind&-find FileMaker 12 400FileMaker 12 -findall -db=customers&-lay=account&-findall&-script=performfind FileMaker 12 Web 1 -lop -delete -db=test&-lay=test&-recid=82&-delete&f1=hi&-lop=and -lop and 1 : -dbnames&-dbnames Web -find&-edit

C FileMaker 12 XML 72 1 FileMaker 11 1 FileMaker 11 1 field.op -find FileMaker 11 field.op 1 -findany -findall recid -find -findquery -delete -dup 1.global FileMaker 12 Web 1 -findall -findany -find -findquery -new -edit -dup 1 1 neq.op or -lop -find FileMaker 11 1 -find FileMaker 11 1 FileMaker 11 1 [ ] recid FileMaker 11 FileMaker 11 FileMaker 12 -db=basicfinds&-lay=layoutone&-max=-1&-findall -db=basicsorts&-lay=layoutone&-sortfield.=textfield&-findall -db=relfinds &-lay=layoutone&aliasdoesntexist::relatedtextfield=sometext&-find -db=basicsorts&-lay=layoutone&-sortfield.1=&-findall -find -db=basicedits&-lay=layoutone&-find -find -db=basicfinds&-lay=layoutone&globaltextfield.global=sales&-find 5 5 102 FileMaker 11 FileMaker 11 960 404 106 102 400 400

A Admin Console 16, 24 auto-enter 29 C CWPE Web 23 D <datasource> 28 -dbnames 49 -db 53 -delete.related 48 -delete 50 -dup 50 E -edit 50 -encoding FileMaker 12 71 <error code> <ERRORCODE> 64 Extensible Markup Language XML 22 F <field-definition> 29 -field 54 FileMaker 12 -encoding 71 -grammar 71 -process 71 -stylehref 71 -styletype 71 -token 71 FileMaker API for PHP 10 10 FileMaker Pro Web 22 FileMaker Server 7 7 FileMaker Server Admin Console 16, 24 -findall 51 -findany 51 -findquery 51 -find 51 FMPXMLLAYOUT 33 35, 22 27 FMPXMLRESULT 22, 31 32 27 fmresultset 22, 28 30 26 four-digit-year 29 G global 29 -grammar FileMaker 12 71 H HTML XML 24 J JDBC 7 L -lay.response 38, 56 -layoutnames 52 -lay 38, 56 -lop 56 M max-characters 29 max-repeat 29 -max 57 <metadata> 29 MIME Multipurpose Internet Mail Extensions16 -modid 57 N name 29 -new 52 not-empty 29 numeric-only 29 O ODBC 7 P PDF 7 PHP 10 -process FileMaker 12 71

74 Q -query 57 QuickTime Web 17 R -recid 58 <relatedset-definition> 29 -relatedsets.filter 59 -relatedsets.max 59 <resultset> 29 result 29 S SAT FileMaker Server Admin Console 16 -script.param 60 -script.prefind.param 61 -script.prefind 61 -script.presort.param 62 -script.presort 61 -scriptnames 52 -script 60 -skip 62 -sortfield 62 -sortorder 63 SSL Secure Sockets Layer16 -stylehref FileMaker 12 71 -styletype FileMaker 12 71 T time-of-day 29 -token FileMaker 12 71 Tomcat 44 type 29 U Unicode 36 URL XML 25 XML 24 URL 26 UTF-8 Unicode Transformation 8 Bit 26, 36 W web_server_module_log.txt 44 Web XML 23 Web 23 Web Admin Console 24 XML 24 42 64 9 9 12 Web 9 Web MIME 16 XML 23 42 Web 42 Web FileMaker 7 Web 12 42 40 Web 42 Web QuickTime 17 XML 24 14 17 64 16 13 Web 17 Web XML 23 Web 19 Web 13 15 Web 15 Web 15 V -view 53

75 X XML FMPXMLLAYOUT 33 FMPXMLRESULT 31 fmresultset 28 <datasource> 28 <field-definition> 29 <metadata> 29 <relatedset-definition> 29 <resultset> 29 URL 26 UTF-8 27, 36 XML 1.0 22 XML 24 XML 39 36, 45 22 24 15 27 24, 36 DTD 27, 28, 31 26 XML 23 38 XML 38 XML 38 XML fmxml 15, 24 XML 24 XML 22 XML 22 XML 38 XML ASCII 36 XML 11 XML 26 XML 38 XML 38 <xsl:stylesheet> 41 <xsl:template> 41 Web 15 16 19 16 Web 15 42 Web 8 7 7 Web 42 64 27 64 27 URL 26 XML 27, 36 55 Web 19 XML URL 25 18 17 17 7 Web 8 Web PHP 10 Web 16 Web IP 16 Web 15 XML 10, 22 8 15 16 13 20 19 IP 14 15 8 13 Web with PHP 10 Web with XML 10 Web 13 Web 13

76 Web 15 Web 15, 24 47 36, 45 XML 36, 45 45 47 48 36, 45 48 47 48 Web 16 16 16 16 [ ] 16 52 52 52 52 XML 24 19 Web 19 16 21 16 19 40, 41 8 IP 16 16 16 9 16 27 Web 15 URL 26 XML 27 XML 24 Web 40 XML 41 7 7, 14 XML 39 Web Web 40 21 XML 27 Web 15 Web 15 [ ] 16 16 [ ] 16 64 55.op 55 47 54 51 57 17, 18 DTD 27, 31

77 59 59 59 48 59 47 48 59 59 59 59 48 48 7 Web 15 Web 15 FMPXMLLAYOUT 33 FMPXMLRESULT 31 fmresultset 28 FMPXMLLAYOUT 35 FMPXMLRESULT 32 fmresultset 30 XML 38 53 52 40 Tomcat 44 web_server_module_log.txt 44 Web 42 42