AW: select fails to find updates of from other connections

Hi Bob --

> -----Urspr=FCngliche Nachricht-----
> Von: Bob McGowan [mailto:[email protected]]=20
> Gesendet: Samstag, 14. November 2009 01:04
> I'm having trouble with retrieving data from mySQL, where the=20
> update or create was done by another application connection=20
> and happened while my Perl DBI/DBD connection was active.
>=20
> If I disconnect/reconnect to the server, I can see the changes.
>=20
> Is this expected behavior?  Or is there some parameter that=20
> I'm missing?  Neither the standard 'mysql' client nor the=20
> Bugzilla GUI seem to have this problem.
I'm not sure whether this answers your question, since you just said you =
have trouble (but not, which trouble): have you tried to fiddle with the =
connection parameter mysql_use_result (as per the DBD::mysql docs)? If =
set to false (the default), the result set for some select that you do =
may just be buffered locally.=20
Alternatively, are you connecting to a transactional table, and may the =
transaction still be in progress? Are you doing your select in a loop =
for contunuous updating, or how do you control whether the external =
table update is somewhere between your selects? Given the current lot of =
information, it is hard to tell.

\Gisbert

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]