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-4 FileMaker Pro 5.5 Unlimited Administrator’s Guide
JDBC
See also FileMaker JDBC Driver
described 6-1
JDBC 1.2 API 6-2
JDBC URL 6-2
L
-lay request parameter A-6
-layoutnames requests A-4
layouts, creating for custom web sites 3-8
links
HREF 3-2, 3-6, 4-4, 5-2
testing 3-18
to CDML format files 4-2
to IP addresses 3-6
XML example requests A-1
Linux
installing Web Server Connector on 1-7
requirements for WSC 1-4
localhost networking 3-18
log files
generated by the Web Companion 3-14
generated by the Web Server
Connector 2-5
-lop request parameter A-7
M
Mac OS X Server
installing Web Server Connector on 1-6
requirements for WSC 1-3
Mac OS X, enabling Web Companion in C-1
–mailfmtfield variable tag 4-9
mapping data type 6-4, 6-7
-max request parameter A-8
messages
error, examples of 4-14
errors sent by the Web Companion 4-13,
B-1
Microsoft Internet Information Server 1-4
Microsoft Notepad 5-20
Microsoft Windows. See Windows
Microsoft XML Data Source Object
(DSO) 5-2, 5-3
MIME (Multipurpose Internet Mail
Extensions) types 3-13
ModId pseudo column 6-4
-modid request parameter A-7
monitoring web sites
using external functions 3-15
using log files 3-14
MRJ 2.2 6-8
N
namespaces, XML
described 5-3
for the FMPDSORESULT grammar 5-4
for the FMPXMLLAYOUT grammar 5-7
for the FMPXMLRESULT grammar 5-6
NCSA/CERN-compatible Common Log
Format 3-14
Netscape Communicator 4.0 6-18
–new requests
CDML examples 4-4
XML examples 5-9, A-2
Note 4-4
Notepad 6-10, 6-11
O
ODBC (Open Database Connectivity) driver
See also JDBC, FileMaker JDBC Driver
Java equivalent 6-1
onClick JavaScript 3-9
onClick scripting event 5-16
onLoad event handler 5-16
-op request parameter A-7
P, Q
password driver property 6-4
People.fp5 database 5-12
people_form.css stylesheet 5-13
people_form.htm page 5-16
people_form.xsl stylesheet 5-15
plug-ins
third-party 1-1
Web Companion 3-2
port, setting up for Mac OS X C-1
portals
adding records 4-4, 5-9
editing multiple records 4-4, 5-9
primary key. See RecordId pseudo column
protecting databases
in subfolders of the Web folder 3-18
with record-level passwords 3-4
with remote administration
passwords 3-18
with Web Security Database 3-4
publishing on the Web
See also Web Companion
comparing static HTML form with dynamic
CDML 4-16
database error codes B-1
described 3-1
encrypting data 6-3
error pages 4-13
exporting data into HTML tables 3-1, 3-16
FileMaker Pro database-aware Java
applets 3-1, 6-1, 6-18
FileMaker Pro databases 3-1
in Mac OS X C-1
read-only databases 5-2
using CDML 3-1, 3-2, 4-2
using custom home pages 3-5
using Instant Web Publishing 3-2
using JDBC 3-1
using XML 3-1, 5-2