[Catalyst] How to show SQL in apache

[Matt S Trout]

On Wed, Jun 13, 2007 at 12:27:26PM +0800, Cookie wrote:
> Thanks for your answer.But I think it already can not work although I add
> $schema->storage->debug(1);
> in my code.I agree with you the output of sql is in the STDOUT.I will find
> some way of configurating the apache to record the STDOUT.

No it isn't.

STDERR is the default.

> BTW,If I want to know,if I used log4perl,Can I log the sql in my log
> file?Thanks.

Read the Storage::DBI docs and follow the references to provide a custom
debug object.

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director    Want a managed development or deployment platform?
 Shadowcat Systems Ltd.  Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/             http://www.shadowcatsystems.co.uk/