Monthly Archives: October 2013

Preventing caching in php

Sometimes when you have php programs that render data from databases, after updating the data from a webpage the server will cache the results from before the update effectively showing wrong data. We found this to be especially problematic with … Continue reading

Posted in Uncategorized | Leave a comment

MYSQL DEFINER

There are issues when you use mysqldump to dump a database and it contains DEFINER=root@x.x.x.x type references. THese are typically in the create procedures or trigger statements. The dump files contain the actual machine name even though the source .sql … Continue reading

Posted in Uncategorized | Leave a comment

Stop IE from prompting for passwords on download of excel

We finally came up with a solution for the IE prompts for PIN multiple times and passwrods.   The solution turned out to be adding a Content Header  to treat the xls files as “Attachements”  — this way IE doesn’t … Continue reading

Posted in Uncategorized | Leave a comment