Skip to main content
R
Richard_Mossman
Participating Frequently
December 11, 2009
Question

Client Variables not being updated

  • December 11, 2009
  • 1 reply
  • 359 views

I have three working environments: a Development site on my PC (Windows 2007), a Testing site (Windows Server 2003), and a Production site (Windows Server 2003). All of them are running MySQL 5.1 and CF 7. The web site is an database-driven support site for some engineers. It is not internet facing.

I have two web pages that use client variables stored in a database to provide persistency between sessions for the clients. The status of five checkboxes is stored.

Both pages work fine on the Dev and Prod servers but do not retain the information on the Test server. In every other way, the application works correct for all the application data. The pages are the same because I am simply copying the page from server to server. The site was working correctly on the Test server up until about nine months ago. It's been that long since any pages were upgraded and needed testing.

CF Admin says the Data Source is OK. The Client Variable admin section does not complain when I select the datasource for storage. I've got the ODBC Admin settings set up the same way in Windows.

I am using CFPARAM to preset the five checkboxes as a means to have some selection done when an engineer logs in for the first time. But, after that, the status of the checkboxes is queried and pulled from the DB. At least that is the way it's supposed to happen.

As I said, on the Dev and Prod servers you can select 1 to 5 of the checkboxes, change pages or log out and, when you return to the page, the same boxes will be checked. But, on the Test server, when you select or deselect a box and hit the "Select" button, they always revert back to the default. It's as if the CPARAM is always read and the database is not.

Any ideas how to proceed? Might the permissions or ownership be an issue when I drag and drop the files from one server to the other?

Actually, that last question doesn't really appear to be the problem because dragging from the Dev server to the Prod server does not cause a problem.

Thank for any help you can give me.

Richard

    This topic has been closed for replies.

    1 reply

    R
    Richard_MossmanAuthor
    Participating Frequently
    December 15, 2009

    OK, maybe a little bit more information would help.

    I have now found out that the pages can write information to the client variables db but do not read from the db.

    If I change the default in the cfparam and refresh the page, the value changes in the db (so the value is being written). But, if I use GetClientVariablesList(), I get nothing back. On my Dev or Prod servers, I do get the list of variables that are stored in the db.

    Hopefully, this will help someone help me.

    Thank you.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices