<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<font class="Apple-style-span" face="Tahoma" size="4"><span class="Apple-style-span" style="font-size: 10pt;">Thanks Marilyn,</span></font><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div><font class="Apple-style-span" face="Tahoma" size="4"><span class="Apple-style-span" style="font-size: 10pt;">You got me thinking that </span></font><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 13px;">maybe</span></font><font class="Apple-style-span" face="Tahoma" size="4"><span class="Apple-style-span" style="font-size: 10pt;"> it was a runtime issue with the Perl Interpreter running through Eclipse.</span></font></div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">Anyhow, when I run the myapp_server.pl from the windows command prompt I see the queries.</div><div style="font-family: Tahoma; font-size: 10pt; "><br></div><div style="font-family: Tahoma; font-size: 10pt; ">Blaine<br><br><hr id="stopSpelling">Date: Wed, 1 Dec 2010 15:16:23 -0800<br>Subject: Re: [Catalyst] Catalyst::Model::DBIC::Schema - Print Debug statement<br>From: marilyn@marilynburgess.com<br>To: catalyst@lists.scsys.co.uk<br><br>On linux I start the server with:<div><br></div><div>> DBIC_TRACE=1 <span class="ecxApple-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/" style="color:rgb(42, 93, 176)" target="_blank">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="ecxgmail_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="ecxgmail_quote" style="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>
<br>_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/</div> </body>
</html>