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
Index I-5
R
Rapid Application Development (RAD)
tools 3-1, 6-1, 6-2
Raw encoding parameter 4-14
-recid request parameter A-6
RecordId pseudo column 6-4
Red Hat Linux. See Linux
registering
FileMaker JDBC Driver 6-2
FileMaker Pro Unlimited vii
Remote Administration option 3-4
requesting data. See FileMaker Pro CGI
requests
requirements for installing WSC 1-3
Restrict access to IP addresses option 3-4
S
schemas. See XML grammars
-script request parameter A-9
-script.prefind request parameter A-9
-script.presort request parameter A-9
scripting languages
See also JavaScript
JavaScript 5-3
VBScript 5-3
-scriptnames requests A-4
scripts
for FileMaker Pro CGI requests 5-2
in layout for custom home page 3-9
using external functions 3-15
searching
databases on the Web 3-1, 4-15
TechInfo database viii
security 3-3, 3-4
SELECT SQL statements 6-4, 6-6
setting up single-machine networks 3-18
sharing
databases via the Web Companion 3-5
Shopping Cart CDML example 4-15, 4-17
SimpleText 6-10
-skip request parameter A-8
-sortfield request parameter A-8
-sortorder request parameter A-8
spaces in field names 5-4, 6-3, 6-12
SQL statements
delivered by JDBC drivers 6-1
supported by FileMaker JDBC Driver 6-4
SQL-92 Entry Level compliant 6-2
static web publishing 3-1, 3-16, 4-16
Status (CurrentError) function B-1
-stylehref request parameter A-9
stylesheets
CSS 5-10, 5-11, 5-13
described 5-2
XML-stylesheet processing
instruction 5-2, 5-10
XSL 5-10, 5-11
XSLT 5-14
–styletype and –stylehref parameters 5-10
-styletype request parameter A-9, A-10
subname, for FileMaker JDBC URL 6-2
subprotocol, for FileMaker JDBC URL 6-2
suppressing Instant Web Publishing
controls 3-11
Swing 1.1.1 6-1, 6-8
Symantec Visual Cafe 6-1
system requirements 1-3
T
TCP/IP port number 3-4
TechInfo database
described viii
searching viii
technical support
for FileMaker Pro Unlimited vii
templates
CDML 4-7
Toggle Status Area script step 3-12
-token tags 4-10, 4-17
trapping errors B-1
U
Unicode characters 5-8, 6-7
uninstalling the Web Server Connector
Linux 1-8
Windows 1-5
UPDATE SQL statements 6-4, 6-6
URL encoding parameter 4-14
URLs (Uniform Resource Locators)
accessing Java resources 6-2
FileMaker JDBC URL 6-2
for FileMaker Pro CGI requests 5-2
loaded by the FMBanner Java applet 6-18
using to access databases 3-1
user driver property 6-4
UTF-8 (Unicode Transformation 8 Bit)
format 5-8
V
VBScript 5-3
-view requests A-2
Visual Cafe 4.0 Expert Edition for
Windows 6-1, 6-14
W
W3C Document Object Model 5-16, 5-17
web browsers
for Java Class Library examples 6-18
for XML Inventory example 5-17
for XML Simple Examples 5-12
receiving static files 3-2