Re: hangs on $ENV{'QUERY_STRING'}

Well, I've managed to make some significant progress:  I got past that
hang (apparently modperl was having problems with the URL b/c some of
the values were being passed empty... i.e.,
"stage=4&eqtype=All&cont=&restrictflags=12"... notice that cont has no
value.

At any rate, I solved that problem by forcing the form that passes the
information in to always have at least a bare minimum of data in each
field... and it seems to be working.

My next problem, which took four hours to track down, is that it turns
out that mod_perl is choking on null values being retrieved from MySQL. 
I'm using DBI for the interface, and the actual fetch_row is performing
exactly the way it should... but when it tries to do anything with my
scalar once it has a null in it, it just chokes & sits there until it
times out.  Is this a known bug?  Is there a known fix for it, other
than ensuring I never have null values in my database?

Thanks,

Mike Forbes
mforbes@xxxxxxxxxx


On Wed, 2002-10-30 at 17:53, Michael Forbes wrote:
> My apologies in advance if this is something that's been described &
> solved before... I can't seem to find the answer in archival searches
> (maybe I'm just using the wrong terms).
> 
> At any rate, I have a fairly large script that I wrote when operating
> under Apache 1.3, perl 5.8.0, Redhat 7.3.  I'm now running Apache 2.0,
> perl 5.8.0, and Redhat 8.0... and it stopped working when I performed
> the upgrade.
> 
>  
> Anywhere, what's happening is that the code below this paragraph is just
> hanging...(on the second line, I've inserted a few "print
> 'debug<BR>\n';" lines in the real thing to make sure.) it does finally
> time out, without producing any output.
> 
> here's the relevant code:
> 
> $pass = "/cgi-bin/plaintextresult.cgi?$ENV{'QUERY_STRING'}";
> 
> print "<TD WIDTH='33%' ALIGN='CENTER' BGCOLOR='#222222'><A
> HREF=\"$pass\" target='printerfriendly'>Plain text version</A></TD>\n";
>         
> 
> 
> Thanks in advance, and again, sorry if this is a FAQ, I just couldn't
> find the answer anywhere.
> 
> -Mike Forbes
> mforbes@xxxxxxxxxx
> 
>