SAP SQL Anywhere

Question

Is it possible to use Bind variables with Python?

I am using sqlanydb latest release and have tried without success each of the methods mentioned here

my preferred method is pyformat but this raises error:

select something from table where something = %(bindvar)s': b"Syntax error near '%' on line 1"

Answer 1

3	This works: sql = "select something from table where something = :bindvar" In pandas use the list method: pd.read_sql(sql, db, params=[bindvar]) permanent link answered 06 Jan '16, 07:03 toasteez 71●1●1●5 accept rate: 0% flat view

Answer 2

3

You can use the question mark format:

import sqlanydb
conn = sqlanydb.connect(dsn="SQL Anywhere 17 Demo",uid="dba",pwd="sql",charset="utf-8")
sql = "select Surname from GROUPO.Customers where city = ?"
cur = conn.cursor()
cur.execute(sql, ("Newmarket", ))
print(cur.fetchone()[0])
>  Phillips

permanent link

answered 07 Jan '16, 16:03

Tom Slee
1.3k●2●16●29
accept rate: 29%

flat view

SAP SQL Anywhere

Bind Variables Python

Follow this question

Related questions