Re: cacheing problem

From: Felix Geerinckx (felix.geerinckx_at_gmail.com)
Date: 03/29/05 

Date: 29 Mar 2005 13:40:09 -0000
To: dbi-users@perl.org

On 28/03/2005, David Nicol wrote:

> I am using dbd::mysql on activestate perl 5.8. When I select a row in
> my program, change the row using the mysql administrator tool, and
> select the row again in the program, the results are not changed. I
> can get the new data by selecting a different row, then selecting the
> changed row again, then I get the new results, but running the
> same select gives a stale result.

Would you care to give some more information, and show the code you use?
What "mysql administrator tool" are you using?

I cannot reproduce your problem when I change a record with mysql.exe
in between two execute-fetch-finish cycli on the same prepared
statement. 

-- 
felix