I'm a newbie and just started using the PDO module. In the Doc's if my
connection.paramstlye = 'pyformat' then
I pass params as '...WHERE name=%(name)s' but does not appear to work.
myRS=db.open("select * from sosord where csono='%s'"% mysono)
the above works.... but
myRS=db.open('select * from sosord where csono=%(mysono)s')
the above does not work
This is what should be passed
myRS=db.open("select * from sosord where csono='11532'")
So could someone explain what is happening
It seems that your paramstyle is: 'format'
Check the doc entry for paramstyle. Also, you can enquiry your connection
object to know which type is using with:
This will return the style your database uses.