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