how to insert values into user inputted column using pyodbc

Question

im trying to insert values into a column that a user has asked to be changed which is called surnamereq and the user change which is called name1. money_spent is the name of the table and first_name is the column that the user is changing the value of.

This is how it should be written in SQL(i think):

INSERT INTO money_spent(first_name) WHERE last_name = surnamereq VALUES(name1)

This is what ive got in python:

cursor.execute("INSERT INTO money_spent(first_name) WHERE last_name = ?, surnamereq VALUES(name1)")

Thanks

If you are updating an existing row in the table then you need to use an UPDATE statement, not an INSERT statement. (INSERT is for adding a new row.) — Gord Thompson
– Gord Thompson, Commented Dec 14, 2018 at 21:26
cursor.execute(""" UPDATE money_spent SET first_name = ?, fname WHERE last_name = ?, surnamereq""") — Ryan pietras
– Ryan pietras, Commented Dec 15, 2018 at 10:19
And that gives me a pyodbc.Error: ('07002', '[07002] [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect (17) (SQLExecDirectW)') — Ryan pietras
– Ryan pietras, Commented Dec 15, 2018 at 10:20
It might be a problem because im using python variables in the cursor.execute command, if so how should i have an input for the user to assign a variable to? — Ryan pietras
– Ryan pietras, Commented Dec 15, 2018 at 10:24

Gord Thompson · Accepted Answer · 2018-12-15 13:10:10Z

1

The documentation for the .execute method shows that the form of the method call is

execute(sql, *parameters)

and states that

The optional parameters may be passed as a sequence, as specified by the DB API, or as individual values.

So, you could either do

surnamereq = 'Thompson'
fname = 'Gord'
#
sql = "UPDATE money_spent SET first_name = ? WHERE last_name = ?"
params = (fname, surnamereq)
cursor.execute(sql, params)

or

surnamereq = 'Thompson'
fname = 'Gord'
#
sql = "UPDATE money_spent SET first_name = ? WHERE last_name = ?"
cursor.execute(sql, fname, surnamereq)

Note that the second approach is a pyodbc-specific extension to the DB API.

answered Dec 15, 2018 at 13:10

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ryan pietras Over a year ago

What should i do if i get a Previous SQL was not a query. Error?

Ryan pietras Over a year ago

It does it when i use the for row in cursor.fetchall(): print (row) command at the end.

Collectives™ on Stack Overflow

how to insert values into user inputted column using pyodbc

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related