[Catalyst] How to show SQL in apache error_log?

[Cookie]

It seems useless.The apache error_log still don't output the sql.
Thanks for your reponse.



Date: Mon, 11 Jun 2007 09:41:04 +0300
From: "Octavian Rasnita" <orasnita at gmail.com>
Subject: Re: [Catalyst] How to show SQL in apache error_log?
To: "The elegant MVC web framework" <catalyst at lists.rawmode.org>
Message-ID: <001f01c7abf3$80f5bf20$251c320a at octavian>
Content-Type: text/plain; charset=3D"iso-8859-1"

You can put

$ENV{DBIC_TRACE}++;

in MyApp.pm

Octavian

 ----- Original Message ----- =3D

 From: Cookie =3D

 To: catalyst at lists.rawmode.org =3D

 Sent: Monday, June 11, 2007 7:01 AM
 Subject: [Catalyst] How to show SQL in apache error_log?


 As we know,if we use export DBIC_TRACE=3D3D1 and then we run the myapp_ser=
v=3D
er.pl,we can see the sql from the stander output.
 I want to show the sql in the apache error_log.I modify the httpd.conf fi=
=3D
le like this:
 setenv DBIC_TRACE 1
 But it seems useless.How can solve this problem?
 Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20070612/08fe3=
825/attachment.htm