Thanks Marilyn, You got me thinking that maybe it was a runtime issue with the Perl Interpreter running through Eclipse. Anyhow, when I run the myapp_server.pl from the windows command prompt I see the queries. Blaine
Date: Wed, 1 Dec 2010 15:16:23 -0800 Subject: Re: [Catalyst] Catalyst::Model::DBIC::Schema - Print Debug statement From: [email protected] To: [email protected] On linux I start the server with: > DBIC_TRACE=1 myapp_server.pl -r which does the trick. Not sure if the same will work under windows. Marilyn On Wed, Dec 1, 2010 at 3:03 PM, Blaine Everingham <[email protected]> wrote: I'm trying to see the queries the actual query code that is submitted to the database when I perform a find on a model. I've tried: 1) Adding $ENV{DBIC_TRACE}++ to the MyApp.pm 2) Setting the Windows7 Environment variable DBIC_TRACE to 1 3) Setting my run configuration in Eclispe with the arguments -d -r AND Environment DBIC_TRACE = 1 Each time I run the myapp_server.pl -d -r it does not show the query executed. Ideally Executing : $c->model("MyDatabase::UserAccount")->find({ realm => $c->user->auth_realm, key => $c->user->url }); Would show the query below in STDOUT SELECT * FROM UserAccount where realm = '<user realm>' AND key ='<user url>'; I'm running in a windows environment with strawberry perl and using Eclipse. _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/ _______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
