Variables lost during multiple update

Not sure what is happening here. I am using the Update Multiple Records Server Behavior. After Updating the database I am instructing it to carry a single variable to another page. This doesn't seem to be working or should I say sometimes it does and sometimes it doesn't. This is extremely frustrating when testing the pages work correctly. I even tick the "Pass original querystring" box, but to no avail. Everything else works OK, the database is updated, the following page appears as expected, but the variable is not being displayed as expected. I am using DataAssist 2.0.7.

I have attached the 2 files in question for your attention.


Thanks again


John

instead of using the recordset variable in the redirect:

$WA_redirectURL = "confirmshippinglist.php?shiptoid=".$row_Recordsetfindshipsupplier['shiptoid']  ."";

why not use the shipto id form element which is used to filter the recordset:

$WA_redirectURL = "confirmshippinglist.php?shiptoid=".isset($_POST['shiptoid'])?$_POST['shiptoid']:""  ."";

if it's not working that way, you have narrowed it down to the options in the select list.

view source of the page in the browser to see the code being generated for the list to troubleshoot further.

Hi Jason,

Thanks for that unfortunately what you suggested didn't work. Although that is the practice I use in most cases. I found a work-around in the end by storing the variable in its own mysql table and then retrieving it again on the following page. Not the best way to do things I know, but it works now.

Thanks again

John

P.s. Its great to know you guys are there when we need a bit of help

cheers