Re^2: DBI trace has limited output

Thanks a lot for your effort.I found what happens.I had to wrap the following in a BEGIN block at the top of the CGI script:

BEGIN { $ENV{DBI_TRACE}='15=/var/www/xx/dbitrace.log';use DBI; }

The output now shows everything including the sql statements and the data retrieved.
What does BEGIN do and why has it made such a big difference? I think it has something to do with the environment that Apache/CGI runs,like that Apache initializes something before the perl script runs? What do you think?

Comment on Re^2: DBI trace has limited output

Replies are listed 'Best First'.
Re^3: DBI trace has limited output by bliako (Abbot) on Oct 25, 2021 at 20:36 UTC
This is equivalent to `DBI_TRACE=15 perl myscript.pl`. Your solution looks to me to be the nuclear option. I would investigate further. With Apache, since Re: DBI trace has limited output (this has already done it for you without Apache.	[reply] [d/l]
Re^3: DBI trace has limited output by Anonymous Monk on Oct 25, 2021 at 11:24 UTC
"A BEGIN code block is executed as soon as possible, that is, the moment it is completely defined, even before the rest of the containing file (or string) is parsed." and use "is exactly equivalent to `BEGIN { require Module; Module->import( LIST ); }`" so it sets the variable before DBI is even loaded so DBI can pick it up immediately	[reply] [d/l]