FileMaker Server Custom Web Publishing with XML and XSLT

Transcription

1 FileMaker Server 11 Web with XML and XSLT

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento FileMaker, Inc. Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL 01

3 9 1 Web Web 12 Web 12 Web with PHP 13 Web with XML and XSLT 13 PHP XML XSLT 14 PHP 14 XML XSLT 14 2 Web with XML and XSLT Web Web 15 Web with XML 15 Web with XSLT 15 XSLT 16 Web with XML and XSLT 16 Web 17 Web 17 Web Web Web Web Web MIME ) 20 Web Web 21 FileMaker Web Web 23 Web 23

4 4 FileMaker Server Web with XML and XSLT 4 Web with XSLT FileMaker XSLT 25 FileMaker XSLT 25 Web with XSLT 25 Web XML XSLT 26 Web with XSLT 26 FileMaker XSLT Site Assistant FileMaker XSLT 27 XSLT Site Assistant 28 XSLT Site Assistant 28 XSLT Site Assistant 28 XSLT Site Assistant 29 Web FileMaker XSLT 29 XSLT 30 5 Web XML Web with XML 31 Web FileMaker Pro XML / 31 Web XML 32 Web XML 32 XML URL 33 XML URL 33 XML FileMaker URL 34 URL 34 Web XML 35 FileMaker XML 35 FileMaker 35 FileMaker 36 fmsresultset 36 fmresultset 36 fmresultset XML 38 FileMaker XML 38 FMPXMLRESULT 39 FMPXMLRESULT XML 40 FMPXMLLAYOUT 40 FMPXMLLAYOUT XML 42 UTF-8 43 FileMaker XML 43 XML 45

5 5 XML XML 46 6 FileMaker XSLT Web XSLT 47 FileMaker XSLT 48 FileMaker XSLT Starter Solution 48 FileMaker XSLT URL 48 XSLT FileMaker URL 49 FileMaker XSLT 50 FileMaker XSLT XML 50 FileMaker XSLT XSLT 53 FileMaker Server XSLT FileMaker XSLT 54 Web FileMaker XSLT Web URI 55 URI Web Web Cookie Perl

6 6 FileMaker Server Web with XML and XSLT 7 Web 73 Web 74 XML Web 75 Web 76 Web 76 Web 76 A FileMaker dbnames 81 -delete 81 -dup 81 -edit 81 -find -findall -findany 81 -findquery 82 -layoutnames 82 -new 82 -process XSLT 83 -scriptnames 83 -view 83

7 7 83 -db 83 -delete.related 83 -encoding XSLT 84 -field op 85 -grammar XSLT 85 -lay 85 -lay.response 86 -lop 86 -max 86 -modid ID 86 -query 87 -recid ID 87 -relatedsets.filter 88 -relatedsets.max 88 -script 88 -script.param 88 -script.prefind 89 -script.prefind.param 89 -script.presort 89 -script.presort.param 89 -skip 90 -sortfield 90 -sortorder 90 -stylehref href 91 -styletype 91 -token. [ ] XSLT 91 B Web FileMaker 93 Web 99 FileMaker XSLT

8 8 FileMaker Server Web with XML and XSLT

9 XML XSLT Web FileMaker Pro FileMaker Server Web with XML and XSLT 1 XML XSLT Web 1 XML XSLT 1 Web Web 1 FileMaker Server XML 1 FileMaker XSLT FileMaker Web FileMaker Server FileMaker Server Web Web with PHP PHP Site Assistant Web with XML and XSLT XSLT Site Assistant ODBC JDBC ODBC JDBC FileMaker Server FileMaker Server FileMaker Web FileMaker Server Web with PHP PHP Site Assistant FileMaker Server Web with XML and XSLT XSLT Site Assistant FileMaker ODBC JDBC FileMaker Server Auto Update FileMaker Pro FileMaker Server

10 10 FileMaker Server Web with XML and XSLT

11 1 Web FileMaker Server FileMaker Web Web Web Web Web Web Web FileMaker Pro FileMaker Server FileMaker Pro Web Web FileMaker Pro FileMaker Web FileMaker Pro 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 PHP FileMaker API FileMaker PHP Web PHP Site Assistant PHP Web PHP Web 1 Web with XML and XSLT 1 XML FileMaker Web 1 XSLT FileMaker Web XSLT Site Assistant XSLT

12 12 FileMaker Server Web with XML and XSLT Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML and XSLT Web XSLT HTML XML vcard Web Web Web Web Web Web HREF Web FileMaker URL Uniform Resource Locator URL XML XSLT Web XML XSLT Web with PHP Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web fp7.fp7 Web Web Web Web FM API PHP XSLT 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 1 XSLT Web XSLT XML Web HTML XML 6. Web Web Web FileMaker PDF

13 1 Web 13 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP FileMaker PHP Site Assistant FileMaker Pro PHP PHP Site Assistant Web Web PHP FileMaker PHP Site Assistant PHP Web FileMaker PHP PHP Site Assistant FileMaker API for PHP Web with XML and XSLT XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML XML XSLT XSLT FileMaker Web Web XML 1 XSLT FileMaker XML XML 1 1 Web Web Web XSLT HTTP URL Web FileMaker Web XML Web HTML FileMaker XSLT Site Assistant Web XSLT XSLT XSLT Site Assistant

14 14 FileMaker Server Web with XML and XSLT PHP XML XSLT PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP 1 PHP Web with PHP FileMaker Server Web with PHP XML XSLT 1 FileMaker XML 1 XML XSLT W3C 1 XML Unicode 1 XML 1 XSLT XML RSS RTF vcard 1 XSLT XML 1 1 Web FileMaker Pro XML FMPXMLRESULT 1 FileMaker Server FileMaker XSLT XSLT

15 2 Web with XML and XSLT Web Web Web XML XSLT FileMaker Server Web Web 1 Web FileMaker Web 1 FileMaker XML FileMaker Web 1 FileMaker XSLT FileMaker Web Web FileMaker Web 1 FileMaker Server Web XML Web XSLT Web FileMaker Web XML Web XSLT Web Web 1 XSLT 1 XSLT 1 Web XML XSLT URL Web with XML Web with XML Web with XML FileMaker HTTP FileMaker XML XML XML XSLT 5 Web XML Web with XSLT Web with XSLT XML Web XSLT FileMaker XML XML Web Web 4 Web with XSLT Web XSLT HTTP URL Web FileMaker Web XML Web HTML XML XSLT FileMaker Server Web

16 16 FileMaker Server Web with XML and XSLT XSLT FileMaker Server XSLT FileMaker XSLT Site Assistant XSLT FileMaker Web XSLT XSLT Site Assistant FileMaker XSLT XSLT 27 FileMaker XSLT Site Assistant FileMaker XSLT FileMaker Server World Wide Web Consortium XSLT 1.0 XSLT XSLT 1.0 Web with XML and XSLT XML XSLT FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 XSLT 1 XSLT JavaScript 68 1 FileMaker XSLT XML 51 1 FileMaker Pro Web 20 1 Web FileMaker 75 Web 21 FileMaker Web 1 FileMaker 88 -script.param 89 -script.prefind.param 89 -script.presort.param 1 fmresultset XML relatedset 1 XSLT Web 1 A 1 Web FileMaker Pro Web 80

17 2 Web with XML and XSLT 17 Web Web Web with XML and XSLT 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 and XSLT 1 Web 1 Web 1 Web IP FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP Web 1 FileMaker Server Admin Console Web FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 19 Web 1 XML FileMaker 5 Web XML 1 FileMaker XSLT 4 Web with XSLT

18 18 FileMaker Server Web with XML and XSLT

19 3 Web Web Web Web Web with XML Web with XSLT Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. 1 Web with XML fmxml 1 Web with XSLT fmxslt FileMaker Pro 8 fmxml fmxslt [ ] 3. Admin Web 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

20 20 FileMaker Server Web with XML and XSLT 1 Web Web Web 1 1 Web [ ] Web 1 FileMaker Pro Web Web [ ] Web FileMaker Pro Web with XML and XSLT 1 Web 1 Web with XML and XSLT 1 Web 1 Web FileMaker Server Admin Console Web Web FileMaker Server 1 Web IP Web IP Web IP Web 1 Web Web SSL Secure Sockets Layer SSL SSL Web FileMaker PDF Web MIME ) MIME Multipurpose Internet Mail Extensions Web Web Web MIME Web Web FileMaker Web Web

21 3 Web 21 FileMaker FileMaker Server 34 XML FileMaker URL 49 XSLT FileMaker URL QuickTime 1. FileMaker ProWeb 2. FileMaker Pro [ ] 3. WebWeb 1 IIS < >: Inetpub wwwroot 1 Apache / /WebServer/Documents MIME Web Web Web Web Web Web 1 OLE 1 Web Web 1 GIF JPEG Web Web JPEG FileMaker Web FileMaker Pro Web Web FileMaker FileMaker 75 Web URL XSLT <?xslt cwp query?> Web FileMaker Pro [ ] [ ] [Web ] Web FileMaker Pro

22 22 FileMaker Server Web with XML and XSLT Web 23 Web Web Web pe_application_log.txt76 Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ] 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web 1 [ / ] [ ] [ ] [ ] [ / ] Web [ / ] 1 Get( ) Web Publishing Engine Web FileMaker Pro 1 XSLT FileMaker Server Admin Console Web XSLT FileMaker Server

23 3 Web 23 Web Web FileMaker Pro FileMaker Pro / URL / Web FileMaker Server Web Web Web 22 Web Web Web Web Web Web Web [ ] Web [ ] Web [ / ] Web FileMaker Pro ( ) Web Web OnObjectEnter OnObjectEnter FileMaker Pro

24 24 FileMaker Server Web with XML and XSLT

25 4 Web with XSLT FileMaker XSLT XML Web FileMaker XSLT XSLT FileMaker XSLT Site Assistant FileMaker XSLT 6 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web Web 1 HTML vcard 1 FileMaker XML XML SVG Scalable Vector Graphics 1 FileMaker Web FileMaker 1 FileMaker Server Web with XSLT XSLT 1.0 W3C XSLT Cookie FileMaker XSLT 54 FileMaker XSLT Web XSL-FO XSL Formatting Objects FileMaker XSLT FileMaker XSLT 1 FileMaker Web Web Web FileMaker 1 FileMaker Web 1 FileMaker vcard Web 1 FileMaker XML XML Web with XSLT XML XSLT FileMaker XSLT FileMaker XML XSLT Web XSLT Site Assistant XML XSLT

26 26 FileMaker Server Web with XML and XSLT Web XML XSLT Web XSLT-CWP XSLT Web Web URL FileMaker XSLT Web 1. Web Web XSLT-CWP Web Web 3. CWPE Web XML FileMaker Server Web Web 4. Web FileMaker FileMaker 2. Web XSLT-CWP CWPE CWPE Web.fp7.fp7 Web FileMaker XSLT-CWP.fp7.fp7 Web XSLT Web FileMaker Server Web 5. FileMaker Web 8. Web Web Web Web 6. Web XML CWPE Web 7. CWPE XSLT XML HTML XML Web CWPE Web Web with XSLT XSLT Web 1. Admin Cosole XSLT FileMaker Server 2. FileMaker FileMaker Pro Web with XSLT fmxslt 19 Web FileMaker FileMaker

27 4 Web with XSLT FileMaker XML FileMaker XSLT XSLT FileMaker XSLT Site Assistant XSLT FileMaker XSLT Site Assistant FileMaker XSLT XSLT XSLT 6 FileMaker XSLT 4. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing xslt-template-files 5. Web 29 Web FileMaker XSLT 6. XSLT Web Web XSLT XSLT index.html Web Web XSLT 9. FileMaker XSLT Site Assistant FileMaker XSLT FileMaker XSLT Site Assistant XSLT FileMaker Web XSLT XSLT Site Assistant FileMaker XSLT XSLT XSLT Site Assistant Site Assistant Web FileMaker XSLT XSLT Site Assistant XSLT

28 28 FileMaker Server Web with XML and XSLT Web XSLT HTTP URL Web FileMaker Web XML Web HTML XSLT Site Assistant fmresultset XML FileMaker XML HTML FileMaker XML XML XSLT Site Assistant XSLT Site Assistant XSLT 1 fmxslt XSLT Site Assistant Web 19 Web 1 FileMaker Server FileMaker Server 1 FileMaker Server Web 1 FileMaker Server Web 1 XSLT Web XSLT FileMaker Server XSLT Site Assistant XSLT Site Assistant Java Runtime Environment 5 Java Runtime Environment 6 XSLT Site Assistant 1. [FileMaker Server Web ] URL >:16000/tools < > FileMaker Server 2. [PHP Site Assistant XSLT Site Assistant ] [FileMaker Server Web ] 3. [XSLT Site Assistant ] FileMaker Server JAR 4. XSLT Site Assistant [OK] XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant XSLT Site Assistant 29 Web FileMaker XSLT XSLT Site Assistant

29 4 Web with XSLT 29 XSLT Site Assistant XSLT Site Assistant XSLT FileMaker 1 <?xslt-cwp-query params="query string-fragment"?> XML XSLT Site Assistant 51 1 <xsl:param name="request-query"/> HTML XSLT Site Assistant 54 1 <xsl:param name="authenticated-xml-base-uri"/> XML URI 55 URI utilities.xsl XSLT Site Assistant XSLT XSLT Site Assistant 6 FileMaker XSLT Web FileMaker XSLT Web Web XSLT Site Assistant XSLT Web FileMaker XSLT 1. XSLT xslt-template-files xslt-template-files Web FileMaker Server Web Publishing xslt-template-files 2. XSLT HTML Web HTML <img src="logo.jpg"> XSLT logo.jpg logo.jpg Web < >/fmi/xsl/logo.jpg 3. FileMaker Pro Web Web 20 Web FileMaker FileMaker Server

30 30 FileMaker Server Web with XML and XSLT 4. XSLT URL < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 48 FileMaker XSLT URL Web XSLT XSLT Site Assistant <?xslt-cwp-query?> home.xsl home.xslxslt-template-files my_templates URL Web Web xslt-template-files XSLT Web Web Web XSLT XSLT 1 Web with XSLT 19 Web 1 FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XSLT 1 [FileMaker Server ] >:16000/test < > FileMaker Server 1 [XSLT Web ] FMServer_Sample XSLT FileMaker Server FileMaker Server

31 5 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 Web XSLT XML HTML vcard SVG Scalable Vector Graphics XML 4 Web with XSLT 6 FileMaker XSLT XML XML XML FileMaker Web Web XML XML 1.0 XML XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 1 XML XSLT Web Web fmresultset FMPXMLRESULT FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT FMPDSORESULT 35 Web XML 1 Web XML URL Web FileMaker Pro XML FileMaker Pro 1 Web FileMaker Server FileMaker Pro XML 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

32 32 FileMaker Server Web with XML and XSLT Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS Web 2. Web Web FileMaker Server Web Web 3. Web FileMaker FileMaker Web CWPE Web.fp7.fp7 Web FileMaker XML.fp7.fp7 FileMaker Web XML Web 5. Web XML Web FileMaker Server Web 4. FileMaker Web 6. Web Web Web Web Web CWPE Web Web XML Web FileMaker XML 1. FileMaker Server Admin Console XML FileMaker Server 2. FileMaker FileMaker Pro XML Web fmxml 19 Web XML [ ] [ ] [ ] XML XML XML

33 5 Web XML HTML HREF Web FileMaker XML FileMaker URL HTTP HTTPS Web Web URL URL XML URL 43 FileMaker XML A 4. Web URL XML Web 5. Web XML Web Web 46 XML URL Web FileMaker XML URL XSLT URL XML 48 FileMaker XSLT URL 49 XSLT FileMaker URL XML URL Web FileMaker XML URL < >://< >[:< >]/fmi/xml/<xml >.xml[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS <XML > FileMaker XML fmresultset.xml FMPXMLRESULT.xml FMPXMLLAYOUT.xml FMPDSORESULT.xml 36 fmsresultset 38 FileMaker XML 1 < > FileMaker XML -dbnames 43 FileMaker XML A URL URL FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT 77 Web XML URL

34 34 FileMaker Server Web with XML and XSLT XML FileMaker URL XML XML 1 <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 78 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > XML URL 1 <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 20 Web 1 <data> XML XSLT 49 XSLT FileMaker URL URL XML URL UTF-8 Unicode Transformation 8 Bit 43 UTF-8 infofiancée URL &info= fianc%c3%a9e&-edit URL %C3%A9 UTF-8 é URL URL URL

35 5 Web XML 35 Web XML Web XML FileMaker FileMaker FileMaker URL Web XML XML 1 fmresultset Web XSLT FileMaker XML XSLT Web FMPXMLRESULT 36 fmsresultset 1 FMPXMLRESULT FMPXMLLAYOUT:XML XSLT FMPXMLRESULT FMPXMLLAYOUT Web XML Web FMPXMLRESULT FMPXMLLAYOUT 38 FileMaker XML 1 FMPDSORESULT:FMPDSORESULT FileMaker Pro XML Web XML FMPDSORESULT XSLT FMPDSORESULT FileMaker Pro URL Web XML XML XML FileMaker XML Web FileMaker XML Web XML UTF-8 Unicode Transformation Format 8 43 UTF-8 FileMaker XML XML XML <DATABASE> FileMaker XML Oracle XML XML <DATABASE> Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns=" xmlns=" fmpxmlresult" xmlns=" FileMaker Web XML 0 fmresultset FMPXMLRESULT FMPDSORESULT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE>

36 36 FileMaker Server Web with XML and XSLT XML XSLT B Web FileMaker FileMaker DTD HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT FMPDSORESULT HTTP >[:< ]/fmi/xml/fmresultset.dtd >[:< ]/fmi/xml/fmpxmlresult.dtd >[:< ]/fmi/xml/fmpxmllayout.dtd >[:< ]/fmi/xml/fmpdsoresult.dtd?-db=< >&-lay= < > fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml 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 dd yyyy - 1 XML <datasource> time-format HH:mm:ss

37 5 Web XML 37 1 HH mm ss <datasource> timestamp-format date-format time-format MM/dd/yyyy HH:mm:ss <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 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

38 38 FileMaker Server Web with XML and XSLT fmresultset XML fmresultset XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "" <fmresultset xmlns=" version="1.0"> <error code="0" /> <product build="12/31/2012" name="filemaker Web Publishing Engine" version=" " /> <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" timeof-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" timeof-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" 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="artlocations::date" not-empty="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" timeof-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> FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml

39 5 Web XML 39 FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAME RECORDS DATEFORMAT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 36 fmresultset FMPXMLRESULT <METADATA> FIELD <FIELD> / Yes / No EMPTYOK MAXREPEAT TEXT NUMBER DATE TIME CONTAINER <RESULTSET> <ROW> <ROW> / RECORDID MODID 86 -modid ID <COL> <COL> / <DATA>

40 40 FileMaker Server Web with XML and XSLT FMPXMLRESULT XML FMPXMLRESULT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "" <FMPXMLRESULT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION=" " /> <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> FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <VALUELISTS> <VALUELIST> <VALUE> FileMaker [ ] <VALUE> DISPLAY ID ("100" ) ("Impressionism" ) [ ] DISPLAY

41 5 Web XML 41 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> 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 65 birthdaysbirthdatebirthdate fm

42 42 FileMaker Server Web with XML and XSLT FMPXMLLAYOUT XML FMPXMLLAYOUT XML <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLLAYOUT PUBLIC "-//FMI//DTD FMPXMLLAYOUT//EN" "" <FMPXMLLAYOUT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="12/31/2012" NAME="FileMaker Web Publishing Engine" VERSION=" " /> <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>

43 5 Web XML 43 UTF-8 Web XML UTF-8 Unicode Transformation Format 8 ASCII Unicode 16 XML Unicode UTF-8 UTF-8 ASCII Unicode UTF-8 Web UTF-8 1 ASCII UTF-8 ASCII UTF-8 1 ASCII 1 UTF UTF-8 Unicode 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker -new -dbnames -db URL FileMaker XSLT <?xslt-cwp-query?> 6 FileMaker XSLT FileMaker A Web FileMaker XSLT -process 50 FileMaker XSLT -dbnames -delete -dup -edit -find -findall -findany -findquery -layoutnames Web Web

44 44 FileMaker Server Web with XML and XSLT -new -scriptnames -view 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 -process XSLT -edit URL 34 XML FileMaker URL -edit -find 84 find -dbnames -layoutnames -scriptnames -process XSLT -dbnames -layoutnames -scriptnames -process XSLT -find -find -findall -edit -findquery edit delete dup find -find -edit -new -dup -findquery -find -edit -new -dup -findquery -find -findall -findany -new -edit -delete -dup -view -script -find -findany -findall -script.prefind -find -findall -script.presort -find -findall -find -findall -find -findall

45 5 Web XML 45 -stylehref HREF -styletype -styletype URL XML lay XML XML XML XML lay.response Budget Salary 100,000 ExecList Salary &-lay.response=execlist XML XML XML FileMaker Server Web XML 1. lay 2. URL.global= 3. script.prefind 4. find new 5. script.presort lay.response 8. script 9. XML sortfield 102

46 46 FileMaker Server Web with XML and XSLT Web XSLT Web XML XSLT Web 4 Web with XSLT 6 FileMaker XSLT FileMaker styletype stylehref Web XML XML CSS Cascading Style Sheet XSLT 1 styletype TYPE type=text/css type=text/xsl 1 stylehref HREF href=/mystylesheet.css href=/stylesheets/mystylesheet.xsl.css.xsl FileMaker stylehref=/document.xsl / Web Web URL Web Web XML <?xml stylesheet type="text/xsl" href="/mystylesheet.xsl"?> HREF URL Web xslt-template-files XSLT 29 Web FileMaker XSLT Web Web XML Web XML 1 XML Web 19 Web 1 FileMaker Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server

47 6 FileMaker XSLT FileMaker XSLT FileMaker XSLT Web XSLT Web FileMaker XML XSLT 1 Web XSLT URL XSLT Web Web 48 FileMaker XSLT URL 1 UTF-8 Web ASCII 1 FileMaker XML URL <?xslt-cwp-query?> XML Web 50 FileMaker XSLT XML 1 FileMaker XML URL <?xslt-cwp-query?> 48 FileMaker XSLT URL encoding XSLT Web 52 1 <xsl:output> method Web HTML <xsl:output> encoding 52 1 fmxslt:send_ () Web 60 Web Web <?xslt-cwp-query?> <?xslt-cwp-query?> URL Web <?xslt-cwp-query?> URL Web FileMaker XML Web HTML

48 48 FileMaker Server Web with XML and XSLT FileMaker XSLT FileMaker XSLT XSLT Reference.fp7 FileMaker FileMaker Server Mac OS / /FileMaker Server/Example/XSLT Windows < >: Program Files FileMaker FileMaker Server Examples XSLT < > FileMaker XSLT Starter Solution XSLT FileMaker XSLT Starter Solution XSLT Starter Solution FileMaker Server Mac OS / /FileMaker Server/Example/XSLT/Starter Solution Windows < >: Program Files FileMaker FileMaker Server Examples XSLT Starter Solution < > FileMaker XSLT URL FileMaker XSLT Web URL < >://< >[:< >]/fmi/xsl/[< >/]<.xsl>[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS < > XSLT xslt-template-files 1 <.xsl> XSLT 1 < > Web with XSLT 50 FileMaker XSLT A <?xslt-cwp-query?> URL 51 URL URL FMPXMLRESULT FMPXMLLAYOUT 77

49 6 FileMaker XSLT 49 FileMaker XSLT Web URL &-lay=mylayout&-findall XSLT FileMaker URL XSLT XML 1 <data> URL <data>/fmi/xsl/cnt/data.< >?< ></data> < >.jpg.mov < > FileMaker XSLT URL <data>/fmi/xsl/cnt/data.jpg? db=products& lay=sales& field=product_image(1)& recid=2</data> XML -field 78 < >://< >[:< >]/fmi/xml/cnt/data.< >?< > < > < > < > FileMaker XSLT URL db=products& lay=sales& field=product_image(1)& recid=2 1 <data> logo.jpg FileMaker ProWeb <data> <data>/images/logo.jpg</data> FileMaker Pro Web Web 20 Web 1 <data>

50 50 FileMaker Server Web with XML and XSLT FileMaker XSLT URL FileMaker XSLT <?xslt-cwp-query?> FileMaker XML 43 FileMaker XML FileMaker XSLT XSLT -grammar -encoding -process -token XSLT-CWP XSLT XML FileMaker XSLT XML FileMaker Server XSLT Cookie 53 XSLT XSLT -grammar XSLT FileMaker XSLT XML Web with XSLT XML fmresultset XSLT 36 fmsresultset FMPXMLRESULT FMPXMLLAYOUT FMPXMLLAYOUT 38 FileMaker XML Web with XSLT FMPDSORESULT FileMaker XSLT URL <?xslt-cwp-query?> -grammar URL &-lay=mylayout&-findall <?xslt-cwp-query params="-grammar=fmresultset&-db=mydatabase&-lay=mylayout&-findall"?> FileMaker XSLT XML QUERY -ER0001 B Web FileMaker XSLT XSLT XSLT FileMaker XSLT FileMaker XSLT <xsl:stylesheet> fmresultset XML xmlns:fmrs=" fmrs FMPXMLRESULT xmlns:fmp=" fmp FMPXMLLAYOUT xmlns:fml=" fml XML xmlns:fmq=" fmq FileMaker XSLT xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" fmxslt

51 6 FileMaker XSLT 51 FileMaker XSLT xmlns:xsl=" <xsl:stylesheet version="1.0" xmlns:xsl=" xmlns:fmrs=" xmlns:fml=" xmlns:fmq=" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" exclude-result-prefixes="xsl fmrs fmq fml fmxslt"> FileMaker XSLT XML URL XSLT Site Assistant FileMaker XSLT <?xslt-cwp-query params="query string-fragment"?> query string-fragment = & 2= db=products -findall =A URL 34 URL <xsl:output> encoding Web & my_stylesheet.xsl <?xslt-cwp-query params="-db=products&-lay=sales&-grammar=fmresultset&productname=the%20item&-find"?> my_stylesheet.xsl products sales fmresultset the%20itemproductname -find my_stylesheet.xsl XML Web London&-find -lay=revenue -edit city citylondon Web XML

52 52 FileMaker Server Web with XML and XSLT Web XSLT 1. Content-Type charset 2. -encoding URL <?xslt-cwp-query?> -encoding &-encoding=shift_jis&-findall 3. Web [ :] Web Shift_JIS Web Admin Console FileMaker Server Web Content-Type charset encoding US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 ASCII Latin 1 ASCII Web Latin 9 Latin 1 ISO Web Unicode Web UTF-8 UTF-8 Unicode 1 Web Shift_JIS Web ISO-2022-JP Admin Console 1 fmxslt:send_ (string SMTP, String, String ) 60 Web <xsl:output> method encoding method html textxml html encoding

53 6 FileMaker XSLT 53 <xsl:output method="html" encoding="shift_jis"/> <xsl:output> HTML XSLT XML encoding XSLT 52 UTF-8 <?xml version="1.0" encoding="utf-8"?> Web UTF-8 FileMaker Server XSLT -process XSLT -process FileMaker Server -process fmxslt:send_ () 1 -process Web XML -process -grammar fmresultset FMPXMLRESULT -token URL Cookie -token URL &-token.d100=pending&-findall 91 -token. [ ] XSLT -token -token <xsl:param name="request-query" /> 54

54 54 FileMaker Server Web with XML and XSLT FileMaker XSLT FileMaker XSLT fmxslt XSLT <xsl:stylesheet> fmxslt 50 FileMaker XSLT FileMaker XSLT XPath XSLT XPath XSLT select test User-Agent User-Agent <xsl:variable name="user-agent" select="fmxslt:get_header('user-agent')"/> XSLT FileMaker XSLT FileMaker XSLT 48 FileMaker XSLT Web FileMaker XSLT Web FileMaker XSLT <xsl:param> FileMaker XSLT <xsl:param name="request-query"/> <xsl:param name="client-ip"/> <xsl:param name="client-user-name"/> <xsl:param name="client-password"/> <xsl:param name="xml-base-uri"/> <xsl:param name="authenticated-xml-base-uri"> Web URI 55 URI FileMaker XSLT URL HTML Web FileMaker XML FileMaker XSLT <xsl:param name="request-query"/> Web request-query XML <!DOCTYPE query [ <!ELEMENT query (parameter)*> <!ATTLIST query action CDATA #REQUIRED> <!ELEMENT parameter (#PCDATA)> <!ATTLIST parameter name CDATA #REQUIRED> ] fmq=" XSLT <xsl:stylesheet> fmq 50 FileMaker XSLT

55 6 FileMaker XSLT 55 <xsl:param name="request-query" /> Web XML <query action="my_stylesheet.xsl" xmlns=" <parameter name="-db">products</parameter> <parameter name="-lay">sales</parameter> <parameter name="-grammar">fmresultset</parameter> <parameter name="-token.1">abc123</parameter> <parameter name="-findall"></parameter> </query> XPath request-query URL = ' token.1'] FileMaker XSLT Web Web IP <xsl:param name="client-ip"/> <xsl:param name="client-user-name"/> <xsl:param name="client-password"> XSLT <xsl:template> XML Web 56 Web HTTP 19 FileMaker XSLT FileMaker XSLT Web URI Web URI Uniform Resource Identifier Web URI FileMaker XML Web Web URI XSLT <xsl:template> <xsl:param name="xml-base-uri"/> FileMaker XML $xml-base-uri URI XML URI <xsl:variable name="layout_information" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-db=products&-lay=sales&- view'))" /> URI authenticated-xml-base-uri client-user-name client-password xml-base-uri <xsl:param name="authenticated-xml-base-uri"/> XML XSLT <xsl:template>

56 56 FileMaker Server Web with XML and XSLT client-user-name client-password authenticated-xml-base-uri client-user-name client-password authenticated-xml-base-uri xml-base-uri XSLT XML XML URI XSLT document() document() XML <xsl:variable> FileMaker XML document() FileMaker <xsl:variable name="other-data" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-db=products&-lay=sales&-view'))" /> XML authenticated-xml-base-uri document() URI <xsl:variable name="other-data" select="document(concat($authenticated-xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-db=products&- lay=sales&-view'))"/> XML document() URI FileMaker XML FileMaker document() <xsl:variable name="other-data" select="document(' /> document() URL Web XML xslt-template-files mystylesheets URL document() <xsl:variable name="mydoc" select="document('mystylesheets/mydoc.xml')" /> Web xslt-template-files mystylesheetsmydoc.xml Web Web URI HTTP HTTP HTTPS

57 6 FileMaker XSLT 57 FMPXMLLAYOUT XSLT document() FileMaker <xsl:variable name="layout" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-view'))" /> Color FileMaker shirts Color ID "100" color"light Green" document() DISPLAY XSLT <xsl:variable name="layout" select="document(concat($xml-base-uri,'/fmi/xml/fmpxmllayout.xml?-db=products &-lay=sales&-view'))" /> <select size="1"> <xsl:attribute name="name">color</xsl:attribute> <option value=""> Select One...</option> <xsl:for-each = 'shirts']/fml:value"> </select> <option> </option> </xsl:for-each> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:value-of Web XSLT Web XSLT XSLT FileMaker 1 fmxslt:create_session(): 58 1 fmxslt:set_header(): 61 1 fmxslt:set_status_code (): 61 1 fmxslt:set_cookie(): 62 Cookie FileMaker XSLT <?xslt-cwp-buffer buffer-content="true"?> <?xslt-cwp-buffer?> Web Content-Length Web

58 58 FileMaker Server Web with XML and XSLT Web Web Web Web Cookie ID Cookie fmxslt:session_encode_url() ID URL URL fmxslt:session_encode_url() jsessionid URL ID <a href="my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset&-findall">hyperlinked text</a> <a href="{fmxslt:session_encode_url('my_stylesheet.xsl?-db=products&-lay=sales&-grammar=fmresultset &-findall')}">hyperlinked text</a> Cookie <a href="my_stylesheet.xsl;jsessionid=<session id>?-db=products&-lay=sales&-grammar=fmresultset&-findall"> hyperlinked text</a> Cookie Web fmxslt:session_encode_url() URL Cookie ID Web XML fmxslt:session_exists(string - ) fmxslt:create_session(string - ) Admin Console FileMaker Server <?xslt-cwp-buffer?> 57 fmxslt:invalidate_session(string - ) fmxslt:set_session_timeout(string -, Number ) Admin Console fmxslt:session_encode_url(string URL) Cookie ID URL URL

59 6 FileMaker XSLT 59 fmxslt:set_session_object(string -, String, Object ) XSLT XSLT fmxslt:get_session_object () set_session_object() remove_session_object() fmxslt:get_session_object(string -, String ) fmxslt:remove_session_object(string -, String ) XSLT XSLT XSLT XSLT <xsl:variable name="session"> <xsl:choose> <xsl:when test="not (fmxslt:session_exists(string($session-name)))"> <xsl:value-of select="fmxslt:create_session(string($session-name))"/> </xsl:when> <xsl:otherwise>true</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="favorite-color" select="fmxslt:set_session_object(string($session-name), 'favorite-color', string($color))"/> 1 fmxslt:invalidate_session () 1 Admin Console Web XSLT FileMaker Server 1 Web Web

60 60 FileMaker Server Web with XML and XSLT Web Web Web Web XSLT fmxslt:send_ () fmxslt:send_ () Web XSLT Web fmxslt:send_ (string SMTP, String ) fmxslt:send_ (string SMTP, String, String ) Web Web US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 52 fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) <xsl:output> encoding HTML <xsl:output> encoding HTML <xsl:output> encoding Web 1 fmxslt:send_ () SMTP URL RFC 2368 mailto = & / 1 from 1 / subject= from reply-to subject false() 1 " tld com net 1 subject SMTP URL & & %20SMTP XML 1 true() false()

61 6 FileMaker XSLT 61 1 Web Shift_JIS Admin Console FileMaker Server 1 fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) XML 1 XSLT URL 1 XML XML XML XML XPath / document() fmxslt:send_ () XML 1 HTML Web true() FileMaker URL Web false () URL Web URL Web <xsl:if> XPath fmxslt:send_ (string SMTP, String XSLT, Node XML, boolean ) fmxslt:send_ ('[email protected]?subject=project%20status&[email protected] &[email protected]','my_mail_template.xsl', /, true()) SMTP Web FileMaker Server fmxslt:get_header() HTTP fmxslt:set_header() Web HTTP fmxslt:get_header(string ) fmxslt:set_header(string, String ) void fmxslt:set_status_code(number ) void HTTP 1 fmxslt:get_header() fmxslt:set_header() fmxslt:set_header() 1 fmxslt:set_header() fmxslt:set_status_code() <?xslt-cwp-buffer?> 57 vcard.xsl vcard Content-Disposition.vcf <xsl:value-of select="fmxslt:set_header('content-disposition','attachment;filename=test.vcf')" />

62 62 FileMaker Server Web with XML and XSLT Cookie Cookie Web Cookie Cookie fmxslt:get_cookie(string ) Cookie COOKIES fmxslt:get_cookies() Cookie COOKIES fmxslt:set_cookie(string, String ) void Cookie fmxslt:set_cookie(string, String, Number, String, String ) void Cookie Cookie Cookie 1 fmxslt:get_cookie() fmxslt:get_cookies() <!ELEMENT cookies (cookie)*> <!ATTLIST cookie xmlns CDATA #FIXED " <!ELEMENT cookie (#PCDATA)> <!ATTLIST cookie name CDATA #REQUIRED> 1 Cookie XML " 1 fmxslt:set_cookie Web fmxslt:set_cookie 1 Cookie 1 fmxslt:set_cookie() <?xslt-cwp-buffer?> 57 get_cookie preferences Cookie <xsl:variable name="pref_cookie" select="fmxslt:get_cookie('preferences')"/> <xsl:value-of select="concat('cookie Name = ', $pref_cookie/fmc:cookies/fmc:cookie/@name)"/> <br/> <xsl:value-of select="concat('cookie Value = ', $pref_cookie/fmc:cookies/fmc:cookie)"/> set_cookie Cookie <xsl:variable name="storing_cookie" select="fmxslt:set_cookie ('text1', 'text2', 1800, 'my_text', 'my.company.com')" />

63 6 FileMaker XSLT 63 fmxslt:break_encode(string ) HTML & & <br/> <xsl:value-of> <xsl:text> disable-output-escaping yes disable-output-escaping="yes" fmxslt:break_encode() Enter Window return Mac OS fmxslt:html_encode(string ) HTML & & fmxslt:url_encode(string ) URL URL URL URL & %26 href URL fmxslt:url_encode(string, String ) encoding URL US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 Web Web UTF-8 Shift_JIS Shift_JIS fmxslt:url_decode(string ) URL URL fmxslt:url_decode(string, String ) encoding URL US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 URL Web ISO Perl 5 fmxslt:regex_contains() Perl 5 fmxslt:regex_contains(string input, String pattern) input pattern Perl 5 Perl 5 fmxslt:regex_contains()

64 64 FileMaker Server Web with XML and XSLT XSLT Perl 5 <xsl:variable name=" " select="'[email protected]'"/> <xsl:if test="fmxslt:regex_contains($ ,'^\w+[\w-\.]*\@\w+((-\w+) (\w*))\.[a-z]{2,3}$')">valid </xsl:if> Web FileMaker XSLT FileMaker fmxslt:contains_checkbox_value(string valuestring, String valuelistentry) valuestring XPath valuelistentry true() false() HTML checked FileMaker [ ] Red [ ] Blue [ ] Green [ ] Small [ ] Medium [ ] Large [Red] Red Blue fmxslt:contains_checkbox_value(< >,'Blue') < > <data> XPath false Web Web HTML XSLT color_sizestyle <xsl:variable name="field-value" select="fmrs:field[@name='style']/fmrs:data" /> <xsl:for-each select="$valuelists[@name = 'color_size']/fml:value"> <input type="checkbox"> <xsl:attribute name="name">style</xsl:attribute> <xsl:attribute name="value"><xsl:value-of select="."/></xsl:attribute> <xsl:if test="fmxslt:contains_checkbox_value($field-value,.)"> </xsl:if> </input><xsl:value-of select="."/><br/> </xsl:for-each> <xsl:attribute name="checked">checked</xsl:attribute>

65 6 FileMaker XSLT 65 HTML XSLT [Red] [Medium] Web [x] Red [ ] Blue [ ] Green [ ] Small [x] Medium [ ] Large fmfm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss JavaScript fmxslt:get_date() fm fmxslt:get_date(string ) short longfm fmxslt:get_time() fm fmxslt:get_time(string ) short longfm fmxslt:get_day() fmxslt:get_day(string ) short long fmxslt:get_fm_date_format() fmmm/dd/yyyy fmxslt:get_short_date_format() M/d/yy fmxslt:get_long_date_format() MMM d, yyyy fmxslt:get_fm_time_format() fmhh:mm:ss fmxslt:get_fm_timestamp_format() fm MM/dd/yyyy HH:mm:ss fmxslt:get_short_time_format() h:mm a fmxslt:get_long_time_format() h:mm:ss a z fmxslt:get_short_day_format() EEE fmxslt:get_long_day_format() EEEE fmxslt:compare_date(string, String ) fm

66 66 FileMaker Server Web with XML and XSLT fmxslt:compare_time(string, String ) fm fmxslt:compare_day(string, String ) fmxslt:get_datetime(string ) fmxslt:convert_datetime(string, String, String ) fmxslt:compare_datetime(string, String, String, String ) AZ az AZ az G y 1996; 96 M 7 ; 7 ; 07 w 27 W 2 D 189 d 10 F 2 E ; a AM/PM H 23 0 k K AM/PM 11 0 h AM/PM 12 12

67 6 FileMaker XSLT 67 m 30 s 55 S 978 z ; PST Z RFC yyyy/mm/dd12/01/ y yy yy/mm/dd/ /01/ /05/ /01/02 003/01/02-3/01/ GMT 1 GMT GMT : Unicode Basic Latin RFC RFC 822 RFC RFC

68 68 FileMaker Server Web with XML and XSLT :08:56 "yyyy.mm.dd G 'at' HH:mm:ss z" at 12:08:56 PDT ""EEE, MMM d, ' 'yy", 7 4, '01 "h:mm a" "hh 'o' 'clock' a, zzzz" "K:mm a, z" "yyyyy.mmmmm.dd GGG hh:mm aaa" 12:08 12 o'clock, 0:08, PDT :08 "EEE, d MMM yyyy HH:mm:ss Z", :08: "yymmddhhmmssz" Copyright 2003 Sun Microsystems, Inc. XSLT FileMaker XSLT fmxslt:check_error_status() fmxslt:check_error_status() Web 101 FileMaker XSLT XSLT <xsl:message> Web 76 Web Web XSLT JavaScript XSLT Java 1 bsf.jar - XSLT 1 js.jsr - Mozilla JavaScript XSLT XSLT XPath XSLT Apache Xalan Extensions Web

69 6 FileMaker XSLT xalan XSLT fmp-ex <xsl:stylesheet version="1.0" xmlns:xsl= xmlns:xalan= xmlns:fmp-ex="ext1" exclude-result-prefixes="xsl xalan fmp-ex"> 2. <xalan:component prefix="fmp-ex" functions="getvaluecolor"> <xalan:script lang="javascript"> function getvaluecolor(value) { } </xalan:script> </xalan:component> if (value > 0) else return ("#009900"); return ("#CC0000"); "#009900""#CC0000" <xalan:component> <xsl:stylesheet> 3. XPath "#009900" <font color= {fmp-ex:getvaluecolor(50)} > 50 </font> "#CC0000" <font color= {fmp-ex:getvaluecolor(-500)} > -500 </font> JavaScript <xsl:choose> XSLT XPath XML Yahoo! Web CSV XPath document() XML CSV XML JavaScript CSV URL Yahoo! Web CSV >&f=l1gh&e=.csv < > 31.79,31.17,32.12

70 70 FileMaker Server Web with XML and XSLT Yahoo! Web XPath JavaScript XSLT <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet > exclude-result-prefixes="xsl fmxslt fmrs xalan fmp-ex" version="1.0" xmlns:xsl=" xmlns:fmrs=" xmlns:fmxslt="xalan://com.fmi.xslt.extensionfunctions" xmlns:xalan=" xmlns:fmp-ex="ext1" <?xslt-cwp-query params="-grammar=fmresultset&-process"?> <xsl:output method="html"/> <xalan:component prefix="fmp-ex" functions="include get_quote" > <xalan:script lang="javascript"> function include(url) { var dest = new java.net.url(url); var dis = new java.io.datainputstream(dest.openstream()); var res = ""; while ((line = dis.readline())!= null) { res += line + java.lang.system.getproperty("line.separator"); } dis.close(); return res; } function get_quote(ticker) { url = " + "+ticker+"&f=l1gh&e=.csv"; csv_file = include(url); var str_tokenizer = new java.util.stringtokenizer(csv_file, ','); // the first token is the last trade price var last = str_tokenizer.nexttoken(); return last; } </xalan:script> </xalan:component> <xsl:template match="/fmrs:fmresultset"> <html> <body> <font size="2" face="verdana, arial"> Apple :<xsl:value-of select="fmp-ex:get_quote('aapl')"/> </font> </html> </body> </xsl:template> </xsl:stylesheet>

71 6 FileMaker XSLT 71 Web Yahoo! Web get_quote()

72 72 FileMaker Server Web with XML and XSLT

73 7 Web Web 1. 3 Web 2. XSLT XML FileMaker Server Admin Console FileMaker Server 3. Web Web 4. Web XSLT Web XSLT 1 Apache Mac OS/ /FileMaker Server/Web Publishing/xslt-template-files 1 IIS Windows< >: Program Files FileMaker FileMaker Server Web Publishing xslt-template-files < > xslt-template-files 5. Web FileMaker Pro Web Web FileMaker Server FileMaker

74 74 FileMaker Server Web with XML and XSLT 6. URL XSLT HTML < >://< >[:< >]/fmi/xsl/< >/< >.xsl[?< >] 1 < > HTTP HTTPS 1 < > Web IP 1 < > Web HTTP 80 HTTPS < > XSLT xslt-template-files 1 < >.xsl 1 < > Web with XSLT <?xslt-cwp-query?> URL XSLT Site Assistant home.xsl A URL URL home.xslxslttemplate-filesmy_templates URL Web Web xslt-template-files XSLT Web Web XSLT Site Assistant HTML Web Web Web Web 21 FileMaker Web 1 Web Web Web FileMaker Server URL Web URL 32 Web XML 48 FileMaker XSLT URL

75 7 75 XML XML XSLT 1 XML Web XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl=" xmlns:fmrs=" <xsl:output method="xml"/> <xsl:template match="/"> <xsl:copy-of select="."/> </xsl:template> </xsl:stylesheet> 1 HTML <textarea> XML XSLT XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" <html> </html> xmlns:xsl=" xmlns:fmrs=" <xsl:output method="html"/> <body> <xsl:template match="/fmrs:fmresultset"> <textarea rows="20" cols="100"> </textarea><br/> </xsl:template> </body> </xsl:stylesheet> <xsl:copy-of select="."/> Web Web 1 Web 1 Web 1 Web 1 Web Web Apache Mac OS Apache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web IIS WindowsMicrosoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web

76 76 FileMaker Server Web with XML and XSLT W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web Web Web Web 1 Web Web 1 Web Web 1 XSLT XSLT <xsl:message> Web XSLT <xsl:message> 6 FileMaker XSLT pe_application_log.txtweb FileMaker Server Logs pe_application_log.txt Web pe_application_log.txt [ :] Web Web [ :] Web Web [ :] Web Web Admin Console FileMaker Server Web Web Web Web web_server_module_log.txtweb FileMaker ServerLogs Web Web Web Web 1 wpc_access_log.txt XML FileMaker Server Web Web Web 1 pe_internal_access_log.txt XSLT Web XSLT-CWP XML Web XSLT-CWP Web Web FileMaker ServerLogs Web [ ] FileMaker Server

77 A Web FileMaker -dbnames (81 ) -delete (81 ) -dup (81 ) -edit (81 ) -find -findall -findany (81 ) -findquery (82 ) -layoutnames (82 ) -new (82 ) -process (XSLT ) (83 ) -scriptnames (83 ) -view (83 ) -db (83 ) -encoding (XSLT ) (84 ) -field (84 ) 84.op 85 -grammar (XSLT only) (85 ) -lay (85 ) -lay.response (86 ) -lop (86 ) -max (86 ) -modid (86 ) -query (87 ) -recid (87 ) -relatedsets.filter (88 ) -relatedsets.max (88 ) -script (88 ) -script.param (88 ) -script.prefind (89 ) -script.prefind.param (89 ) -script.presort (89 ) -script.presort.param (89 ) -skip (90 ) -sortfield.[1-9] (90 ) -sortorder.[1-9] (90 ) -stylehref (91 ) -styletype (91 ) -token.[string] (XSLT ) (91 ) -dbnames -layoutnames -scriptnames -process XSLT -lay 1 -new -new -edit 1 -dbnames -process -db 43 FileMaker XML

78 78 FileMaker Server Web with XML and XSLT 1 -db=employees findall = 1 -delete -lay 1 MyLayout -lay=mylayout XSLT <xsl:value-of select="fmrs:field[@name='lastname']"/> LastName LastName 1 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML XSLT ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe FileMaker FileMaker.fp7 FileMaker FileMaker Server Mac: / /FileMaker Server/Examples/XSLT Windows: < >: Program Files FileMaker FileMaker Server Examples XSLT : < > table-name::field-name(repetition-number).record-id 1 table-name

79 A 79 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 &ID=9756&Dependents::Names.0=Jane&-new 1 -edit ID ID ID XML <relatedset> <record> record-id 36 fmsresultset URL ID 1001 Dependents NamesNames.2 2 ID &Dependents::Names.2=Kevin&-edit &Dependents::Names.2=Kevin&Dependents::Names.5=Susan&-edit -edit ID &Dependents::Names.0=Timothy&-ledit

80 80 FileMaker Server Web with XML and XSLT -delete -edit -delete.related URL employees URL Dependents 1001 ID 3 &ñdelete.related=dependents.3&ñedit 83 -delete.related -relatedsets.filter - relatedsets.max 88 -relatedsets.filter 88 -relatedsets.max :: ( ).global global 78 FileMaker Pro.global Web XML XSLT XSLT.global Web &Country.global=USA&-recid=1&-edit XSLT Admin Console Web XSLT FileMaker Server

81 A 81 XML XSLT XSLT -grammar -dbnames FileMaker Server Web with XML XSLT -delete -recid -db -lay -recid -script -dup -recid -db -lay -recid -script -edit / -recid recid -db -lay -recid -modid -script find -findall -findany -db -lay -recid -lop -op -max -skip -sortorder -sortfield -script -script.prefind -script.presort

82 82 FileMaker Server Web with XML and XSLT FileMaker Server ID -findall -findany -findquery -db -lay -query -max -skip -sortorder -sortfield -script -script.prefind -script.presort Fluffy &-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal&-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 1 -query findquery -query 87 -query -layoutnames FileMaker Server Web with XML XSLT -db -new / -db -lay -script 79

83 A 83 -process XSLT XSLT XSLT -grammar fmresultset FMPXMLRESULT 53 FileMaker Server XSLT -scriptnames FileMaker Server Web with XML XSLT -db -view FMPXMLLAYOUT FMPXMLLAYOUT fmresultset FMPXMLRESULT XML metadata -db -lay -script XML XSLT XSLT 50 FileMaker XSLT -db -db -db -dbnames -process -delete.related -edit

84 84 FileMaker Server Web with XML and XSLT ID jobtable 7 ID encoding XSLT XSLT Web with XSLT US-ASCII ISO ISO ISO-2022-JP Shift_JIS UTF-8 XSLT &-grammar=fmresultset&-encoding=shift_jis&-findall 52 -field 34 XML FileMaker URL 49 XSLT FileMaker URL -find / - FileMaker 1 myfield.9 1 op opmyfield.op 1 global global myfield.global text.fieldhttp XML XSLT 78 ID -new -edit -find fm fm MM/dd/yyyy HH:mm:ss MM/dd/yyyy HH:mm:ss -edit -new -find &-max=1&-find FileMaker Server

85 A 85.op -find begins with eq FileMaker Pro = cn * * bw * ew gt gte lt lte neq * > >= < <=, -find :: = & ::.op= 1 1 cn 1 bw FileMaker Pro... bw... &-find FileMaker Pro -grammar XSLT XSLT Web with XSLT fmresultset FMPXMLRESULT FMPXMLLAYOUT : XSLT &-lay=mylayout&-findall 50 FileMaker XSLT XML -lay

86 86 FileMaker Server Web with XML and XSLT -dbnames -layoutnames -scriptnames -process (XSLT ) -lay.response -lay XML - lay.response -lay.response -lay -lay.response XML XSLT -dbnames -layoutnames -scriptnames -process XSLT -lay.response=execlist -lop -find and or and or -lop -find and -find -findquery &Birthdate=2/5/1972&-lop=and&-find -max all all max -find -findall -findquery -modid ID ID -edit ID ID ID -edit ID ID FileMaker ID -edit -recid &last_name=jones&-edit

87 A 87 -query 82 -findquery -findquery -query=< >< >&-findquery < > 1 qq1 1 AND (q1, q2) q1 q2 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 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 ID FileMaker -edit -delete -dup -find -view

88 88 FileMaker Server Web with XML and XSLT -relatedsets.filter layout none 1 none 1 layoutfilemaker Pro [ ] [ ] 1 [] [ ] -relatedsets.max 1 [ ] FileMaker Pro [ ] [ ] 1 -relatedsets.filter noneweb -find -edit -new -dup -findquery &-relatedsets.max=all&-findany &-relatedsets.max=10&-findany -relatedsets.max all 1 Web 1 all Web 1 -relatedsets.max -relatedsets.filter 88 -relatedsets.filter -find -edit -new -dup -findquery &-relatedsets.max=all&-findany &-relatedsets.max=10&-findany -script FileMaker 45 XML -dbnames -layoutnames -process -scriptnames -script.param -script FileMaker 1 param1%7cparam2%7cparam3 URL param1 param2 param3

89 A 89 1 GetAsNumber(Get( )) 1 -script -script.param -script.param 1 -script.param Web -script &-script.param=smith%7cchatterjee%7csu&-findall -script.prefind -find FileMaker -dbnames -layoutnames -process -scriptnames -script.prefind.param -script.prefind FileMaker 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web -script.prefind &-script.prefind.param=payroll&-findall -script.presort -find FileMaker -dbnames -layoutnames -process -scriptnames &-sortfield.1=dept&-sortfield.2=rating&-findall -script.presort.param -script.presort FileMaker

90 90 FileMaker Server Web with XML and XSLT 1 param1%7cparam2%7cparam3 URL param1 param2 param3 1 GetAsNumber(Get( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web -script.presort &-script.presort.param=18%7c65&-sortfield.1=dept&-sortfield.2=rating&-findall -skip -find sortfield -find -findall -sortfield -sortfield. = -sortfield. dept rating -sortorder &-sortfield.2=rating&-findall -sortorder < > Custom FileMaker Pro a z z a < > -find -findall -sortfield

91 A 91 -sortorder -sortfield -sortorder. = 1 -sortorder. -sortorder -sortfield 1 ascend dept ascend rating descend -sortorder.2 -sortorder.2=descend -sortfield.2=rating &-sortorder.1=ascend&-sortfield.2=rating&-sortorder.2=descend&-findall -sortorder -stylehref href XML CSS Cascading Style Sheet XSLT XML href href=/mystylesheet.css href=/stylesheets/mystylesheet.xsl-stylehref.css.xsl 46 -styletype -styletype mystylesheet.xsl Web &-stylehref=/mystylesheet.xsl&-findall -styletype XML CSS Cascading Style Sheet XSLT XML type type=text/css type=text/xsl46 -stylehref -stylehref mystylesheet.css Web &-stylehref=/mystylesheet.css&-findall -token. [ ] XSLT Cookie XSLT Web with XSLT -token.[ ] a z A Z URL XSLT &-grammar=fmresultset&-token.d100=active&-findall 53

92 92 FileMaker Server Web with XML and XSLT

93 B Web Web Web 1 XML Web FileMaker 1 Web Web Web 99 Web 1 FileMaker XSLT XSLT fmxslt:check_error_status() 101 FileMaker XSLT FileMaker XML Web XML fmresultset <error code> FMPXMLRESULT FMPDSORESULT <ERRORCODE> fmresultset <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "/fmi/xml/fmresultset.dtd"> <fmresultset xmlns=" 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=" <ERRORCODE>0</ERRORCODE> <error code> <ERRORCODE> Web Web [ ] 6 7 8

94 94 FileMaker Server Web with XML and XSLT UTF A Z a z 0 9 ASCII

95 B Web ID FileMaker Pro ) FileMaker Pro

96 96 FileMaker Server Web with XML and XSLT EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSLT 718 Xerces XML 719 Xalan XSL XML Excel Excel 7.0 Excel 95Excel XP 2007

97 B Web Bento FileMaker Server FileMaker Pro 807 FileMaker Pro / 810 / 811 FileMaker Pro FMI FileMaker FileMaker Server

98 98 FileMaker Server Web with XML and XSLT XML Web ( 1205 */ ( * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 Get 1216 GetSummary

99 B Web 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 1450 PHP SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP Web Web Web Web 1 <xsl:include> 1 XML 1 XSLT XPath 1 CGI XML 1 Web XML Web

100 100 FileMaker Server Web with XML and XSLT Web Web QUERY-ER0001 -grammar XML QUERY-ER0002 xxx FileMaker XSLT XML FILE-ER0001 FILE-ER0002 UNKNOWN MCS-000 MCS-600 MCS-601 MCS-602 MCS-603 MCS-604 MCS-605 MCS-606 MCS-607 MCS-700 MCS-800 x x URL x x HTTP x x content-type x XML x x Web Web pe_server_error.html FileMaker Web XSLT pe_server_error.html pe_server_error.html pe_server_error.html Web publishing-engine cwpe Web FileMaker Server

101 B Web 101 FileMaker XSLT fmxslt:check_error_status() HTTP SMTP To From CC BCC Subject Reply-To XSLT send_ () SMTP XSLT set_header() set_status_code() set_cookie() SMTP

102 102 FileMaker Server Web with XML and XSLT URL 10311

103 A auto-enter 37 B break_encode() 63 C check_error_status() 68, 101 compare_date() 65 compare_datetime() 66 compare_day() 66 compare_time() 66 contains_checkbox_value() 64 convert_datetime() 66 Cookie 62 ID 58 create_session() 58 CWPE Web 32 D <datasource> 36 -dbnames 81 -db 83 -delete.related 80 -delete 81 -dup 81 E -edit 81 -encoding 84 <error code> <ERRORCODE> 93 Extensible Markup Language XMLXML F <field-definition> 37 -field 84 FileMaker Pro Web 31 FileMaker Server 9 9 FileMaker Server Admin Admin Console 20 FileMaker Server Admin Console 32 FileMaker Site Assistant XSLT Site Assistant FileMaker XSLT fmxslt FileMaker XSLT 54 -findall 81 -findany 81 -findquery 82 -find 81 FMPDSORESULT 35 FMPXMLLAYOUT FMPXMLRESULT fmresultset 31, fmxslt fmxslt:break_encode() 63 fmxslt:check_error_status() 68, 101 fmxslt:compare_date() 65 fmxslt:compare_datetime() 66 fmxslt:compare_day() 66 fmxslt:compare_time() 66 fmxslt:contains_checkbox_value() 64 fmxslt:convert_datetime() 66 fmxslt:create_session() 58 fmxslt:get_cookie() 62 fmxslt:get_cookies() 62 fmxslt:get_date() 65 fmxslt:get_datetime() 66 fmxslt:get_day() 65 fmxslt:get_fm_date_format() 65 fmxslt:get_fm_time_format() 65 fmxslt:get_fm_timestamp_format() 65 fmxslt:get_header() 61 fmxslt:get_long_date_format() 65 fmxslt:get_long_day_format() 65 fmxslt:get_long_time_format() 65 fmxslt:get_session_object() 59 fmxslt:get_short_date_format() 65 fmxslt:get_short_day_format() 65 fmxslt:get_short_time_format() 65 fmxslt:get_time() 65 fmxslt:html_encode() 63 fmxslt:invalidate_session() 58, 59 fmxslt:regex_contains() 63 fmxslt:remove_session_object() 59 fmxslt:send_ () 60 fmxslt:session_encode_url() 58 fmxslt:session_exists() 58 fmxslt:set_cookie() 62 fmxslt:set_header() 61 fmxslt:set_session_object() 59 fmxslt:set_session_timeout () 58 fmxslt:set_status_code() 61 fmxslt:url_decode() 63 fmxslt:url_encode() 63 four-digit-year 37 FileMaker API for PHP 13 fmresultset 35

104 104 FileMaker Server Web with XML and XSLT G get_cookie() 62 get_cookies() 62 get_date() 65 get_datetime() 66 get_day() 65 get_fm_date_format() 65 get_fm_time_format() 65 get_fm_timestamp_format() 65 get_header() 61 get_long_date_format() 65 get_long_day_format() 65 get_long_time_format() 65 get_session_object() 59 get_short_date_format() 65 get_short_day_format() 65 get_short_time_format() 65 get_time() 65 GIF Web 21 global 37 -grammar 85 H HTML XML 31 XML 33 html_encode() 63 I invalidate_session() 58, 59 ISO-2022-JP 52 ISO ISO J JavaScript 68 JDBC 9 JPEG Web 21 L -lay.response 45, 86 -layoutnames 82 -lay 45, 85 -lop 86 M max-characters 37 max-repeat 37 -max 86 <metadata> 37 MIME Multipurpose Internet Mail Extensions20 -modid 86 N name 37 -new 82 not-empty 37 numeric-only 37 O ODBC 9 P PDF 9 pe_application_log.txt 76 pe_internal_access_log.txt 76 pe_server_error.html 100 Perl 63 PHP 30 -process 53, 83 PHP Q -query 87 QuickTime Web 21 R -recid 87 regex_contains() extension 63 <relatedset-definition> 37 -relatedsets.filter 88 -relatedsets.max 88 remove_session_object() 59 <resultset> 37 result 37 S SAT Admin Console 20 Scalable Vector Graphics SVGXML 31 -script.param 88 -script.prefind.param 89 -script.prefind 89 -script.presort.param 89 -script.presort 89 -scriptnames 83 -script 88 send_ () 60 session_encode_url() 58 session_exists() 58 set_cookie() 62 set_header() 61 set_session_object() 59 set_session_timeout () 58

105 105 set_status_code() 61 Shift_JIS 52 Site Assistant 16 Site Assistant XSLT Site Assistant -skip 90 -sortfield 90 -sortorder 90 SSL Secure Sockets Layer20 -stylehref 91 -styletype 91 T -token 53, 91 type 37 U Unicode 43 url_decode() 63 url_encode() extension 63 URL XML 34 XML 33 XSLT 48 XSLT 49 URL 34 US-ASCII 52 User-Agent 54 UTF-8 Unicode Transformation 8 Bit 52 34, 43 V vcard XML 31 -view 83 W web_server_module_log.txt 76 Web 12 Web Admin Console 26, 32 Web 75 MIME 20 XML 32 Web 75 Web FileMaker 9 Web Web 75 Web QuickTime 21 XML 15, 32 XSLT 26, , Web 21 Web XML Web 21 Web 17 19, 56 Web 19 Web wpc_access_log.txt 76 Web Admin Console 26, 32 XML 32 XML Web X XML fmresultset 36 <metadata> 37 <resultset> 37 <datasource> 36 <field-definition> 37 <relatedset-definition> 37 FMPXMLLAYOUT 40 FMPXMLRESULT 39 URL 34 UTF-8 35, 43 XML XML 46 XML 32 XML 46 43, , 43 DTD 36, 39

106 106 FileMaker Server Web with XML and XSLT 35 XML XML 45 XML 45 XML XSLT 14 XML fmxml 19, 32 XML 33 XML 31 XML 31 XML 45 XML ASCII 43 XML 35 XML 45 XML 45 XML Web 13 XPath 54 <xsl:message> 68 <xsl:output> 52 <xsl:param name="authenticated-xml-base-uri"/> 55 <xsl:param name="client-ip"/> 55 <xsl:param name="client-password"/> 55 <xsl:param name="client-user-name"/> 55 <xsl:param name="request-query"/> 54 <xsl:param name="xml-base-uri"/> 55 <xsl:param> 54 <xsl:stylesheet> 50, 54, 75 <xsl:template> 55, 75 <xsl:variable> 56 <?xslt-cwp-buffer buffer-content="true"?> 57 <?xslt-cwp-query?> 47, 51 XSLT grammar 50 Cookie 62 FileMaker XSLT 54 FileMaker 54 JavaScript 68 Perl 63 Web 29 XSLT XSLT-CWP 26 XSLT Site Assistant 27 xslt-template-files 27, XSLT Site Assistant xslt-template-files 27, 29 XSLT fmxslt 19, 26 XSLT 51 XSLT 83 XSLT FileMaker 54 XSLT 16, 27 XSLT Web 13 Web Web , 76 Web pe_application_log.txt 76 pe_server_error.html 100 Web 99 Web , FMPXMLLAYOUT 40 FMPXMLRESULT 39 fmresultset 36 35

107 107 -encoding 84 URL 34, 58 XML 35, 43 <xsl:output> 52 XSLT Web 21 XML URL 34 XSLT URL 49 20, 29 9 Web 99 Web Web XML 13 XSLT 13 Web 20 Web IP 20 Web 19 XML 31 XSLT IP Web 16 Web 17 Web 19 Web 19, 26, , 50, 77 XML 43, 77 XSLT 50 XSLT , 50, , 46 XSLT , 80 59, Web XSLT 25, 47 [ ] Web <xsl:output>

108 108 FileMaker Server Web with XML and XSLT XML Web grammar 50 Cookie 62 Perl 63 Web 29 XML 46 XSLT Site Assistant 27 XSLT , , IP , 80 Web 19 -encoding 84 URL 34, 58 XSLT XML XML 32 XSLT 26 Web 74 XML document() 56 9, 17 XML 46 XSLT 30 Web Web URI 55 XML 35 XSLT 50

109 109 Web 19, 55 XML 56 Web 19 [ ] [ ] Web op DTD 36, 39 URI Perl Web 19, 55 XML 56 Web FMPXMLLAYOUT 42 FMPXMLRESULT 40 fmresultset 38 XML pe_application_log.txt 76 pe_internal_access_log.txt 76 web_server_module_log.txt 76 Web 75 <xsl:message> 76 <xsl:message>

110 110 FileMaker Server Web with XML and XSLT