3 Replies Latest reply on Oct 28, 2009 6:58 AM by TSGal

    XSLT error 102 on -edit where fields contain "." in field name

    JoeB

      Summary

      XSLT error 102 on -edit where fields contain "." in field name

      Description of the issue

      FileMaker Product(s) involved:FileMaker Pro 9.0v3, FileMaker Server v10.0.1.64, FileMaker Database Filename "Contacts.fp7"  Operating System(s) involved:Microsoft Windows Server 2003 R2 Enterprise Edition SP2  Detailed description of the issue:I have a contact.fp7 database hosted by FileMaker Server 10, also running Web Publishing Engine. Whenever an -edit is performed on a xsl form that contains inputs for a field that has a "." in the field name, for a given layout, the error message "An error occurred: 102" is received. xsl input example:  If the input with "." in the fieldname is removed, the -edit works and the data is saved. The field names are within the specifications outlined in the  fms10_cwp_wsxl_en.pdf document, under the section "Guidelines for using query commands and parameters": Field names can contain periods, with the following exceptions:* The period cannot be followed by a number. For example, myfield.9 is an invalid field name.* The period cannot be followed by the text string op (the two letters “op”). For example, myfield.op is an invalid field name.* The period cannot be followed by the text string global (the word “global”). For example, myfield.global is an invalid field name.Field names containing any of these exceptions cannot be accessed via XML or XSLT using an HTTP query. These contructs are reserved for record IDs, as described in the section, “About the syntax for a fully qualified field name,” below.Exact steps to reproduce the issue:1. Create a database that conforms to the xslt guidelines with access for the Guest account to xslt, with a simple contact table, field names including: ContactID (Indexed, Auto-enter Serial, Required Value, Unique), FirstName, zi.ENTRY_First.t, LastName, zi.ENTRY_Last.t 2. Create a layout for the contact table named "contact" and create a few records. 3. Use FileMaker XSLT Site Assistant to create xsl files. 4. Try to edit a record. An error occurrs. 5. Comment out the inputs for zi.ENTRY_First.t and zi.ENTRY_Last.t 6. Try to edit a record. Record saves without issue.  Expected Result:Record should save without issue.Actual Result:Error occurrs. Exact text of any error message(s) that appeared:An error occurred: 102 Any additional configuration information/troubleshooting that is relevant to the issue:N/A Any workarounds that you have found:None