[DB-SIG] Re: oracledb usage

[Andrew Kuchling]

roy@mchip00.med.nyu.edu (Roy Smith) wrote:
>I think what you want is:
>
>   cursor.execute ('select id from annot where work = :1 and id != :2',
>                   [work_id, annot_id])
>
>Based on my initial confusion about this, and the frequency with which I
>see this question come up, I think this is probably one of the weak spots
>in the db package documentation.

	Indeed; there are only two paragraphs in the DB-API
specification about it, and no examples at all, so it's easy to miss
them.  Consider this another potential task for the DB-SIG.


	Andrew Kuchling
	amk@magnet.com
	http://starship.skyport.net/crew/amk/

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________