On Thu, 2 Sep 2004, Zhiliang Hu wrote:
I have following problem when tried to install perl DBD::mysql (on a Red
Hat Linux AS server 3.2.3-34, a dual-processor machine):
Multiple lines of
Unsuccessful stat on filename containing newline at
/usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm
Hi,
here's my problem: I've got a cgi script that must update a database thru
different user interactions, that means it start updating the database at the
first user 'OK' click, and continue for other two 'OK's. During these steps,
the cgi script is reloaded, thus the dbh is not the same among
Tim al,
DBD::mysql has had the ability to automatically reconnect to the server in the
event that the server closed the connection to the client. This is useful in the
event of timeouts in a mod_perl environment, so you can just connect to the
database and not have to worry about how long the
On Mon, Sep 06, 2004 at 02:01:07PM -0400, Rudy Lippan wrote:
Tim al,
DBD::mysql has had the ability to automatically reconnect to the server in the
event that the server closed the connection to the client. This is useful in the
event of timeouts in a mod_perl environment, so you can just
my $start_num = $dbh-selectrow_array( select my_id_seq.nextval from
dual);
my @seq = ( $start_num..100,000 ); # some end number
$sth-prepare ( insert into foo (my_id, data) values (?,?) );
$sth-bind_param( 1, shift(@seq) );
$sth-bind_param( 2, bar);
$sth-execute();
the 'select from
On Tue, 2004-08-31 at 07:36, Reidy, Ron wrote:
Use a before insert trigger to populate the column.
Triggers have the cachet of being a neat way to
automatically populate key columns, and I have
used them many times myself.
They are also much slower than the posters original code.
Jared
On Mon, 6 Sep 2004, Tim Bunce wrote:
So do we say that mysql_auto_reconnect will be disabled when server-side
prepared statements are in use?
Yes. That's what I'd recommend. Personally I'd disable it by default
and make applications ask for it explicitly if they want it.
It's just not
On Wed, 2004-09-01 at 17:46, [EMAIL PROTECTED] wrote:
Hello, I'm new to the list and am experiencing an issue that I hope some
of you all have dealt with previous and can lend me some advise on.. or
supply a possible fix.
Perl 5.6.1 with DBI module 1.32 operating on AIX 4.3. I'm