Re: [DB-SIG] mogrify/query for adodbapi

2011-02-15 Thread William Dode
On 14-02-2011, Federico Di Gregorio wrote: > This is an OpenPGP/MIME signed message (RFC 2440 and 3156) > --===1638910873== > Content-Type: multipart/signed; micalg=pgp-sha1; > protocol="application/pgp-signature"; > boundary="enig8B948CD4F063A9F68C5802DF" > > Th

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-14 Thread Federico Di Gregorio
[snip] On 14/02/11 15:49, William Dode wrote: > I would like to see the query after the binding. For example with > msaccess "insert into t (a), (?)", (True,) will insert -1 with > postgresql it will insert 1 > > Also i would like to can copy and paste the query for debugging. For > example wit

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-14 Thread Vernon Cole
There may be some help for you. ADO will read and write ACCESS data tables, so you can migrate your more challenging data communications tasks to Python and eventually replace your ACCESS application with something a bit more trustworthy. Vernon Cole (sent from my 'droid phone) On Feb 14, 2011 7:

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-14 Thread William Dode
On 14-02-2011, M.-A. Lemburg wrote: > William Dode wrote: >> On 13-02-2011, Vernon Cole wrote: >>> --===0804799855== >>> Content-Type: multipart/alternative; boundary=0016e644df66158a5b049c2cec40 >>> >>> --0016e644df66158a5b049c2cec40 >>> Content-Type: text/plain; charset=ISO-8859-1 >>>

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-14 Thread M.-A. Lemburg
William Dode wrote: > On 13-02-2011, Vernon Cole wrote: >> --===0804799855== >> Content-Type: multipart/alternative; boundary=0016e644df66158a5b049c2cec40 >> >> --0016e644df66158a5b049c2cec40 >> Content-Type: text/plain; charset=ISO-8859-1 >> Content-Transfer-Encoding: quoted-printable

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-13 Thread William Dode
On 13-02-2011, Vernon Cole wrote: > --===0804799855== > Content-Type: multipart/alternative; boundary=0016e644df66158a5b049c2cec40 > > --0016e644df66158a5b049c2cec40 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: quoted-printable > > This sounds like a handy

Re: [DB-SIG] mogrify/query for adodbapi

2011-02-13 Thread Vernon Cole
This sounds like a handy feature. Recent releases of adodbapi allow the programmer to specify the paramstyle she wishes to use. If she uses 'qmark' (the default) her query is used unchanged. If she uses 'named' or 'format', then her query is converted to 'qmark' before being used. The cursor sto

[DB-SIG] mogrify/query for adodbapi

2011-02-13 Thread William Dode
Hi, With psycopg2 I use "mogrify" or the "query" attribute to retrieve the exact sql query. It's very usefull for debugging. Could it be possible to have the same with adodbapi ? I mean, is it possible with ado to retrieve the sql query ? How do you do with other databases ? bye thanks to re