On Tue, 25 Feb 2003, Tim Bunce wrote:

> > While I was using 5.8 large data transfers via DBI failed consistently.
> > I have compared notes with others (including Lincoln Stein) and this
> > problem is easily reproduced.  In fact, I can't stop reproducing it. ;-)
> >
> A self-contained test case would be ideal!

Hi, I will try to put this together, meanwhile here is a summary:

I have a postgres table with 220 individual patient skills -
these skills become questions on a long form.  Another table
holding live patient records is queried and the returned values
serve as popup_menu() defaults

Tr ( td ( "$skill[0]" )                         <-- Here is the string/question
     td ( popup_menu( ...
                   -values=>['1 - Excellent', '2 - Adequate', '3 - Needs Attention',
                             '4 - Needs Immediate Attention', '5 - Not Applicable'],
                   -default=>"$row->{item_01}"  <-- Here is the returned value
                      ...

On wellworn test equipment (all ide, 64M RAM, clock speed of 300MHz) running
Slackware 8.1, perl 5.6.1, DBI 1.25, Apache 1.3.26, DBD-Pg 1.21, Postgres 7.3.1
this script runs.

On a brand new IBM eServer (LSI SCSI, 512M RAM, 2 GHz clock) running Redhat 8.0,
perl 5.8.0, DBI 1.28, Apache 2.0.40, DBD-Pg 1.21 the script hangs.
I tried commenting out the defaults, etc.  Only removing both queries allowed
the script to run.  The CGI form was not a problem, even when I doubled the
length as a test.

After installing 5.6.1 on the same IBM box, the script runs.

Thanks for pursuing this!
-----------------------------------------------------------------------
Thomas Good                                  e-mail: [EMAIL PROTECTED]
Programmer/Analyst                           phone:   (+1) 718.818.5528
Residential Services                         fax:     (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY         mobile:  (+1) 917.282.7359

Freedom is the right to yell theatre in a crowded fire. - Abbie Hoffman


Reply via email to