At 10:53 AM -0700 5/14/02, Scott Chapman wrote:
>How do I get the resulting SQL statement built by DBIx::Recordset to be
>logged somewhere so I can see it?
$DBIx::Recordset::Debug = 2;
or
set Debug when you open the database.
E.g.
new DBIx::Database({
'!DataSource' => $connect,
'!DBIAttr' => {RaiseError => 1, AutoCommit => 1},
'!Username' => $this->{username},
'!Password' => $this->{password},
'!KeepOpen' => 1,
'!Debug' => 2,
'!SaveAs' => 'Articles',
}) || die $DBI::errstr;
If you are using embperl it will be logged to the embperl log
tail -f /tmp/embperl.log | egrep DB:
gets them.
Otherwise I forget where it's logged, but it's documented in DBIx::Recordset
--
Kee Hinckley - Somewhere.Com, LLC
http://consulting.somewhere.com/
[EMAIL PROTECTED]
I'm not sure which upsets me more: that people are so unwilling to accept
responsibility for their own actions, or that they are so eager to regulate
everyone else's.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
