problem adding new records

[Leslie MacNeill]

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.

[Martin Brändle]

What happens if you add the following debugging line to your results page?

What is the error code displayed?

[Leslie MacNeill]

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.

[Martin Brändle]

Is there any additional field in a <?xslt-cwp-query ?> processing instruction in the error or results file?

[Leslie MacNeill]

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?

[Martin Brändle]

Rebuild the layout? Maybe one field overlaps with the header or footer?

[Leslie MacNeill]

I eliminated the header and footer originally.

I rebuilt the layout to no avail.

[Martin Brändle]

Can you post here all three files, search, results, and error file, packed in a zip file?

[Leslie MacNeill]

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

[Martin Brändle]

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

""

[Leslie MacNeill]

That's it! You're amazing. Thanks ever so much.