Skip to Content
avatar image
Former Member

Query Caching not working after migrating to ver12 for DateTime columns

I have an applet that charts production numbers over time. The query template is cached for 1 min. When the applet uses fresh data the applet charts properly and the underlying data has accurate values in the date/time columns. But if the applet charts from cached data the chartu2019s x-axis (date/time) shows an incorrect date range and the underlying data has inaccurate values in the date/time columns but other columns values are accurate.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 16, 2008 at 04:19 AM

    Any JavaScript getting in the way?

    Add the following line to the applet and then replicate your issue taking a look at the differing http requests in the java console. Notice any differences in the requests?

    <PARAM NAME="Trace" VALUE="true">

    Regards,

    Jeremy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Jeremy Good

      No timestamping. They are not in the same timezone - The database server is Eastern (GMT-05:00) and the webserver is Central time(GMT-06:00).