Re: insert string problems..

2007-10-28 Thread Marc 'BlackJack' Rintsch
On Sun, 28 Oct 2007 00:24:34 -0700, Abandoned wrote: > Hi.. > I want to insert some data to postgresql.. > My insert code: > yer="019" > cursor.execute("INSERT INTO ids_%s (id) VALUES (%s)", (yer, id)) > I don't want to use % when the insert operation. > > in this code give me this error: > psyco

Re: insert string problems..

2007-10-28 Thread Abandoned
On Oct 28, 9:45 am, Steven D'Aprano <[EMAIL PROTECTED] cybersource.com.au> wrote: > On Sun, 28 Oct 2007 00:24:34 -0700, Abandoned wrote: > > Hi.. > > I want to insert some data to postgresql.. My insert code: > > yer="019" > > cursor.execute("INSERT INTO ids_%s (id) VALUES (%s)", (yer, id)) I don't

Re: insert string problems..

2007-10-28 Thread Steven D'Aprano
On Sun, 28 Oct 2007 00:24:34 -0700, Abandoned wrote: > Hi.. > I want to insert some data to postgresql.. My insert code: > yer="019" > cursor.execute("INSERT INTO ids_%s (id) VALUES (%s)", (yer, id)) I don't > want to use % when the insert operation. > > in this code give me this error: > psycopg

Re: insert string problems..

2007-10-28 Thread Abandoned
Also.. a="123,245,1235,663" cursor.execute("SELECT id, name FROM data WHERE id in (%s)", (a,)) In this query must be: SELECT id, name FROM data WHERE id in (123,245,1235,663) but it looks: SELECT id, name FROM data WHERE id in ("123,245,1235,663") How can i delete " ? -- http://mail.python.org/ma

insert string problems..

2007-10-28 Thread Abandoned
Hi.. I want to insert some data to postgresql.. My insert code: yer="019" cursor.execute("INSERT INTO ids_%s (id) VALUES (%s)", (yer, id)) I don't want to use % when the insert operation. in this code give me this error: psycopg2.ProgrammingError: syntax error at or near "'019'" LINE 1: SELECT lin