Re: Interesting Problem regarding Parameters
- From: "Carlo Razzeto" <crazzeto@xxxxxxxxxxx>
- Date: Fri, 29 Jul 2005 10:32:28 -0400
Sorry for the double post.
Carlo,
"Carlo Razzeto" <crazzeto@xxxxxxxxxxx> wrote in message
news:Oh8WkaElFHA.2152@xxxxxxxxxxxxxxxxxxxxxxx
> Backgroud:
> My company is currently migrating to .Net from PHP for a number of
> reasons, however we have one slight problem we would very much like to
> solve before moving to .Net (ok, many but this one is a toughie).
>
> Problem:
> On our current PHP platform we have our own database abstraction class
> which inherits from the PEAR DB abstraction class. One of the major
> reasons why we did this is because we wanted to add automatic querie
> logging to our database connection object. Here is a brief snippit of code
> to demonstarte the functionality we currently have:
>
> //Creating DB connection objects
> $connection = mis_DB::connect( 'database-server', 'database' );
> $connection->addLog( 'file', '/log_path/filename.log', PEAR_LOG_MODE );
> $connection->setLogMask( MISDB_LOG_ALL );
>
> This will automatically log any queries thrown at at, for example (I'm
> using prepare and execute syntax for a reason that will be come clear in
> just a minute):
>
> /* Disclaimer, such a DB does not exist on my company DB server, but it
> should! */
> $query = "SELECT * FROM beer.beer_styles WHERE style = ?";
> $handle = $connection->prepare( $query );
> $result_object = $connection->execute( $handle, array( "Imperial
> Stout" ) );
>
> What our current database class will do (after executing the query) is
> logg the following message to the /log_path/filename.log file:
> Friday, July 29, 2005 8:41:10 AM [Informational] SELECT * FROM
> beer.beer_styles WHERE style = 'Imerial Stout'
>
> What we would like is to have some thing similar with our new .Net DB
> class, however the problem I'm running into is I don't know how to get the
> query that was actually executed on the server, what I mean by that is:
>
> //Assume I have a proper connection string
> OleDbConnection Connection = new OleDbConnection( ConnectionString );
> OleDbCommand Command = new OleDbCommand( "", Connection );
> Connection.Open();
>
> //Set the query with parmater then execute reader
> Command.CommandText = "SELECT * FROM beer.beer_styles WHERE style =
> @style";
> Command.Paramaters.Add( "@style", "Imperial Stout" );
> OleDbDataReader Reader = Command.ExecuteReader();
>
> How do I get the query that actually executed on our DB server, i.e.
> "SELECT * FROM beer.beer_styles WHERE style = 'Imperial Stout'", not
> "SELECT * FROM beer.beer_styles WHERE style = @style".
>
> Thanks for the help!
>
> ----------------------
> Carlo Razzeto
> carlo.razzeto@xxxxxxxxxxx
>
.
- References:
- Interesting Problem regarding Parameters
- From: Carlo Razzeto
- Interesting Problem regarding Parameters
- Prev by Date: Interesting Problem regarding Parameters
- Next by Date: Re: Interesting Problem regarding Parameters
- Previous by thread: Interesting Problem regarding Parameters
- Next by thread: Interesting Problem regarding Parameters
- Index(es):
Relevant Pages
|
