correct syntax for db api..

[eugene kim]

i'm trying to find correct syntax for this sql statement..


import pgdb

db=pgdb.connect(user='postgres',database='test')
cursor=db.cursor()

-----------------
cursor.execute('select url, visits from history where url= %s', (self.url))     
-------------
or
-----------------
sqlselect = 'select url, visits from history where url = %s '
cursor.execute(sqlselect % self.url)
----------------

didn't work

thx