Requery after SESSION change
I am implementing multi-currency on a eCart.
Currency Sessions default to USD and 1, 1 being the exchange rate.
To change to CAD, user clicks radio button and submits.
Session values are updated to CAD and the Exchange Rate from a DB Query using the selected currency as a variable. (In this case, CAD).
This works perfectly on my testing server (Windows 2003 Server, IIS6)
On my production server, also Windows 2003 Server, IIS6, it changes the currency denomination, but it does not change the multiplier.
It will change the multiplier if you choose the currency again and submit again.
Ignoring the fact that it works in testing, I figured that the problem is that the Query is not running again becuase the page is not reloading so I slipped in an intermediary page.
The form now posts to another page, on which the Session Values are updated and then I have a blank form which submits on load and posts to HTTP_Referer, which is the last page viewed.
Again, works seamlessly on my testing server, but on the production server I have to submit twice to get the correct multiplier.
This is not an eCart problem, but if anyone can shed some light on what I've missed, or a better approach, I would appreciate it.