odd query behaviour

[Mike Dickerson]

Please forgive me if this has been addressed (please refer me to the 
docs and I will rtfm) or if I'm just being a bobo.

I am running a 3.23.39 client/server on FreeBSD 4.6S system. I am 
getting a very peculiar query behavior.

I have a cgi program using the Perl DBI. The programin in question is a 
simple report which does a few queries (with one loop). When I hit 
"refresh" on my browser, it will simply "redo" the queries and produce 
the desired report. Here's the problem: The report is not correct (yes, 
baahhh, I know, please read on). Based upon hitting the "refresh" button 
on my browser, I should be getting the same result every time (and I do, 
almost). Because I know that the result of the queries is not correct, I 
pop onto the server and do the *exact* same query from the command line 
(I copied and pasted the query from my script). Wahoo, I get the correct 
result via the command line. I then hit the refresh button on the 
browser and that part of the query shows correctly now. I have done this 
several times (on the same web page with the same queries, just going to 
the command line to verify an individual query in my loop, hitting the 
refresh button, and having the query result display correctly). I have 
also verified the code section to make sure it is making the query (in 
the loop) with the correct variables (which I have verified to work 
properly on the command line). It seems like there is some type of 
cache/noncache issue but nothing really makes sense with this (to me ;). 
This program had been producing this report properly for some time and 
had not been changd. The only real difference is the amount of data 
queried, but even that doesn't seem so large as to cause a problem 
(we're only talking query results < a couple hundred). I am stumped.

Any clues, suggestions would be greatly appreciated.


TIA,

mike