DBI spec and parameter passing

[Gordon McMillan]

Skip wrote:

> Instead of doing the parameter interpolation yourself, try letting your
> database module do it for you, e.g.:
> 
>     c = db.cursor()
>     c.execute("""select id from city where"""
>               """ city = %s and"""
>               """ state = %s and"""
>               """ country = %s""", (city, state, country))

but Skip _meant_:

c.execute(""" select id from city where city = ? and state = ? 
and country = ?""", (city, state, country))


- Gordon