Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D875A9FB7C0 for ; Mon, 28 May 2007 19:32:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 09455-08 for ; Mon, 28 May 2007 19:32:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web60715.mail.yahoo.com (web60715.mail.yahoo.com [209.73.178.218]) by postgresql.org (Postfix) with SMTP id 2690B9FB81E for ; Mon, 28 May 2007 19:32:13 -0300 (ADT) Received: (qmail 28899 invoked by uid 60001); 28 May 2007 22:32:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=hrP8nLJYLQ/piHiLk2rffaVnUnXSXa9Cw7zsBdiK1ZuvC18oCVGnQyyf/fLkiaYaGm3P3yCPn/IjOHleBv9FPUK+0s9QS7QVbzFyTobByrMTu7Jj8/D+n6fQCSj1QvFqRVune3MFJutB1WyAsc7UrUdHgfN33Ebd7n7axUuDjsc=; X-YMail-OSG: s4kT2SUVM1msICU9ipKowsVixa9PmVnZYd3boyppt80AIqCFVrh3L6rv9x6FlsZfzMMrAAjuqh4r9s2WzBWx4E54w_jlOz7nYaJt5J6odzy7dKNixth60tPQ Received: from [200.181.6.232] by web60715.mail.yahoo.com via HTTP; Mon, 28 May 2007 15:32:12 PDT X-Mailer: YahooMailRC/651.23.1 YahooMailWebService/0.7.41.14 Date: Mon, 28 May 2007 15:32:12 -0700 (PDT) From: "Francisco Figueiredo Jr." Subject: Res: Question on NpgsqlParameter object To: Oliveiros Cristina , pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-877605527-1180391532=:28356" Message-ID: <344577.28356.qm@web60715.mail.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/57 X-Sequence-Number: 6564 --0-877605527-1180391532=:28356 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0A=0AHi Oliveiros!=0A=0AUnfortunately it is not possible with current stat= e to get this text.=0A=0AYou will have to enable either Npgsql Log or postg= resql log.=0A=0AJust add those lines:=0A=0A// Enable logging.=0A NpgsqlE= ventLog.Level =3D LogLevel.Debug;=0A NpgsqlEventLog.LogName =3D "NpgsqlT= ests.LogFile";=0AIt will show you all the commands sent to server.=0A=0AYou= can also get support from Npgsql mail list and forum. Check out Npgsql pro= ject page:=0A=0Ahttp://npgsql.projects.postgresql.org=0A=0AI hope it helps.= =0A=0A=0A =0A--=0ARegards, =0AFrancisco Figueiredo Jr.=0Ahttp://fxjr.blogsp= ot.com=0A =0ANpgsql Lead Developer=0Ahttp://npgsql.projects.postgresql.org= =0A =0AMonoBrasil Project Founder Member=0Ahttp://monobrasil.softwarelivre.= org=0A =0A =0A"My grandfather once told me that there are two kinds of peop= le: those=0Awho work and those who take the credit. He told me to try to be= in the=0Afirst group; there was less competition there."=0A- Indira Gandhi= =0A=0A----- Mensagem original ----=0ADe: Oliveiros Cristina =0APara: pgsql-interfaces@postgresql.org=0AEnviadas: Segunda= -feira, 28 de Maio de 2007 14:36:52=0AAssunto: [INTERFACES] Question on Npg= sqlParameter object=0A=0AHi, List.=0A=0AI am not 100% sure if this is the r= ight list, if it isnt please kindly re-direct me to the proper list.=0A=0AI= would like to see NpgsqlCommand.CommandText value after parameter substitu= tion. 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.= =0A=0A=0AHow can I have access to query SQL text after parameter substituti= on ?=0A=0AI try to look at CommandText Property immediately before calling = ExecuteReader() method, but I get the text with all parameters unsubstitute= d.=0A=0A=0AAny Help/Comments/Advices deeply appreciated=0A=0AThanks in adva= nce=0A=0ACheers,=0AOliveiros=0A=0A=0A=0A=0A=0A=0A=0A_______________________= ___________________________=0AFale com seus amigos de gra=E7a com o novo Y= ahoo! Messenger =0Ahttp://br.messenger.yahoo.com/ --0-877605527-1180391532=:28356 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable


Hi Oliveiros!

Unfortunately it is not possib= le with current state to get this text.

You will have to enable eith= er Npgsql Log or postgresql log.

Just add those lines:

// Enable logging.
    NpgsqlEventLog.Level =3D LogLeve=
l.Debug;
    NpgsqlEventLog.LogName =3D "NpgsqlTests.LogFile";

= It will show you all the commands sent to server.

You can also get s= upport from Npgsql mail list and forum. Check out Npgsql project page:
<= br>http://npgsql.projects.postgresql.org

I hope it helps.<= br>

 
--
Regards,
 
Francisco F= igueiredo Jr.
http://fxjr.blogspot.com
 
 
MonoBrasil Project Founder = Member
http://monobrasil.softwarelivre.org
 
 
"My grandfather once told me that there are two kind= s of people: those
who work and those who take the credit. He told me to= try to be in the
first group; there was less competition there."
- I= ndira Gandhi


----- Mensagem original ----
De: Oli= veiros Cristina <oliveiros.cristina@gmail.com>
Para: pgsql-interfaces@postgresql.org
Enviadas: Segunda-feira, 28 de Maio de = 2007 14:36:52
Assunto: [INTERFACES] Question on NpgsqlParameter object
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 h= as to do with parameters getting instantiated in unexpected ways.=0A
How can I have access to query SQL text after parameter substitution ?
=
I try to look at CommandText Property immediately before calling Execut= eReader() method, but I get the text with all parameters unsubstituted.=0A<= br>
Any Help/Comments/Advices deeply appreciated

Thanks in advanc= e

Cheers,
Oliveiros
=0A


_______= ___________________________________________
Fale com seus amigos de gra= =E7a com o novo Yahoo! Messenger
http://br.messenger.yahoo.com/ = --0-877605527-1180391532=:28356--