Pyodbc - Running SQL Query with WHERE clause (syntax errors)

Question

I am using Pyodbc, and am connected to a database. I can easily pull out data where I am just using the SELECT and FROM statements.

However when I try to use a WHERE statement it is throwing syntax errors:

This is the code:

import pyodbc

conn = pyodbc.connect('DSN=QueryBuilder')
cursor = conn.cursor()
cursor.execute('SELECT * FROM dbo.Grantinformation WHERE HoldingOrganisationName = 'university of edinburgh'')

I get this error:

SyntaxError: invalid syntax

If i run:

SELECT * 
FROM dbo.Grantinformation
WHERE HoldingOrganisationName = 'university of edinburgh'

in SQL Server Management Studio the SQL runs fine, so it is obviously something that I am doing wrong with pyodbc?

Many thanks

Daniel Roseman · Accepted Answer · 2017-06-20 07:21:13Z

6

No, this is a simple Python syntax error. You have single quotes inside your sql string, so you need to use double quotes around the string itself:

cursor.execute("SELECT * FROM dbo.Grantinformation WHERE HoldingOrganisationName = 'university of edinburgh'")

answered Jun 20, 2017 at 7:21

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Nicholas Over a year ago

Whoops! Thank you Daniel!

Collectives™ on Stack Overflow

Pyodbc - Running SQL Query with WHERE clause (syntax errors)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related