problems with getting data into database

[Jannis Syntychakis]

hallo everybody,

I am using Python 2.6, SQL, Pyodbc.
i want to write data into the database, but i can't.

thats what i'm doing:

cnxn = pyodbc.connect('DRIVER={SQL Server};
SERVER=VIRTUALXP-41099\SQLEXPRESS; DATABASE=qcEcho')
cursor = cnxn.cursor()
cursor.execute("insert INTO tabel1
values(2,2)",'column1','column2')
cnxn.commit()

zo what i want is to write values (2,2) in colums: column1 and columd2
in tabel1 of database qcEcho,

anyone knows what i am doing wrong?

thanks in advance!

jannis

ps.

pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 2
parameters were supplied', 'HY000')
>>>

[John Hampton]

On 5/31/10 6:22 AM, Jannis Syntychakis wrote:
> cnxn = pyodbc.connect('DRIVER={SQL Server};
> SERVER=VIRTUALXP-41099\SQLEXPRESS; DATABASE=qcEcho')
> cursor = cnxn.cursor()
> cursor.execute("insert INTO tabel1
> values(2,2)",'column1','column2')
> cnxn.commit()

What the DBAPI thinks you want is to substitute the values "column1" and
"column2" into the query. However, you don't have any substitutions
defined in your query.

What you really want is something more like:

SQL = "insert into table1 (column1, column2) values (?, ?)"
cursor.execute(SQL, 2, 2)

Note, this is untested code.

-John

[Jannis Syntychakis]

it's working now! thanks! i had 2 () to much! thanks!

[vamsi.sa...@gmail.com]

how do we use the same in case of update? 

I used this, but it doesn't work

cur.execute ("update table set columnName= %s where ID = %s ",("test3","3"))

cur.commit()

[vamsi.sa...@gmail.com]

Wow I found the answer finally.

 cur.execute ("update tablename set columnName = (?) where ID = (?) ",("test4","4"))

[Michael Kleehammer]

That works, but you don't need the parens around the markers and you also don't need to put the parameters into a tuple.  The DBAPI specifies parameters be that way, but pyodbc supports both formats:

cur.execute("update tablename set columnName =? where id=?", "test4", "4")

[yangl...@gmail.com]

Do you know who would executemany() would work?