Expand my Community achievements bar.

Updating multiple fields into one hidden field

Avatar

Level 2

I have a form that I am going to be writing the data to a sql database.  My form has 16 fields.  One field will go to one column and the remaining 15 fields I want to submit as a single string to another column.  I know that I am going need to write an update code but not sure how to do this.  I know that the update script will need to be in the first line of my submit button.  Does any one have a example of how to do this?

23 Replies

Avatar

Level 2

Brad,

  Can you post the error?


  Justin

Avatar

Level 2

GeneralError: Operation failed.

XFAObject.setAttribute:1:XFA:form1[0]:#subform[0]:Button1[0]:click

This operation violates your permissions configuration.

Avatar

Level 2

Your form must be certified in order to do this.  Here is a blog entry and a bunch of comments on the topic:

    http://forms.stefcameron.com/2006/12/07/better-form-design-with-xfa-25/

  Justin Klei

  Cardinal Solutions Group