Administrator’s Guide

Appendix A
Valid names used in CGI requests for FileMaker XML data
This appendix describes the valid names of requests and their
parameters you can use in a CGI (Common Gateway Interface)
command when requesting FileMaker Pro data in XML format.
Included are HREF link and HTML form examples of each request.
For scripting examples of each request, see the JavaScript library,
FMP.js, in the XML Examples folder (on the FMWSC and Tools CD).
The CGI command requesting FileMaker Pro data in XML format
always begins with the action as
FMPro? and the format file as either
–dso_xml, –dso_xml_dtd, –fmp_xml, or –fmp_xml_dtd.
The following is a list of the request names and parameters:
Note The name of a database field can also be used in a CGI
command. It is not a parameter or a request name, and therefore is
not preceded by a hyphen (–).
Generating a –find, –findall, or –findany
request
Name/Value Type: Find Record(s) Request
What it does: Submits a search request using defined criteria.
A web user must have browsing access privileges with the database
in order to execute these requests.
Required parameters: –db, –format
Optional parameters: –lay, –recid, –lop, –op, –max, –skip,
–sortorder, –sortfield, –script, –script.prefind, –script.presort, field
name, –styletype, –stylehref
Examples of –find, –findall, and –findany requests
To find a record using a hypertext link:
<a href="FMPro?–db=employees.fp5&–format=–fmp_xml
&Country=USA&–max=1&–find">Find first USA record</a>
To find all records in the database using a hypertext link:
<a href="FMPro?–db=employees.fp5&–format=–fmp_xml &
–findall">Find all records</a>
To find any record using a hypertext link:
<a href="FMPro?–db=employees.fp5&–format=–fmp_xml &
–findany">Find a random record for today’s daily quote</a>
To find some records using a form action:
<form action="FMPro" method="post">
<input type="hidden" name="–db" value="employees.fp5">
Request names Parameter names
–find
–findall
–findany
–view
–new
–edit
–delete
–dbnames
–layoutnames
–scriptnames
–dbopen
–dbclose
–db
–lay
–format
–recid
–modid
–lop, –op
–max
–skip
–sortorder, –sortfield
–script, –script.prefind, –script.presort
–styletype, –stylehref
–password