Digital Workshop

Hello
I am working on a very simple publication that sends two variables via php to MySql database. Sending the variables works perfectly, and getting the values backs work as well.

Then I change the values of the variables (in text input boxes) and send them again. Correct in the database, and correct if I use web browser to view them from tha database.

But using the Post Web data action returns the old value of the variables until I turn the publication off and restart it. Then it shows the new (correct) content.

I have seen this problem before. I was working on a big publication, using ASP and ACCESS. There was a login page and if the user typed wrong user name or password, these wrong values were "stuck" until the publication was turned of and on again.

Any idea??

Jonas --

Sounds complex. What would happen if you RESET each Variable in question before you have OPUS read from your database? If the response comes back "blank" (reset) then OPUS isn't reading the DB the second time. You know OPUS is writing properly because using a web browser produces the correct information.

Also check which DB you are reading. Maybe OPUS is creating the info in a TEMP directory instead of where you think it's going.

Just some "outside the box" ideas. Good luck!

Thank you Fred

I have tried to Reset All Variables before running Post Web Data - does not help.

I am trying to find out if your suggestion of Opus reading some Temp file instead of reading from the database - sounds good, but still no luck.

I attach files with screen shots of my problem, hoping that someone can tell me what is wrong.

Regards
Jonas

We had a simular problem a few month's ago, I think it will be solved in a next update of Opus.
In the mean time is it a possibility to do the folowing? Write the new data to a text file in Temp files and restart the Pub (launch action under the action tab) and read the text file when launching the Pub (OnShow / ReadFile action)

Hopefully it helps

Ps I thought of something else you can try use the script action GotoCurrentPage();
Normally this would reset the page variables and set the page to its initial state.

Thank you Jim

I will try some workaround my problem. But I am still wondering where the publication keeps the old value or where it reads it. I tried to run the publication once and then run "Search" on the value on my computer - no luck.

Jonas