Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 071499FB534 for ; Mon, 28 May 2007 14:36:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 02964-04 for ; Mon, 28 May 2007 14:36:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 64EAF9FB4E6 for ; Mon, 28 May 2007 14:36:53 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so949634uge for ; Mon, 28 May 2007 10:36:52 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=PoGKK89rKWBM0dn5I7dHlJOUgwPYz1JOEsPkrKUrph71UuUG2BEwFdYUpO2F3APpkz0QhrNoAv7Aof5+rK1Pz1uMLR3gLr5VND6lEVUThO1PCx5hgaz1Y49CPggEQoVjfJpOtB5gDVqj+17Mp3vINH+mJ0H32S7lrly39uK/sug= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=YTRaw+y8AejaXQsDX6eNhWhmV9XamzUuAIwB1icAGJsjc6fl6K2xtdRcND9r6JHROr1QBbZwdsW10KTncHxtNDZinuz2xzoR2KWXA8SDCfriiyw/LlhNez0a+MqEV/BfLdKecj605N5GG4QLG/zqWcYti12v1I9qLV8jj/jfgEE= Received: by 10.82.169.4 with SMTP id r4mr11115987bue.1180373812054; Mon, 28 May 2007 10:36:52 -0700 (PDT) Received: by 10.82.135.7 with HTTP; Mon, 28 May 2007 10:36:52 -0700 (PDT) Message-ID: Date: Mon, 28 May 2007 18:36:52 +0100 From: "Oliveiros Cristina" To: pgsql-interfaces@postgresql.org Subject: Question on NpgsqlParameter object MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_178819_16955261.1180373812025" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.084 tagged_above=0 required=5 tests=AWL=0.287, BAYES_50=0.001, HTML_00_10=0.795, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200705/55 X-Sequence-Number: 6562 ------=_Part_178819_16955261.1180373812025 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, List. I am not 100% sure if this is the right list, if it isnt please kindly re-direct me to the proper list. I would like to see NpgsqlCommand.CommandText value after parameter substitution. I have a query that is not behaving correctly and I suspect strongly that it has to do with parameters getting instantiated in unexpected ways. How can I have access to query SQL text after parameter substitution ? I try to look at CommandText Property immediately before calling ExecuteReader() method, but I get the text with all parameters unsubstituted. Any Help/Comments/Advices deeply appreciated Thanks in advance Cheers, Oliveiros ------=_Part_178819_16955261.1180373812025 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi, List.

I am not 100% sure if this is the right list, if it isnt please kindly re-direct me to the proper list.

I would like to see NpgsqlCommand.CommandText value after parameter substitution. I have a query that is not behaving correctly and I suspect strongly that  it has to do with parameters getting instantiated in unexpected ways.

How can I have access to query SQL text after parameter substitution ?

I try to look at CommandText Property immediately before calling ExecuteReader() method, but I get the text with all parameters unsubstituted.

Any Help/Comments/Advices deeply appreciated

Thanks in advance

Cheers,
Oliveiros
------=_Part_178819_16955261.1180373812025--