I'm trying to get a single-script Web application that apparently worked fine under perl version 5.8.8 but not under version 5.8.9 working again. The application runs under IIS.

The application allows the user to perform a search against multiple schemas in an Oracle database and then presents the search results. While I'm able to perform searches without problems at the start of the day, as time goes on, I start get results for previous searches returned back to me.

The original developer's approach to handling presentation was to use his own version of template files, which he proceeds to read into a variable and then performs a number of substitutions of 'tags' within the string contents with other variable values. The updated string is then returned by the script.

Complicating things further is the use of a module which uses PerlEx::DBI. But I've temporarily modified the script to not use that module for database access. Instead, the script uses DBI directly.

Any ideas as to how to resolve this problem of getting previous search results returned would be greatly appreciated.

In reply to Search results being cached? by aroc725

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.