I can't figure out what I'm doing wrong here.  I've got a 3 page form.  I get registration on page one, submit to the database and go to a guest list page where I need to pull company name and contact for the header.  I've set up to pass the unique identifier, which duly goes to the database.  I can add a text field to page 2, give the short name as 'UniqueCompletionID', populate the value from the session  and have the UCID show up correctly in that field.  

But when I use the same name - i.e. $(UniqueCompletionID) in my data binding and turn on debugging, all I get is zeros.  The databinding works fine if I hard code the UCID in but nothing if I use the token. I've checked the demos - especially #31 and I've set up everything there exactly as it is on 31.  I've also found some forum posts that are doing exactly what I'm doing.

I'm really stumped and am facing a looming deadline so would appreciate any suggestions you could offer on what I'm doing wrong.

It's about 4 hours later and I'm still no further to resolving this that before. If I hard code the UCID, databinding works, otherwise all I get is:

select * from tbl_RGRW_Dallas_2010 where UniqueCompletionID =
'00000000-0000-0000-0000-000000000000'

 I was hoping that putting the $(DSParam1) = $(UniqueCompletionID) per tutorial 31 would help but that isn't doing anything either. If I could get the UCID to the querystring, then I would be good but I can't figure out how to get it there.

 It looks like my only other option would be to put everything into session variables but I have over 100 fields over the two pages and the idea of doing that twice (1/2 on page 1, 1/2 on page 2 and all on page 3) is not something I want to do.

 I sure need some help here - going to go back to demo 31 and see if there's anything I've missed. If I can't get this resolved soon, I'm going to have to abandon DF and build something in VS or Zend.

Hi there...

Hmm... Try these tips (not necessarily need them all but just in case good suggestions)
1. Make your field on page 2 a hidden field instead of a textbox
2. Make the sort order pretty high up in the list (not typical for SQL Binding but would be important for SQL Defaults)
3. Do name your short field name DSParam1
4. Are you passing the field value via a session variable? IF so I think you need to name it DSSession1. I guess to be safe I would try and make the field both DSParam1 and DSSession1
5. Obviously choose to have the field brought in via a session variable or querystring variable depending on what you are doing with it.

There are a few unknowns that I am not sure about in your implementation? Are you using your own GUID/Unique Completion ID that is brought in via a session variable or are you using ours build in $(UniqueCompletionID)?


Just referencing Demo 31 right now:
1.It does look like we are passing the UCID via a session variable (the setting is enabled in module configuration, general settings).

2. On Page 2 it looks like we have two hidden fields, DSParam1 and UniqueCompletionID. DSPAram1 is set to retrieve from querystring and UniqueCompletionID is set to retrieve from a session variable.

3. We do have this under Initial JavaScript <<<--- Maybe this is the missing link? I think this is needed to make it a consistent back and forth example. $(DSParam1) = $(UniqueCompletionID);


Thanks,

Chad




-Chad

I should have mentioned that, for the most part, I've had the 2nd page fields hidden - I initially turn them on to make sure they're getting data and then I'll make the fields hidden. DSParam1 and UniqueCompletionID are the first and second fields on the page and the name is both question and short field name for my the fields, per Demo 31 and a post I saw about someone doing exactly what I'm trying to do.

I'm using the id generated by checking the checkbox in the module configuration - which would be $(UniqueCompletionID). The value is set to be passed to and from session for the UCID and to and from via querystring for DSParam1. I've put the $(DSParam1) = $(UniqueQuerystringID) in the initial javascript window in the module configuration.

The weird thing is that the value is coming through - if I change the UCID field to a text I see it. It get submitted to the database. I just created a dynamic e-mail with a link that the UCID attached itself to. Yet when I debug the SQL binding I'm not seeing the ID, just a bunch of zeros. It doesn't happen if I change the query to use DSParam1 - only when I try to use the UCID. As I said in a previous post, I'm beginning to think that our installation is faulty in some way as to cause these sort of oddities.

That said, I'm going to abandon the 3 page idea and stick to a single page. Doing so eliminates the need for a review page and edit links and such. Plus, one of the requirements has always been for the registrants to manage their own guest lists. Since the e-mail works fine, I can just use that for page 2 and I know that DSParam1 will work fine for binding.

I appreciate the suggestions but I think I've covered every one of them. I even tried to build a very short version of Demo 31, followed all the screens, all the instructions and never once got the UCID to transfer to DSParam1. I could go from page to page but never with that ID in tow.