Administrator’s Guide

Contents v
Example of XML data in the FMPXMLLAYOUT
grammar
5-7
About UTF-8 encoded data
5-8
Generating FileMaker Pro CGI requests for an XML document
5-8
Request and parameter names
5-8
Requests for adding records to a portal
5-9
Requests for editing multiple records in a portal
5-9
Using style sheets with your XML document
5-10
Comparing CSS, XSLT, and JavaScript
5-11
Cascading style sheets (CSS) example
5-13
Extensible Stylesheet Language–Transformations
(XSLT) example
5-14
JavaScript scripting language example
5-16
Looking at the XML Inventory example
5-17
Chapter 6
Using Java and JDBC to deliver your data
About the JDBC examples
6-1
About JDBC
6-1
Using the FileMaker JDBC Driver
6-2
About the FileMaker JDBC Driver
6-2
Using a JDBC URL to connect to your database
6-2
Specifying driver properties in the URL subname
6-3
SQL supported by the FileMaker JDBC Driver
6-4
Using DbOpen and DbClose pseudo procedures
6-5
Using the RecordID pseudo column
6-6
Using the ModID pseudo column
6-6
SQL statement examples
6-6
Using a character escape
6-7
FileMaker data type mapping to JDBC SQL and Java
data types
6-7
FileMaker Pro support for Unicode characters 6-7
About the FileMaker JDBC Driver interfaces and extensions 6-7
Example 1: Looking at the FileMaker Pro Explorer application 6-8
Setup requirements 6-8
Install the example and the FileMaker JDBC Driver 6-9
Open and share your databases via the Web 6-9
Run the FileMaker Pro Explorer application 6-9
View the source code of the example 6-10
Example 2: Creating the JBuilder Inventory application 6-11
Install the example and FileMaker JDBC Driver 6-11
Set up JBuilder to use the FileMaker JDBC Driver 6-11
Open and share the Inventory.fp5 database 6-11
Start a new JBuilder project 6-11
Create the data module 6-12
Design the data module 6-12
Test the data module 6-13
Generate the application 6-13
Example 3: Creating the Visual Cafe Inventory application 6-14
Install the example and the FileMaker JDBC Driver 6-15
Set up Visual Cafe to use the FileMaker JDBC Driver 6-15
Open and share the inventory_db database 6-15
Create a new Visual Cafe project 6-15
Using the FileMaker Java classes 6-17
About the FileMaker Java Class Library 6-17
Looking at the Java applet examples 6-18
Appendix A
Valid names used in CGI requests for FileMaker XML data
Generating a –find, –findall, or –findany request A-1
Examples of –find, –findall, and –findany requests A-1
Generating a –view request A-2
Examples of –view requests A-2
Generating a –new request A-2
Examples of –new requests A-2
Generating an –edit request A-3
Examples of –edit requests A-3
Generating a –delete request A-3