Administrator’s Guide

4-4 FileMaker Pro 5.5 Unlimited Administrator’s Guide
For example, to generate a –findall request to display all employees
from a database, web users might click on an HREF link containing
the following FileMaker Pro CGI command:
FMPro?–db=Employees.fp5&–lay=FormView&–format=results.htm
&–findall
Or, web users might click on a submit button in an HTML form
containing the FMPro form action and the following hidden INPUT
elements:
<P><FORM ACTION=”FMPro” METHOD=”post”>
<P><INPUT TYPE=”hidden” NAME=”-db” VALUE=”Employees.fp5”>
<P><INPUT TYPE=”hidden” NAME=”-lay” VALUE=”FormView”>
<P><INPUT TYPE=”hidden” NAME=”-format” VALUE=”results.htm”>
The submit button in the form contains the –findall request name:
<P><INPUT TYPE=“submit” NAME=”-findall” VALUE=”Start Search”>
Request names
The name of a request for CDML data is determined by the name of
the CDML action tag in the request. You use CDML variable tags to
specify the parameters of a request.
For a detailed list of the CDML action and variable tags and example
syntax for using them in a FileMaker Pro CGI request, see the Tags
Index in the CDML Reference database (described in “Using the
Tags tab” on page 4-6).
Requests for adding records to a portal
You can use CDML to add records to a portal of related database
files. When you make an –edit request or a –new request that
includes data for a portal, you must specify the layout and the
relationship name for the related database.
Note You can only add one record at a time to a portal, and therefore
must make separate –new requests to add more rows to the portal.
The following is an example of a –new request for adding a record to
a portal, where “Address::” is the name of the database relationship,
and “City.0” is the related field name in the portal:
FMPro?–db=Employees.fp5&–lay=LayoutOne&FirstName=Sam&
LastName= Smith&Address::City.0=Seattle&–format=reply.htm&–new
Requests for editing multiple records in a portal
You only need to make one –edit request to edit multiple records in
a portal. You specify each row (or record) in the portal by adding a
period and a consecutive number (starting with number 1) to the end
of the related field name.
Use this request name
(CDML action tag) To generate this request
–delete Delete record
–duplicate Duplicate record
–edit Edit record
–find Find a record
–findall Find all records
–findany find a random record
–new New record
–dbopen Open database
–dbclose Close database
–view Display format file
Note The -script variable tag (request parameter) is
not designed to work with -view requests.
Use this request name
(CDML action tag) To generate this request