Administrator’s Guide
Table Of Contents
- Preface Introducing FileMaker Pro 5.5 Unlimited
- Chapter 1 Installing the FileMaker Web Server Connector
- Chapter 2 Administering the Web Server Connector
- Chapter 3 Publishing your database on the Web
- Types of web publishing
- Using the FileMakerPro Web Companion
- Creating a custom home page
- Creating a custom home page for Instant Web Publishing
- Creating a custom web site using a database layout
- Web Companion support for Internet mediatypes
- Monitoring your site
- Exporting data to a static HTML page
- Testing your site without a networkconnection
- Opening password-protected databasesremotely
- Chapter 4 Custom web publishing using CDML
- About the CDML examples
- General steps for custom web publishing using CDML
- About CDML format files
- Generating FileMakerPro CGI requests using CDML
- Using the CDML Tool and templates
- Modified CDML tags
- About the CDML Reference database
- Creating error messages
- Using an encoding parameter with a CDML replacement tag
- Planning your web site
- Chapter 5 Using FileMakerPro XML to deliver your data
- About the XML examples
- General process for custom web publishing using XML
- Generating an XML document
- Using the FMPDSORESULT grammar
- Using the FileMakerPro Extended XMLgrammars
- About UTF-8 encoded data
- Generating FileMakerPro CGI requests for an XML document
- Using style sheets with your XMLdocument
- Comparing CSS, XSLT, and JavaScript
- Looking at the XML Inventory example
- Chapter 6 Using Java and JDBC to deliver your data
- About the JDBC examples
- About JDBC
- Using the FileMaker JDBC Driver
- SQL supported by the FileMaker JDBCDriver
- FileMakerPro support for Unicodecharacters
- About the FileMaker JDBC Driver interfaces and extensions
- Example 1: Looking at the FileMakerPro Explorer application
- Example 2: Creating the JBuilder Inventoryapplication
- Example 3: Creating the Visual Cafe Inventory application
- Using the FileMaker Java classes
- Appendix A Valid names used in CGI requests for FileMaker XML data
- Generating a –find, –findall, or –findany request
- Generating a –view request
- Generating a –new request
- Generating an –edit request
- Generating a –delete request
- Generating a –dbnames request
- Generating a –layoutnames request
- Generating a –scriptnames request
- Generating a –dbopen request
- Generating a –dbclose request
- Specifying parameters for the request
- –db (Database)
- –lay (Layout)
- –format (Format)
- –recid (Record ID)
- –modid (Modification ID)
- –lop (Logical operator)
- –op (Comparison operator)
- –max (Maximum records)
- –skip (Skip records)
- –sortfield (Sort field)
- –sortorder (Sort order)
- –script (Script)
- –script.prefind (Script before Find)
- –script.presort (Script before Sort)
- –styletype (Style type)
- –stylehref (Style href)
- –password (Database password)
- field name (Name of specific field)
- Appendix B FileMaker Pro values for error codes
- Appendix C Enabling the FileMaker Pro Web Companion in MacOS X
- Index
I-2 FileMaker Pro 5.5 Unlimited Administrator’s Guide
W3C 5-16, 5-17
document type definitions (DTDs) 5-2, 5-3,
5-5
double colons in portal fields
in CGI requests 4-4, 5-9
in XML documents 5-4
driver properties, for FileMaker JDBC
URL 6-3
–dso_xml format parameter 5-3
E
–edit requests
CDML examples 4-4
XML examples 5-10, A-3
editing multiple records in portals 4-4, 5-9
elements
in FMPDSORESULT grammars 5-4
in FMPXMLLAYOUT grammars 5-7
in FMPXMLRESULT grammars 5-5
Employee Database CDML example 4-15
encoded XML 5-3, 5-8
encoding parameters for CDML 4-6, 4-14
encrypting data 6-3
error codes B-1
Error Log File option 3-4, 3-15
-errorfrtfield variable tag 4-9
errors
creating error messages 4-13
-errnum CDML variable tag 4-13
-error CDML variable tag 4-13
Error folder 4-13
error pages recognized by the Web
Companion 4-13
specifying FileMaker Pro error
codes 4-13, 5-3, B-1
escape driver property 6-4
escaping of lower ASCII characters 6-7
example CGI requests for XML A-1
examples
comparing CSS, XSL, and
JavaScript 5-11
Employee Database 4-15
FileMaker Pro Explorer 6-8
generated FMPDSORESULT
grammar 5-4
generated FMPXMLLAYOUT
grammar 5-7
generated FMPXMLRESULT
grammar 5-6
Guest Book 4-16
JBuilder Inventory 6-11
registering the FileMaker JDBC
Driver 6-3
Shopping Cart 4-17
using proprietary FileMaker Java
classes 6-18
Visual Cafe Inventory 6-14
XML and CSS 5-13
XML and JavaScript 5-16
XML and XSLT 5-14
XML Inventory 5-17
exporting data into HTML tables 3-16
Extensible Markup Language (XML). See
XML
Extensible Stylesheet Language (XSL). See
XSL stylesheets
Extensible Stylesheet Language–
Transformations (XSLT). See XSLT example
external function plug-ins
Web Companion 3-15
external functions
for web site monitoring 3-15
in calculation fields and scripts 3-15
F
fetchsize driver property 6-4
field name request parameter A-10
field names, spaces in 5-4, 6-3, 6-12
FileMaker Java Class Library
described 3-1
using 6-17
FileMaker JDBC Driver
data type mapping 6-7
described 6-1
driver class and main entry point 6-2
escaping lower ASCII characters 6-7
examples 6-8, 6-11, 6-14
FileMaker extensions 6-8
implementing JDBC 1.2 API 6-2
including with FileMaker Pro Java
applications and applets 6-2
JDBC interfaces 6-7
opening and closing databases 6-5
registering with the JDBC driver
manager 6-2, 6-3
specifying the JDBC URL 6-2
SQL support 6-4
using 6-2
working with JDK 1.1 and Java 2 6-2
FileMaker Pro 4.0 Java classes 6-17
FileMaker Pro CGI requests
adding records to portals 4-4, 5-9
and script buttons 3-9
CDML request and parameter names 4-4
described 3-2
editing multiple records in portals 4-5, 5-9
example CGI requests for XML A-1
for accessing databases 3-2
for CDML 4-3
for XML 5-2, 5-8
using JavaScript 3-9, 5-16
XML request and parameter names 5-8
FileMaker Pro Explorer application
described 6-8
starting 6-9