I am using DynamicForms for a registration page.

1. User fills in information and selects which event they would like to register for on Form #1.  All of the fields on Form #1 are stored as session variables as well as entered into a database table along with the UniqueCompletionID.

2. When the user clicks 'Submit' on Form #1, they are redirected to an off-site payment handler. The payment handler is restrictive on what I can pass via QueryString, so I have Form #1 sending the UniqueCompletionID to a Session variable.

3. When the user completes payment on the off-site handler, they are redirected to another off-site PHP page to get away from the 'Security' that the payment handler has imposed.  (For some reason, I can't redirect from the payment handler directly to a DNN page, so I have a simple PHP page running on my local server to do the redirecting back to DNN.  Yes, I know it's convoluted, but that part works.)

4. When the user is redirected from the PHP page, they are sent to another DynamicForms form (Form #2) that auto-populates fields from the session variables stored from Form #1.  I am using this page as a "Make sure your info is correct" as well as a way to update the user's record in the database with information returned from the payment handler.  This is where the problem is occuring.

Form #2 loads correctly with all of the relevant information auto-populated from the session variables - including the UniqueCompletionID from Form #1.  When the user clicks 'Submit' on Form #2, I would like to update the database fields based on the record associated with the UniqueCompletionID from Form #1. -> UPDATE MyTable SET blah blah WHERE UniqueCompletionID = $(UniqueCompletionID)

I think where it's getting hosed up is that, when the user clicks Submit on Form #2, a new UniqueCompletionID is generated which is being used in my update query instead of the label field located on the form.  A way to get around this would be to rename the label field on the form, but I don't know of a way to rename the field and still have it pull the UniqueCompletionID from the session variable.

I have also tried doing an initial SQL Bind on Form #2 where I retrieve the RecordID (auto-increment field in the database) associated with the UniqueCompletionID of Form #1. -> SELECT RegID FROM MyTable WHERE UniqueCompletionID = $(UniqueCompletionID).  This doesn't work either.

My hands are tied as far as using a querystring due to the off-site payment handler, so I have to do everything through session variables.

Any ideas on how to get this to work?

Sorry for the book-length explanation, but I assume more details are better than fewer details.

Thanks in advance,

CJ

Thanks for the reply!  I knew there had to be a way to do this, just was missing one piece of it.

Is this type of code that will do what I want:

document.getElementById('OriginalUCI').value="<% =Session("UniqueCompletionID") %>";

I have that in the 'Initial Javascript' field in Module Settings for DF 2.

Thanks,

Chris

Well, that isn't working for me for some reason.  The update query still wouldn't run, so I tried setting the OrigUniqueCompID field to be a label, and nothing is coming through as a value for the field.

Any ideas?

Wow.. I have no clue what I did differently.

I tried all combinations of having UniqueCompletionID and OrigCompID on the page with 'copying' taking places in different areas but never got it to work.

I finally went back and deleted all instances of UniqueCompletionID and OrigUniqueCompID in DF2 and recreated them and now it works.

Thanks again for the time and help!!!!!

CJ