February 13, 200718 yr I know this topic has been covered numerous times in this forum (I've read them all and tried to implement the suggestions), and I know it's covered in the CWP Guide, but I have tried everything I can think of and find and nothing seems to solve the problem. I have a page that is supposed to create new records via a form. Upon submission, it goes to the results page with no errors, but no new record is created. There are two privileges sets defined, one with full access and the Guest with Data Entry Only. Both have FMXSLT extended privileges. I have set the owner to fmweb and the group to fmsadmin, both with rw permissions (I have no way of knowing if this information is preserved when I upload it to my website). I have looked at the code over and over and don't see any errors: <?xml version="1.0" encoding="ISO-8859-1"?> <?xslt-cwp-query param="-grammar=fmresultset"?> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset" xmlns:fmq="http://www.filemaker.com/xml/query" xmlns:fmxslt="xalan://com.fmi.xslt.ExtensionFunctions" exclude-result-prefixes="xsl fmrs fmq fmxslt"> ... wsfcoachingconfirm.xsl Name: Last, First X Email X Phone X X ... Can someone please help? I'm banging my head against the wall now! Here's the URL if it'll help: http://208.67.224.101/fmi/xsl/wholesum/wsfcoaching.xsl?-db=LJMresources&-lay=resources&-token.1=retail&-token.2=0&-token.3=0&-token.4=0&-token.5=0&-view Thanks in advance for your help.
February 13, 200718 yr What happens if you add the following debugging line to your results page? What is the error code displayed?
February 14, 200718 yr Author Here's what I got. I looked up error # 102 and it says "field missing" so I double-checked that all of the field names are spelled correctly in the code and they are. I'm stumped.
February 15, 200718 yr Is there any additional field in a <?xslt-cwp-query ?> processing instruction in the error or results file?
February 16, 200718 yr Author Every page includes the following: <?xslt-cwp-query param="-grammar=fmresultset"?> I did read one of your responses to a post on this forum about problems with the "-process" parameter, so I looked it up in the CWP Guide and double-checked that I hadn't inadvertently used it. It was on two of the templates that I call from every page -- the masthead and the navigation bar -- so I corrected it and tested it before I posted my original message. It didn't solve the problem. Is there any additional information I can provide that will help debug this?
February 21, 200718 yr Author I eliminated the header and footer originally. I rebuilt the layout to no avail.
February 21, 200718 yr Can you post here all three files, search, results, and error file, packed in a zip file?
February 21, 200718 yr Author I've enclosed the requested zip file. It includes the database since there's no real data yet (I've changed the full access user name and password to admin/admin), the two xsl files in question (it continues to the results page in the event of an error) and the auxiliary templates that are called by those files. Thank you very much for checking this out for me. By the way, the database permissions reverted back to the group being the owner and the permissions for the group being read only when I downloaded the latest copy of the database from my website in preparation for sending it to you. How can I guarantee that the permissions are correct on a remote server that's not under my control? new_record_problem.zip
February 22, 200718 yr I think I have it: is not allowed to have a name attribute. So remove the name="Submit" and try again. See http://www.w3.org/TR/html4/interact/forms.html#h-17.4, especially the line reading ""
Create an account or sign in to comment