# database is mysql
# web2py version: 1.91.6, which uses pymysql as mysql driver
# my codes is something like this
#####################################################################
import gluon.tools
content = gluon.tools.fetch("http://t.sina.com.cn/reg.php?
inviteCode=104174")
db.executesql("insert into hytest (conent)values(%s)",content)
#####################################################################

error occurs:
errorclass      <class 'gluon.contrib.pymysql.err.ProgrammingError'>
errno   1064
errorvalue      u'You have an error in your SQL syntax; check th...ail\\"
target=\\"_bank\\" href=\\"ht\' at line 1'

When I use MySQLdb instead of pymysql, everything is ok, so , maybe it
is pymysql's mistake

Reply via email to