HttpUtils2 not showing updated data

In order to debug this issue, I recommend you to make the same requests from the browser and check the results. Are they different than the results you get on the device?

Ok I tried requesting from the browser and I get the same result as that on the device. Is my server caching the query or something? How do I check this?

OK I think it's my server caching the query. I'll try disabling caching for this particular database.

I thought I've solved the issue but now direct query via the browser returns the latest result but not from the device.

I probably have to wait for sometime before getting the latest results from the device.

I've disabled query caching on the server by issuing this command


I've also specified SQL_NO_CACHE in the php code where I do not want the SELECT statement to be cached (all of them)

IN my sql my.cnf I have set the following


I know the above has more to do with the server but why the device is not returning the latest result while requests from browser do?

This weird. Now the device is getting the updated data. Hope this is it..

A popular workaround to avoid browser caching of XHR requests is to add a bogus parameter to the request.
The javascript Date object is useful as it'll always return a unique bogus parameter.
A typical request that will avoid browser caching is:


That javascript will ensure that every requestUrl contains a unique bogus_param value and avoid browser caching.
You could do something very similar in your B4A code.

From the code that you posted it looks like your B4A is querying a PHP script, so another solution is to set a header in the output of the PHP script to disable caching:


Note that the PHP header statement must be executed before any text or other output is output by the script - put that header statement at the very start of your PHP script otherwise you'll get an error such as 'headers already sent'.

Disabling caching in the SQL server is a bad idea - it's more likely that the request is being cached elsewhere and your SQL server is not even being re-queried.
Even so disabling SQL server caching could cause major loss of performance.

Martin.

Thanks Martin!

I'll try to implement your suggestions in the code.

Thanks Martin!

I'll try to implement your suggestions in the code.