Error condition FileMaker 11 error code FileMaker 12 error code
Invalid max or skip values. Example:
-db=basicfinds&-lay=layoutone&-max=-1&-findall
5 (Command is invalid) 960 (Parameter is invalid)
Sort order number is missing or invalid Example:
-db=basicsorts&-lay=layoutone
&-sortfield.=textfield&-findall
5 (Command is invalid) 404 (Sort order is invalid)
Invalid related table specified. Example: -db=relfinds
&-lay=layoutone
&aliasdoesntexist::relatedtextfield=sometext&-find
102 (Field is missing) 106 (Table is missing)
An empty sort field in a query. Example:
-db=basicsorts&-lay=layoutone&-sortfield.1=
&-findall
Ignored. No error code. 102 (Field is missing)
–find query submitted without any fields. Example:
-db=basicedits&-lay=layoutone&-find
No error. FileMaker 11 returns all records.
400 (Find criteria are empty)
–find query submitted with only global fields. Example:
-db=basicfinds&-lay=layoutone
&globaltextfield.global=sales&-find
No error. FileMaker 11 returns all records.
400 (Find criteria are empty)
Index
A
access log files for web server, described 40 access privileges 14
accounts and privileges
enabling for Custom Web Publishing 13 Guest account 14
scripts 17
Admin Console 14, 22 application log 40
ASCII characters, in XML documents 34 authentication of web users 13
auto-enter attribute 27 available scripts 50
B
Basic Authentication for web users 13
C
Change Password script 14
commands for queries. See query strings comparison operators for fields 53 compound find query command 49 compound find query parameter 55 container fields
how web users access data 17 publishing contents of 15
URL syntax for accessing in XML solutions 23 with externally stored data 16
with referenced files 15 creating a new record 50 Custom Web Publishing
access to solutions by web users 13 definition 7
enabling in database 13
enabling in Web Publishing Engine 14 extended privilege for 13
Guest account 14 new features in 10 overview 7
requirements for 11
restricting IP address access in web server 14 scripts 18
using a static IP address 12 using scripts 17
with PHP 9 with XML 9, 20
Custom Web Publishing Engine (CWPE) 21
D
database error codes 25 database layouts available 50
databases, protecting when published 14
<datasource> element 26 –db query parameter 51 –dbnames query command 48 –delete query command 48 –delete.related query parameter 47 deleted for FileMaker 12
–encoding query parameter 70 –grammar query parameter 70 –process query command 70 –stylehref query parametet 70 –styletype query parameter 70 –token query parameter 70 deleting portal records 47
document type definitions (DTDs) 25, 29 documentation 6
documentation information 6, 12 –dup query command 48
E
–edit query command 48 electronic documentation 6 elements
database error code 25
in FMPXMLLAYOUT grammar 31 in FMPXMLRESULT grammar 29 in fmresultset grammar 26
enabling Custom Web Publishing in database 13 encoding
URLs 24 XML data 25, 34 –encoding query parameter
deleted for FileMaker 12 70
<error code> and <ERRORCODE> elements 62 errors
about error codes 62
database error code elements 25 database error code numbers 62 log files for web server 40 examples of
generated FMPXMLLAYOUT grammar 33 generated FMPXMLRESULT grammar 30 generated fmresultset grammar 28 export XML data 20
extended privilege for Custom Web Publishing 13 Extensible Markup Language (XML). See XML
F
field name query parameter (non-container) 52 field names, fully qualified syntax 45
–field query parameter (container) 52
<field-definition> element 27 –fieldname.op query parameter 53
73
FileMaker API for PHP 9 definition 9
FileMaker Pro, contrast with Web Publishing Engine 20 FileMaker Server
documentation 6 installing 6
FileMaker Server Admin Console 14, 22 filtering portal field records 57
–find query command 49 –findall query command 49 –findany query command 49 –findquery query command 49
FMPXMLLAYOUT grammar 20, 31–33 compared to other grammars 24 FMPXMLRESULT grammar 20, 29–30
compared to other grammars 24 fmresultset grammar 20, 26–28
compared to other grammars 24
fmxml keyword for enabling XML publishing 13, 22 four-digit-year attribute 27
fully qualified field name, syntax of 45
G
global attribute 27 global fields
syntax of 47
–grammar query parameter deleted for FileMaker 12 70 grammars for XML, described 24 Guest account
disabling 14 enabling 14
with Custom Web Publishing 14
H
HTML
forms for XML requests 22
I
import XML data 20 installation documentation 6 Instant Web Publishing
definition 7 documentation 6
J
JDBC documentation 6
K
keywords for enabling Custom Web Publishing 13, 22
L
–lay query parameter 36, 54
–lay.response query parameter 36, 54
–layoutnames query command 50 layouts, switching for an XML response 36 limiting portal field records 57
log files 39 described 40 Tomcat 42
web server access 40
web_server_module_log.txt 42 –lop query parameter 54
M
–max query parameter 54 max-characters attribute 27 max-repeat attribute 27
<metadata> element 27
MIME (Multipurpose Internet Mail Extensions) types 15 –modid query parameter 55
monitoring websites 40
N
name attribute 27 namespaces for
XML 25
new features in Custom Web Publishing 10 –new query command 50
not-empty attribute 27 numbers for
database error codes 62 numeric-only attribute 27
O
ODBC documentation 6 online documentation 6 operators, comparison 53
order of XML request processing 36 overview
Custom Web Publishing 7 overview of steps for
XML data access 22
P
parameters for queries. See query strings passwords
Basic Authentication for web users 13 Change Password script 14
defining for Custom Web Publishing 13 no login password 14
PDFs 6 PHP
advantages 9
PHP API for Custom Web Publishing 9 portal field queries 57
74
portals
adding records 46 deleting records 47 editing records 46 initial row 57 layout 57
number of records 57 sorting records 57
privilege set, assigning for Custom Web Publishing 13 –process query command
deleted for FileMaker 12 70
processing a Web Publishing Engine request 8 progressive download 15, 16
protecting published databases 14 publishing on the web
connecting to Internet or intranet 11 container field objects 15
database error codes 62 protecting databases 14 QuickTime movies 15 requirements for 11 using XML 22
Q
–query query parameter 55 query strings 34, 43
adding records to portals 46 commands and parameters 34, 43 editing records in portals 46
fully qualified field name, syntax of 45 global fields, syntax of 47
guidelines for 43
requesting XML data 34, 43 querying portal fields 47
QuickTime movies, publishing on the web 15
R
–recid query parameter 56
<relatedset-definition> element 27 –relatedsets.filter query parameter 57 –relatedsets.max query parameter 57 Re-Login script 14
requests for XML data 22
requirements for Custom Web Publishing 11 result attribute 27
<resultset> element 27
retrieving available script names 50 retrieving layout information 51 retrieving layout names 50
S
SAT
see FileMaker Server Admin Console 14 –script query parameter 58
–script.param query parameter 58 –script.prefind query parameter 58
–script.prefind.param query parameter 59 –script.presort query parameter 59 –script.presort.param query parameter 59 –scriptnames query command 50 scripts
accounts and privileges 17 Change Password 14 for XML requests 22
in Custom Web Publishing 17 Re-Login 14
tips and considerations 17 triggers 19
security
accounts and passwords 14 documentation 8
guidelines for protecting published databases 14 restricting access from IP addresses 14
–skip query parameter 60 –sortfield query parameter 60 sorting portal field records 57 –sortorder query parameter 61
specifying layout when requesting XML data 36 SSL (Secure Sockets Layer) encryption 14 static publishing, definition 7
–stylehref query parameter deleted for FileMaker 12 70 stylesheets
testing 39
–styletype query parameter deleted for FileMaker 12 70 summary of steps for
XML data access 22
switching layout for XML response 36 switching layouts for an XML response 36
T
testing
websites 39 XML output 39 text encoding
generated XML data 25 URLs 24
time-of-day attribute 27 –token query parameter
deleted for FileMaker 12 70 Tomcat
using log files 42 triggers 19
troubleshooting
Custom Web Publishing websites 39 XML document access 37
type attribute 27
75
U
Unicode characters 34 URL syntax for
container objects in XML solutions 23 XML requests 22
URL text encoding 24 user names
Basic Authentication for web users 13 defining for Custom Web Publishing 13 UTF-8 (Unicode Transformation 8 Bit)
format 24, 34
V
–view query command 51
W
web browsers
role in XML requests 21
Web folder, copying container field objects 15 Web Publishing Core
illustrated 21 Web Publishing Engine
Admin Console 22 application log 40 benefits of 10 described 8
generated error codes 62 generating XML data 21 generating XML documents 22 request processing 8
web server log files 40
MIME type support 15 role in XML requests 21 web users
accessing protected databases 13
requirements for accessing Custom Web Publishing solutions 11
using container field data 17 web_server_module_log.txt log file 42 websites
creating with Web Publishing Engine 10 FileMaker support pages 6
monitoring 40 enabling in database 13
encoded using UTF-8 format 25, 34 FMPXMLLAYOUT grammar 31 FMPXMLRESULT grammar 29 fmresultset grammar 26
<datasource> element 26
<field-definition> element 27
<metadata> element 27
<relatedset-definition> element 27
<resultset> element 27
generating XML data from request 21 grammars, described 24
namespaces for 25
order of request processing 36 parsers 22, 34
query strings 34, 43 requesting data 22
summary of steps for accessing XML data 22 troubleshooting access to XML documents 37 URL text encoding 24
XML 1.0 specification 20 XML advantages 9
XML custom web publishing 9 XML request
specifying layout 36 XML response
switching layout 36
<xsl:stylesheet> element 39
<xsl:template> element 39