Re: cx_Oracle clause IN using a variable

2012-10-17 Thread Beppe
Il giorno martedì 16 ottobre 2012 19:23:22 UTC+2, Hans Mulder ha scritto: > On 16/10/12 15:41:58, Beppe wrote: > > > Hi all, > > > I don't know if it is the correct place to set this question, however, > > > I'm using cx_Oracle to query an Oracle database. > > > I've a problem to use the IN cla

Re: cx_Oracle clause IN using a variable

2012-10-16 Thread Hans Mulder
On 16/10/12 15:41:58, Beppe wrote: > Hi all, > I don't know if it is the correct place to set this question, however, > I'm using cx_Oracle to query an Oracle database. > I've a problem to use the IN clause with a variable. > My statement is > > sql = "SELECT field1,field2,field3 > FROM m

Re: cx_Oracle clause IN using a variable

2012-10-16 Thread Ian Kelly
On Tue, Oct 16, 2012 at 7:41 AM, Beppe wrote: > Hi all, > I don't know if it is the correct place to set this question, however, The best place to ask questions about cx_Oracle would be the cx-oracle-users mailing list. > what is wrong? > suggestions? With the bind parameter you're only passing

cx_Oracle clause IN using a variable

2012-10-16 Thread Beppe
Hi all, I don't know if it is the correct place to set this question, however, I'm using cx_Oracle to query an Oracle database. I've a problem to use the IN clause with a variable. My statement is sql = "SELECT field1,field2,field3 FROM my_table WHERE field_3 IN (:arg_1)" where a