MySQL server has gone away?

2006-11-09 Thread rami doqa
Hello, can anybody tell me why this Mysql error happens in some times and not all of the times: DBD::mysql::db selectrow_array failed: MySQL server has gone away at filename.pm line 62. Do you Yahoo!?

Re: MySQL server has gone away?

2006-11-09 Thread Jon Molin
On 11/9/06, rami doqa [EMAIL PROTECTED] wrote: Hello, can anybody tell me why this Mysql error happens in some times and not all of the times: DBD::mysql::db selectrow_array failed: MySQL server has gone away at filename.pm line 62. Your script loses connection to the mysql server sometimes

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

2006-11-09 Thread Steffen Goeldner
amonotod wrote: Hello all, I'm trying to insert images into an Access database (they're small, and that's how the app was built, not my choice), but I'm running into errors. I'm using... I can reproduce this :-( [...] eval { use Win32::OLE; Win32::OLE-Option(CP =

RE: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Garrett, Philip \(MAN-Corporate\)
Jonathan Leffler wrote: On 11/8/06, Bart Lateur [EMAIL PROTECTED] wrote: [snip] 1) What's the best way to temporarily disable RaiseError when I want to have it enabled for the rest of the script? Say, for one SQL statement? $sth-{RaiseError} = 0; Or: $dbh-{RaiseError} = 0;

Re: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Bart Lateur
On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote: And 2), in a fetch loop, is it possible to adjust a property like {ReadLongLen}, and retry the same fetch without restarting the whole loop? Because this error typically happened several minutes into the loop. Highly unlikely. The

Re: DBD::ADO and Access IMAGE (OLE Object) fields...

2006-11-09 Thread amonotod
Steffen Goeldner [EMAIL PROTECTED] wrote: amonotod wrote: eval { use Win32::OLE; Win32::OLE-Option(CP = Win32::OLE::CP_UTF8); }; Looks like is has to do with UTF8. Commenting out (or moving it out of the eval{}) avoids (or hides?) the problem. Sorry, no further

Re: Retrying a fetch after an error, without restarting the whole loop?

2006-11-09 Thread Jonathan Leffler
On 11/9/06, Bart Lateur [EMAIL PROTECTED] wrote: On Wed, 8 Nov 2006 23:26:02 -0800, Jonathan Leffler wrote: Bart Lateur [EMAIL PROTECTED] asked: And 2), in a fetch loop, is it possible to adjust a property like {ReadLongLen}, and retry the same fetch without restarting the whole loop?

Re: MySQL server has gone away?

2006-11-09 Thread Daniel Kasak
rami doqa wrote: Hello, can anybody tell me why this Mysql error happens in some times and not all of the times: DBD::mysql::db selectrow_array failed: MySQL server has gone away at filename.pm line 62. For me, that usually means the database has crashed :( Check your MySQL logs to see if

Bind variable question

2006-11-09 Thread Berlage, Steve
Here is what I am trying to do: $UPDATE_COMPANY_STRING = ccompStreet = ?; $UPDATE_COMPANY_VALUE_STRING = \$tmpccompStreet; $sql=UPDATE clientcomp SET $UPDATE_COMPANY_STRING WHERE ccompid = ?; $sthUpdate = $dbh-prepare($sql); $sthUpdate-execute($UPDATE_COMPANY_VALUE_STRING,

RE: Bind variable question

2006-11-09 Thread Ronald J Kimball
Berlage, Steve [mailto:[EMAIL PROTECTED] wrote: $UPDATE_COMPANY_STRING = ccompStreet = ?; $UPDATE_COMPANY_VALUE_STRING = \$tmpccompStreet; $sql=UPDATE clientcomp SET $UPDATE_COMPANY_STRING WHERE ccompid = ?; $sthUpdate = $dbh-prepare($sql);

RE: Bind variable question

2006-11-09 Thread Reidy, Ron
Kindness it is ... Your statement only has one bind variable (?). The other bind variable is actually a Perl variable. Your execute will fail because of this. However, there is another issue. You cannot substitute bind variables in this manner. Your attempt to dynamically build column names

Bugs in the Module::Dependency

2006-11-09 Thread Throop, David R
Dear Tim Bunce I noticed some bugs in Dependency::Grapher. I'm installing from module-dependency-1.86.tar. I'm running under Solaris. * Some of the README files are missing. The Module-Dependency-1.86/README references README.EXAMPLES README.COMMANDS README.MODULES. But README and

Re: Bind variable question

2006-11-09 Thread Jonathan Leffler
On 11/9/06, Berlage, Steve [EMAIL PROTECTED] wrote: Here is what I am trying to do: $UPDATE_COMPANY_STRING = ccompStreet = ?; $UPDATE_COMPANY_VALUE_STRING = \$tmpccompStreet; $sql=UPDATE clientcomp SET $UPDATE_COMPANY_STRING WHERE ccompid = ?; $sthUpdate = $dbh-prepare($sql);