Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

problem adding new records

Featured Replies

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.

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


What is the error code displayed?

  • 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.

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

  • 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?

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

  • Author

I eliminated the header and footer originally.

I rebuilt the layout to no avail.

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

  • 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

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

""

  • Author

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

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.