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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
