On linux I start the server with:<div><br></div><div>> DBIC_TRACE=1 <meta charset="utf-8"><span class="Apple-style-span" style="font-family: arial, sans-serif; font-size: 13px; border-collapse: collapse; color: rgb(80, 0, 80); "><a href="http://myapp_server.pl/" target="_blank" style="color: rgb(42, 93, 176); ">myapp_server.pl</a> -r</span><br>
<br></div><div>which does the trick. Not sure if the same will work under windows.</div><div><br></div><div>Marilyn</div><div><br></div><div><br><div class="gmail_quote">On Wed, Dec 1, 2010 at 3:03 PM, Blaine Everingham <span dir="ltr"><<a href="mailto:grandmasterblaine@hotmail.com">grandmasterblaine@hotmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div><div></div><div class="h5">
<div>
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.<br><br>I've tried:<br><br>1) Adding $ENV{DBIC_TRACE}++ to the MyApp.pm<br>2) Setting the Windows7 Environment variable DBIC_TRACE to 1<br>
3) Setting my run configuration in Eclispe with the arguments -d -r AND Environment DBIC_TRACE = 1<br><br>Each time I run the <a href="http://myapp_server.pl" target="_blank">myapp_server.pl</a> -d -r it does not show the query executed.<br>
<br><br>Ideally Executing :<br><br>$c->model("MyDatabase::UserAccount")->find({ realm => $c->user->auth_realm, key => $c->user->url }); <br><br>Would show the query below in STDOUT<br>
<br>SELECT * FROM UserAccount where realm = '<user realm>' AND key ='<user url>';<br><br>I'm running in a windows environment with strawberry perl and using Eclipse.<br>                                            </div>
</div></div><br>_______________________________________________<br>
List: <a href="mailto:Catalyst@lists.scsys.co.uk">Catalyst@lists.scsys.co.uk</a><br>
Listinfo: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst</a><br>
Searchable archive: <a href="http://www.mail-archive.com/catalyst@lists.scsys.co.uk/" target="_blank">http://www.mail-archive.com/catalyst@lists.scsys.co.uk/</a><br>
Dev site: <a href="http://dev.catalyst.perl.org/" target="_blank">http://dev.catalyst.perl.org/</a><br>
<br></blockquote></div><br></div>