Page #99 (List of Tables)

Chapter 1: The Basics of XML

Listing 1.1: Example of Hypertext Markup Language

Listing 1.2: Example of XHTML

Listing 1.3: people.xml

Listing 1.4: greeting.xml

Listing 1.5: Properly nested markup tags in a document

Listing 1.6: XML documents with external DTD references

Listing 1.7: Example comments

Listing 1.8: Comments around table cell

Listing 1.9: Comment around table row

Listing 1.10: Single-line or multiple-line comments

Listing 1.11: Examples of elements with attributes

Listing 1.12: Example of mixed content

Listing 1.13: Markup for raw or unparsed data

Listing 1.14: Character data using predefined entities

Listing 1.15: The complete tree

Listing 1.16: Sample ASCII codes and character representation

Listing 1.17: URL with more information

Listing 1.18: Example URIs

Listing 1.19: people.xml

Listing 1.20: Example for XPointer references

Chapter 2: XML Import and Export with FileMaker Pro 6

Listing 2.1: Simple XML export with FMPDSORESULT

Listing 2.2: Simple XML export with FMPXMLRESULT

Listing 2.3: Sample double-byte XML export characters

Listing 2.4: ASCII characters 195 through 200

Listing 2.5: FMPXMLRESULT export of related fields

Listing 2.6: FMPDSORESULT export of related fields

Listing 2.7: FMPXMLRESULT export in FileMaker Pro 6

Listing 2.8: FMPDSORESULT export in FileMaker Pro 6

Listing 2.9: FMPXMLRESULT export of a repeating field

Listing 2.10: FMPDSORESULT export of a repeating field

Listing 2.11: Listing Printed export XML script

Listing 2.12: NameChange.xsl

Listing 2.13: ExportTransformed.xml

Listing 2.14: Sample XML with multiple levels

Listing 2.15: Calculated items XML and result

Listing 2.16: Calculated invoices XML and result

Listing 2.17: Troi-Coding encryption and decryption

Listing 2.18: Crypto Toolbox encryption and decryption

Chapter 3: Document Type Definitions (DTDs)

Listing 3.1: XML document with an internal DTD

Listing 3.2: XML document with external DTD

Listing 3.3: mydoc.xml

Listing 3.4: Element definition with children

Listing 3.5: people.xml

Listing 3.6: people.dtd

Listing 3.7: Elements with single attribute and default values

Listing 3.8: An element with multiple attributes and separate definitions

Listing 3.9: An element with multiple attributes and one definition

Listing 3.10: Attribute list for element IDs

Listing 3.11: Sample definitions for XSD plug-in

Chapter 4: FileMaker Pro XML Schema or Grammar Formats (DTDs)

Listing 4.1: Layout and field information results

Listing 4.2: Fields formatted on a layout

Listing 4.3: Value list FMPXMLLAYOUT results

Listing 4.4: FMPXMLLAYOUT Document Type Definition

Listing 4.5: Export FMPXMLRESULT fields

Listing 4.6: XML results from -format=-fmp_xml or export as FMPXMLRESULT

Listing 4.7: Metadata in the XML results

Listing 4.8: Resultset (rows and columns) of data

Listing 4.9: FMPXMLRESULT Document Type Definition

Listing 4.10: DSO results for records/rows

Listing 4.11: FMPDSORESULT Document Type Definition

Listing 4.12: Database Report.xml

Listing 4.13: Summary XML for the database report

Listing 4.14: Summary.xsl

Listing 4.15: DTD for summary XML report

Listing 4.16: Report XML for the Database Design Report

Listing 4.17: FieldCatalog elements

Listing 4.18: Field Reference elements

Listing 4.19: Value List Reference elements

Listing 4.20: Relationship Reference elements

Listing 4.21: Script Reference elements

Listing 4.22: Layout Reference elements

Listing 4.23: File Reference elements

Listing 4.24: Function Reference elements

Listing 4.25: RelationCatalog elements

Listing 4.26: ValueListCatalog elements

Listing 4.27: LayoutCatalog elements

Listing 4.28: Example report data

Listing 4.29: ScriptCatalog elements

Listing 4.30: Sample script data

Listing 4.31: Script steps for open script

Listing 4.32: External sub-script reference

Listing 4.33: PasswordCatalog elements

Chapter 5: XML and FileMaker Pro Web Publishing

Listing 5.1: Database and layout requests

Listing 5.2: New Record requests and result

Listing 5.3: Edit requests and result

Listing 5.4: Delete requests and results

Listing 5.5: Find Records requests and results

Listing 5.6: View Layout Information request and result

Listing 5.7: Request for database names and result

Listing 5.8: Request for layout names and result

Listing 5.9: Request for script names and result

Listing 5.10: Request for FMPDSORESULT

Listing 5.11: Request for FMPXMLRESULT

Listing 5.12: Request for FMPDSORESULT with DTD

Listing 5.13: DTD for FMPDSORESULT request

Listing 5.14: DTD for FMPXMLRESULT request

Listing 5.15: Request for FMPXMLLAYOUT and result

Listing 5.16: AND request with XML results

Listing 5.17: Scripted AND find for multiple fields

Listing 5.18: AND request using LOP with XML results

Listing 5.19: Scripted AND find for single field

Listing 5.20: OR request with XML results

Listing 5.21: Scripted OR finds

Listing 5.22: Creating an options request in HTML

Listing 5.23: The cost request

Listing 5.24: Sample login request

Listing 5.25: Giving the user a choice for -max

Listing 5.26: Result of adding a new related record

Listing 5.27: Result of editing a portal row

Listing 5.28: Sample default.htm

Listing 5.29: Sample redirect for default.htm

Listing 5.30: Request to a database in a frame page

Listing 5.31: index.html

Listing 5.32: Request to database using a form

Chapter 6: Using HTML and XHTML to Format Web Pages

Listing 6.1: META element examples

Listing 6.2: Grouping text

Listing 6.3: Quotations in the HTML document

Listing 6.4: Structured text elements

Listing 6.5: Preformatted text code and result

Listing 6.6: Unordered list

Listing 6.7: Ordered lists

Listing 6.8: Definition lists

Listing 6.9: Simple table

Listing 6.10: Text flow around a table

Listing 6.11: Table with header and footer

Listing 6.12: Table rows and columns with span

Listing 6.13: Nested tables

Listing 6.14: Anchor element

Listing 6.15: Image and object examples

Listing 6.16: Target attributes

Listing 6.17: Frameset with rows

Listing 6.18: Frameset with columns

Listing 6.19: Framesets with rows and columns

Listing 6.20: frame.html

Listing 6.21: A.html

Listing 6.22: B.html

Listing 6.23: CD1.html

Listing 6.24: CD2.html

Listing 6.25: C1.html

Listing 6.26: D1.html

Listing 6.27: C2.html

Listing 6.28: D2.html

Listing 6.29: Plain.html

Listing 6.30: Check boxes vs. radio buttons

Listing 6.31: SELECT and OPTION elements

Listing 6.32: Hidden INPUT type

Listing 6.33: Submit XML actions

Listing 6.34: New record requests

Listing 6.35: Duplicate records

Listing 6.36: Edit records

Listing 6.37: Delete records

Listing 6.38: Find records with AND logical operator

Listing 6.39: Find records with -recid, -findany, or -findall

Listing 6.40: View layout information request

Chapter 7: Extensible Stylesheet Language (XSL) and FileMaker Pro

Listing 7.1: HTML elements with namespaces

Listing 7.2: HTML elements without namespaces

Listing 7.3: Namespace usage

Listing 7.4: XML with embedded XSL

Listing 7.5: stripSpace.xsl

Listing 7.6: Conditional XSL

Listing 7.7: Creating a hyperlink with a field value

Listing 7.8: Displaying an image with path name field

Listing 7.9: Dynamic table

Listing 7.10: Value list in XML

Listing 7.11: XSL to use value list

Listing 7.12: HTML select list

Listing 7.13: XSL to create check boxes

Listing 7.14: Value list with found set

Listing 7.15: roll.css

Listing 7.16: CSSrollover.htm

Chapter 8: XSLT Examples for FileMaker Pro XML

Listing 8.1: transform1.xsl

Listing 8.2: transform2.xsl

Listing 8.3: transform2.txt

Listing 8.4: transform3.xsl

Listing 8.5: transform3.xml

Listing 8.6: transform4.xsl

Listing 8.7: transform4.xml

Listing 8.8: Create the FIELD elements

Listing 8.9: transform5a.xsl

Listing 8.10: transform5a.xml

Listing 8.11: transform5b.xsl

Listing 8.12: transform5b.xml

Listing 8.13: dso2html1.xsl

Listing 8.14: dso2html1.htm

Listing 8.15: dso2html2.xsl

Listing 8.16: dso2html2.htm

Listing 8.17: Map of columns

Listing 8.18: Sample text output

Listing 8.19: Define an ENTITY

Listing 8.20: Begin variable_fixed.xsl

Listing 8.21: Set up each column and default template

Listing 8.22: makeCol template

Listing 8.23: Test the padding character

Listing 8.24: makeCol template complete

Listing 8.25: textPad template

Listing 8.26: variable_fixed.xsl

Listing 8.27: customers.xml

Listing 8.28: customers.xsl

Listing 8.29: custOrders.xsl

Listing 8.30: custOrders.xml

Listing 8.31: OrdersCust.xml

Listing 8.32: OrdersCust.xsl

Listing 8.33: OrdersCustXML.xsl

Listing 8.34: OrdersCustHTML.htm

Listing 8.35: OrdersCustHTML.xsl

Listing 8.36: Orders.xml

Listing 8.37: Scripts

Listing 8.38: ImportItems.xsl

Listing 8.39: ImportOrders.xsl

Listing 8.40: ImportCustomers.xsl

Listing 8.31: export.xml