Hi Bob --
> -----Ursprüngliche Nachricht-----
> Von: Bob McGowan [mailto:bob_mcgowan [at] symantec.com]
> Gesendet: Samstag, 14. November 2009 01:04
> I'm having trouble with retrieving data from mySQL, where the
> update or create was done by another application connection
> and happened while my Perl DBI/DBD connection was active.
>
> If I disconnect/reconnect to the server, I can see the changes.
>
> Is this expected behavior? Or is there some parameter that
> I'm missing? Neither the standard 'mysql' client nor the
> 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.
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/perl?unsub=3Dgcdmp-msql-mysql-modules [at] m.gmane.org
