On Thursday, May 2, 2002, at 10:37 , Jonathan E. Paton wrote:
> Don't forget to turn on autoflushing with "$|=1", or for long queries
> it will timeout.
Intellectually I agree with this, and I know that a part of
that is to get the 'message back' as quickly - but I have
never really understood
> > Don't forget to turn on autoflushing with "$|=1", or for long queries
> > it will timeout.
>
> Thanks for the tip. I guess I will find information about it in man DBI?
Opps, forgot to say that is a CGI issue.
Others have been explaining that one for yonks, try a google search on
"CGI Perl a
> From: Felix Geerinckx <[EMAIL PROTECTED]>
> Date: 2 May 2002 17:55:47 -
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL hangs.
>
> on Thu, 02 May 2002 17:08:47 GMT, Tor Hildrum wrote:
>
>> while (@arrangement) {
>> chomp;
>> my $test = 1 if
>> Now the code:
>> #!/usr/bin/perl
>> use Strict;
>> use CGI qw(:standard);
>> use DBI;
>
> Honour deserved for using 'strict', but you have forgotten
> to enable warnings. Strict ***MUST*** be lowercase otherwise
> on systems with case-sensitive filenames it will barf.
>
>> my $dbh = DBI->c
on Thu, 02 May 2002 17:08:47 GMT, Tor Hildrum wrote:
> while (@arrangement) {
> chomp;
> my $test = 1 if $_ eq $epost;
> }
> [...]
> When I try to run this script from either the command line or from a
> web-browser, it just hangs.
You are not removing anything from '@arrangement', so if i
> Now the code:
> #!/usr/bin/perl
> use Strict;
> use CGI qw(:standard);
> use DBI;
Honour deserved for using 'strict', but you have forgotten
to enable warnings. Strict ***MUST*** be lowercase otherwise
on systems with case-sensitive filenames it will barf.
> my $dbh = DBI->connect("DBI:mysql
First my database.
[localhost:~] tor% mysql -u tor -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.42
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use nuug
Reading table information for co
